ATB_AUTH_CONTACTS
Description:
This table stores contacts relevant to the authorization.

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 CONTACT_ID_REF VARCHAR No
The reference ID for this particular authorization contact line.
4 AUTH_CONTACT_TYPE_C_NAME VARCHAR No
The broad categorization for this particular contact, for example differentiating between an administrative point of contact or a payer delegate.
May contain organization-specific values: No
Category Entries:
Payer Delegate
5 CONTACT_HOUSE_NUM VARCHAR No
The house number associated with the contact's address information.
6 CONTACT_CITY VARCHAR No
The city associated with the contact's address information.
7 CONTACT_TAX_STATE_C_NAME VARCHAR No
The state associated with the contact's address information.
May contain organization-specific values: Yes
8 CONTACT_ZIP VARCHAR No
The ZIP code associated with the contact's address information.
9 CONTACT_DISTRICT_C_NAME VARCHAR No
The district associated with the contact's address information.
May contain organization-specific values: Yes
10 CONTACT_COUNTY_2_C_NAME VARCHAR No
The county associated with the contact's address information.
May contain organization-specific values: Yes
11 CONTACT_COUNTRY_2_C_NAME VARCHAR No
The country associated with the contact's address information.
May contain organization-specific values: Yes
12 CONTACT_ORG_NAME VARCHAR No
The contact's organization name.
13 CONTACT_FIRST_NAME VARCHAR No
The contact's first name.
14 CONTACT_MIDDLE_NAME VARCHAR No
The contact's middle name.
15 CONTACT_LAST_NAME VARCHAR No
The contact's last name.
16 CONTACT_SUFFIX_C_NAME VARCHAR No
The contact's name suffix.
May contain organization-specific values: Yes
Category Entries:
Sr.
Jr.
II
III
IV
V
17 CONTACT_PHONE_NUM VARCHAR No
The contact's phone number.
18 CONTACT_FAX_NUMBER VARCHAR No
The contact's fax number.
19 CONTACT_EMAIL VARCHAR No
The contact's email address.
20 CONTACT_URL VARCHAR No
The contact's URL.
21 CONTACT_NAME_FOR_LN VARCHAR No
The contact name of the person or place that should be contacted if contacting the contact referenced in the rest of this line.