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. |