TC_REQUEST_PROV_DOC

Description:

This contains the decisions that were made by potential accepting providers about whether to accept or decline a Transfer Center request.

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 communication 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_IDNT	INTEGER	No
	This stores the line number of a Contact Log entry that made a decision on whether or not to accept a Transfer Center request.
4	LOC_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
5	PAT_SERVICE_C_NAME	VARCHAR	No
	The hospital service category ID for which a decision was made about whether or not to accept a Transfer Center request. May contain organization-specific values: Yes
6	PROV_APPROVED_YN	VARCHAR	No
	Indicates whether a provider approved or declined a Transfer Center request. 'Y' indicates that the provider approved the transfer. 'N' indicates that they did not approve the transfer. May contain organization-specific values: No Category Entries: No Yes
7	DECISION_INST_DTTM	DATETIME (UTC)	No
	Represents the instant at which a decision was made to accept or decline a Transfer Center request.
8	TC_PROV_DECLN_RSN_C_NAME	VARCHAR	No
	The decline reason category ID that specifies why a provider declined a Transfer Center request. May contain organization-specific values: Yes
9	ADMT_PROV_YN	VARCHAR	No
	Indicates whether this decision was also where the provider was decided to be the admitting provider for the resultant encounter of the Transfer Center request. 'Y' indicates that the provider will be the admitting provider. 'N' indicates that the provider will not be the admitting provider. The category values for this column were already listed for column: PROV_APPROVED_YN
10	ASSOCIATED_CALL_ID	VARCHAR	No
	The ID of the call record on which a decision was made.
11	CURRENT_YN	VARCHAR	No
	Indicates whether this decision is current or has been overridden by a later decision. 'Y' indicates that this decision is still current, 'N' indicates that this decision has been overridden by a later one. The category values for this column were already listed for column: PROV_APPROVED_YN
12	LOC_IS_REF_YN	VARCHAR	No
	This indicates whether the decision was made for the referring facility of the Transfer Center request before a referring facility was actually entered. 'Y' indicates that this decision was made for the referring facility. 'N' indicates that this decision was not made for the referring facility. The category values for this column were already listed for column: PROV_APPROVED_YN