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.