FIS_CONTINGENCY Table - Data Element Index   Tables and Data Elements   Faculty Home   Data Warehouse Home

FIS_CONTINGENCY Table

Note: This table is no longer updated, following the retirement of the Faculty Information System (FIS) and the implementation Interfolio@Penn and Workday@Penn in July 2019.

Explanation
This table contains data about individual contigencies (e.g., visa, residency, administrative or degree-related) associated with actions.

Common Uses
Displaying details of contigencies associated with an individual action.

CONTINGENCY_ID

CONTINGENCY_ID

FIS_ACTION
FIS_PSC_CONTINGEN_TYPE_LOOKUP

• Contigencies are related to individual actions, based on associated ACTION_ID.
• If the contigency has been satisfied, it will be noted in the COMPLETION_DT column. The FIS_ACTION.COMPLETION_DATE is the date on which a contingent action has all of its contingencies satisfied.
  

FIS_CONTINGENCY Table - Data Element Index   Tables and Data Elements   Faculty Home   Data Warehouse Home