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