ATB_AUTH_ENTITIES

Description: |
The Auth Entities table contains information about the providers and locations associated with an authorization request. A row in this table represents a single entity, with the data columns representing specific pieces of information about the entity.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
AUTH_BUNDLE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | AUTH_BUNDLE_ID | NUMERIC | No |
The unique identifier (.1 item) for the auth bundle record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | ENTITY_ID_REF | VARCHAR | No |
The unique identifier for the entity related line. Unique among all related group lines on the Auth Bundle.
4 | AUTH_ENTITY_TYPE_C_NAME | VARCHAR | No |
The Auth Entity Type category ID for this auth entity.
May contain organization-specific values: No
Category Entries:
Provider
Facility
5 | ENTITY_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
6 | ENTITY_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
7 | ENTITY_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
8 | ENTITY_VENDOR_ID_VENDOR_NAME | VARCHAR | No |
The name of the vendor.
9 | ENTITY_HOUSE_NUM | VARCHAR | No |
The house number associated with the entity's address information.
10 | ENTITY_CITY | VARCHAR | No |
The city associated with the entity's address information.
11 | ENTITY_STATE_C_NAME | VARCHAR | No |
The State category ID for this auth entity's address information.
May contain organization-specific values: Yes
12 | ENTITY_ZIP | VARCHAR | No |
The ZIP code associated with the entity's address information.
13 | ENTITY_DISTRICT_C_NAME | VARCHAR | No |
The District category ID for this auth entity's address information.
May contain organization-specific values: Yes
14 | ENTITY_COUNTY_2_C_NAME | VARCHAR | No |
The County category ID for this auth entity's address information.
May contain organization-specific values: Yes
15 | ENTITY_COUNTRY_2_C_NAME | VARCHAR | No |
The Country category ID for this auth entity's address information.
May contain organization-specific values: Yes
16 | ENTITY_ORG_NAME | VARCHAR | No |
The entity's organization name, only used for entities that are locations (as opposed to providers).
17 | ENTITY_FIRST_NAME | VARCHAR | No |
The entity's first name, usually relevant to provider type entities.
18 | ENTITY_MIDDLE_NAME | VARCHAR | No |
The entity's middle name, usually relevant to provider type entities.
19 | ENTITY_LAST_NAME | VARCHAR | No |
The entity's last name, usually relevant to provider type entities.
20 | ENTITY_NAME_SUFFIX_C_NAME | VARCHAR | No |
The Suffix category ID for this auth entity's name information.
May contain organization-specific values: Yes
Category Entries:
Sr.
Jr.
II
III
IV
V
21 | ENTITY_AUTH_ROLE_C_NAME | VARCHAR | No |
The Auth Entity Role category ID for this auth entity's auth role.
May contain organization-specific values: No
Category Entries:
Requester
Ordering Provider
Primary Care Provider
Referring Provider
Service Provider
Service Location
Service Facility
Attending Provider
Admitting Provider
Operating Provider
Service-Level Service Provider
Referring Location
22 | ENTITY_PRIMARY_TAXONOMY | VARCHAR | No |
The primary taxonomy code used for this entity.