PRIORITY_AUDIT_TRL
Description:
Table to track changes to the priority of a transport request.

Primary Key
Column Name Ordinal Position
TRANSPORT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TRANSPORT_ID NUMERIC No
The unique ID of the Transport Request 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 NEW_PRIORITY_C_NAME VARCHAR No
The new transport request priority in the audit trail.
May contain organization-specific values: No
Category Entries:
Stat
High
Normal
Low
4 OLD_PRIORITY_C_NAME VARCHAR No
The old transport request priority in the audit trail
The category values for this column were already listed for column: NEW_PRIORITY_C_NAME
5 PRIOR_CHNG_DTTM DATETIME (UTC) No
The instant at which a transport request priority was changed.
6 PRIOR_CHNG_USER_ID VARCHAR No
The unique ID of the user who changed the priority of this transport request.
7 PRIOR_CHNG_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.