TC_REQUEST_STATUS_MOD_HX
Description:
This table stores information related to the request status modifier change history for Transfer Center requests.

Primary Key
Column Name Ordinal Position
COMM_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TC_REQUEST_STATUS_MOD_C_NAME VARCHAR No
This item stores the audit trail for the request status modifier changes to the Transfer Center request.
May contain organization-specific values: Yes
Category Entries:
None
Future
2 REQUEST_MOD_UPDATE_UTC_DTTM DATETIME (UTC) No
This item specifies the instant when the Transfer Center request's status modifier changed.
3 TRANS_AUD_TC_FUTURE_RSN_C_NAME VARCHAR No
This item stores the audit trail for the future reason changes to the Transfer Center request.
May contain organization-specific values: Yes
Category Entries:
No Capacity
Procedural Case
Financial Approval
4 TRANSFER_AUDIT_FUTURE_UTC_DTTM DATETIME (UTC) No
This item stores the audit trail for the future date changes to the Transfer Center request.
5 COMM_ID NUMERIC No
The unique identifier (.1 item) for the communication record.
6 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
7 TRANS_MOD_AUD_USER_ID VARCHAR No
This item stores the user who changed the request status modifier for the Transfer Center request.
8 TRANS_MOD_AUD_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.