Penn Computing

University of Pennsylvania
Penn Computing << go backback

FIS_DEGREE_TYPE_LIST Table
   Tables and Data Elements   Faculty Home   Data Warehouse Home

FIS_DEGREE_TYPE_LIST Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
DISPLAY_INDEX

Indexed - no
Format - number(12)
May be null - yes

Sequence number used to determine the order that the list of values will display in the application drop down list.

EDUCATION_LEVEL

Indexed - no
Format - varchar2(2)
May be null? yes

A numeric code indicating the level of education completed by the individual, as input in the Faculty Information System (FIS). Use this to join to the FIS_ED_LEVEL_LIST table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the description of the education level.

EFFECTIVE_DT

Indexed - no
Format - date
May be null? yes

The effective start date of the lookup table value.

EXPIRATION_DATE

Indexed - no
Format - date
May be null? yes

The effective end date of the lookup table value.

MESSAGE_ID

Indexed - yes (primary key)
Format - number(12)
May be null? no

The unique key used to join to the FIS_DEGREE table on the DEGREE field.
NAME_FRIENDLY

Indexed - no
Format - varchar2(200)
May be null? yes

The abbreviation of the degree.

Examples: B.A., D.D.M, Ph.D.

NAME_SYSTEM

Indexed - no
Format - varchar2(100)
May be null? yes

The system abbreviation used to identify the lookup value.
UPD_DT

Indexed - no
Format - date
May be null? no

The date the record was last updated.
UPD_ID

Indexed - no
Format - varchar2(12)
May be null? no

The Penn ID of the person who last updated the record.
USED_AS_EQUIVALENT

Indexed - no
Format - char(1)
May be null? no

A Yes/No flag indicating if the degree is used in the list of values in FIS as an equivelant degree.

FIS_DEGREE_TYPE_LIST Table
   Tables and Data Elements   Faculty Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania