TC_REQUEST_CNCT_LOG

Description: |
This table stores information about the contacts associated with Transfer Center requests.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COMM_ID | NUMERIC | No |
The unique identifier for the Transfer Center request.
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_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.
4 | CONTACT_ROLE_C_NAME | VARCHAR | No |
This item stores the role of a contact on the contact log.
May contain organization-specific values: Yes
Category Entries:
Referring Provider
Accepting Provider
Requestor
5 | CONTACT_NAME | VARCHAR | No |
This item stores the name of the person associated with a given entry in the contact log.
6 | CONTACT_PH_NUM | VARCHAR | No |
This item stores the phone number for an entry in the contact log.
7 | CONTACT_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
8 | FROM_REF_LOC_YN | VARCHAR | No |
This item specifies whether this contact is associated with the referring location of a Transfer Center request.
May contain organization-specific values: No
Category Entries:
No
Yes
9 | CNCT_IS_ADMT_PROV_YN | VARCHAR | No |
Indicates whether the associated contact an admitting provider for a location . 'Y' indicates that they are. 'N' or NULL indicates that they are not the admitting provider.
The category values for this column were already listed for column: FROM_REF_LOC_YN
10 | CONTACT_HOSP_SERV_C_NAME | VARCHAR | No |
The contact's related service
May contain organization-specific values: Yes