HR EDUCATION DETAIL Table
Stores education history details for individuals, including degree, degree type, institution, CIP/program classification, specialization, and completion dates. Users with the HR_PERSON_EMPLOYEE_FULL and HR_PERSON_EMPLOYEE_LIMITED roles can seethis view - users with access to records that are charged to their cost objects (ie. the persons are not in the users Org Units) are only allowed to see the directory-based information, no education information.Each row represents an education record for a person.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_DEGREE |
Alternate or free-text degree description when a standard degree code is not available. |
VARCHAR2 |
200 |
BEGIN_DATE |
Begin date of the education period or program, if available. |
DATE |
|
CIP_KEY |
CIP (Classification of Instructional Programs) key identifying the program/field of study. |
VARCHAR2 |
6 |
DEGREE_COMPLETION_MONTH |
Month in which the degree was completed (MM). |
VARCHAR2 |
2 |
DEGREE_COMPLETION_YEAR |
Year in which the degree was completed (YYYY). |
VARCHAR2 |
4 |
END_DATE |
End date of the education period or program, if available. |
DATE |
|
HR_DEGREE_DESC |
Description of the academic degree awarded. |
VARCHAR2 |
40 |
HR_DEGREE_KEY |
Degree key identifying the academic degree awarded. |
VARCHAR2 |
2 |
HR_DEGREE_TYPE_DESC |
Description of the degree type classification. |
VARCHAR2 |
40 |
HR_DEGREE_TYPE_KEY |
Degree type key identifying the degree classification (e.g., level or category). |
VARCHAR2 |
2 |
HR_EDU_INSTITUTION_KEY |
Identifier for the educational institution associated with the education record. |
VARCHAR2 |
6 |
HR_EDU_SPECIALIZATION |
Specialization, major, or concentration associated with the degree or program of study. |
VARCHAR2 |
200 |
INSTITUTE_SOURCE_DESC |
Description of the source system or institute providing the education record. |
VARCHAR2 |
50 |
IS_TERM_DEGREE |
Indicator identifying whether this record represents the terminal degree for the individual (Y/N). |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Date the education record was last updated in the source system. |
DATE |
|
LAST_UPDATE_USER |
User or system identifier that last updated the education record in the source system. |
VARCHAR2 |
12 |
MIT_ID |
MIT ID number of the individual. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |