Data element |
Definition |
ACTION_ID
Indexed - no
Format - integer
May be null? no |
The unique identifier on each action. This value is assigned by the FIS system and is not visible from the application interface. It is intended solely for the internal use in the system. |
COMMITMENT_ID
Indexed - yes (primary key)
Format - number
May be null - no |
The unique identifier of each commitment associated with an action. A single action may have multiple commitments.
|
COMMITMENT_TYPE
Indexed - no
Format - number(12)
May be null? no
|
A numeric code indicating the type of commitment.Use this to join to the FIS_COMMITMENT_TYPE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the associated description (e.g., Computer, Equipment, Lab Space).
|
CREATE_DT
Indexed - no
Format - date
May be null? no
|
The date the commitment record was created. |
CREATE_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who created the record. |