| Data element |
Definition |
| ACTION_ID
Indexed - no
Format - number
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. |
COMPLETION_DT
Indexed - no
Format - date
May be null - yes |
The actual date on which the contingency was satisfied. |
CONTINGENCY_ID
Indexed - yes (primary key)
Format - number
May be null? no |
A unique identifier of each contingency record. A single action may have multiple contingencies. |
|
CREATE_DT
Indexed - no
Format - date
May be null? no
|
The creation date of the record.
|
| CREATE_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who created the record. |
| NOTES
Indexed - no
Format - varchar2(250)
May be null? yes
|
Additional information pertaining to the contingency.
|
| REQUIRED_BY
Indexed - no
Format - date
May be null? yes |
The date by which the contingency must be satisfied.
|
| TYPE_CD
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the type of contingency.Use this to join to the FIS_PSC_CONTINGEN_TYPE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the contingency type description. |
