| Data element |
Definition |
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.
|
| DEGREE
Indexed - no
Format - number(22)
May be null? yes
|
A numeric code indicating the type of degree. Use this to join to the FIS_DEGREE_TYPE_LIST table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the degree type description.
|
| EDUCATION_LEVEL_YEAR
Indexed - no
Format - number(22)
May be null? yes |
The year in which the individual attained the degree. |
| EQUIVALENT
Indexed - no
Format - number(22)
May be null? yes |
The equivelant degree, as entered into FIS. |
| FASDA_ID
Indexed - no
Format - number
May be null? no
|
A unique system identifier assigned to each unique faculty member in the FIS_FACULTY table. This number is not used in other data collections, and should not be used for reporting. |
| FIELD_OF_DEGREE
Indexed - no
Format - varchar2(300)
May be null? yes |
The description of the academic field of the degree, as entered into FIS. |
| ID
Indexed - yes (primary key)
Format - number
May be null? no |
A unique identifier of each degree associated with an action. A single action may have multiple degrees. |
| INSTITUTION
Indexed - no
Format - varchar2(300)
May be null? yes |
The institution where the degree was awarded, as entered into FIS. |
| TERMINAL_DEGREE
Indexed - no
Format - char(1)
May be null? yes |
A Yes/No field used to indicate if the degree is a terminal one. |
