TC_REQUEST_STATUS_HX

Description:

This table stores information related to the status change history for 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 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	REQUEST_STATUS_C_NAME	VARCHAR	No
	This item stores the audit trail for the status of the request. May contain organization-specific values: No Category Entries: Pending Accepted Declined Completed Voided Canceled
4	STATUS_UPDATE_UTC_DTTM	DATETIME (UTC)	No
	The datetime at which the request's status changed, stored in UTC. For local time, use TC_REQUEST_STATUS_HX.STATUS_UPDATE_LOCAL_DTTM.
5	STATUS_UPDATE_USER_ID	VARCHAR	No
	This item stores the user who changed the status of the request.
6	STATUS_UPDATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	DEST_DECLINE_RSN_C_NAME	VARCHAR	No
	This item stores the audit trail for the decline reason of the destination planning record. May contain organization-specific values: Yes Category Entries: Transfer not medically appropriate Hospital at capacity Patient out of network Auto-declined
8	CANCEL_STATUS_RSN_C_NAME	VARCHAR	No
	This item stores the audit trail for the cancel reason of the request. May contain organization-specific values: Yes Category Entries: Patient declined transfer Took too long to respond Referring location pulled request Patient condition not suitable for transfer Transfer request order canceled Created in error Duplicate request
9	STATUS_UPDATE_LOCAL_DTTM	DATETIME (Local)	No
	The datetime at which the request's status changed, stored in local time. For UTC, use TC_REQUEST_STATUS_HX.STATUS_UPDATE_UTC_DTTM.