HR EMPLOYMENT CIP DETAIL Table
Stores employee Classification of Instructional Programs (CIP)?related education and employment details, including degree context and effective dates, used for HR reporting and compliance analytics. Users with the HR_PERSON_EMPLOYEE_FULL and HR_PERSON_EMPLOYEE_LIMITED roles can see this 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 employment cip information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BEGIN_DATE |
Effective start date of the employment CIP record. |
DATE |
|
END_DATE |
Effective end date of the employment CIP record, if applicable. |
DATE |
|
HR_CIP_KEY |
Foreign key identifying the CIP code associated with the employee?s education or employment record. |
VARCHAR2 |
6 |
HR_DEGREE_DESC |
Description of the academic degree associated with the CIP record. |
VARCHAR2 |
40 |
HR_EMPLOYMENT_CIP_TYPE_KEY |
Foreign key identifying the type of employment-related CIP record. |
VARCHAR2 |
2 |
MIT_ID |
MIT ID number of the employee. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PROGRAM_CODE_DESC |
Description of the academic program or CIP program code. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |