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.