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

FIS_DEGREE 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 information about faculty members' academic degrees.

Common Uses
Displaying details (degree type, year, insitution, etc.) about an individual faculty member's academic degree(s).

ID

ID

FIS_DEGREE_TYPE_LIST
FIS_FACULTY

Cautions

• Degree information is maintained within FIS, and is dependant upon data entry.
• In order to determine degree(s) held by an individual faculty member, refer to the FIS_DEGREE_TYPE_LIST table, using DEGREE_TYPE to join to FIS_DEGREE_TYPE_LIST.MESSAGE_ID, and use FASDA_ID to join to the FIS_FACULTY table.

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