HR EMPLOYMENT CIP DETAIL Table
Table containing information about MIT employees' CIP(Classification of Instructional Programs) records, 2000 Edition, as published by the National Center for Education Statistics in April 2002.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BEGIN_DATE |
Date when the transaction starts become effective. |
DATE |
8 |
END_DATE |
Specific to HR_POSITION_DETAIL: For filled positions, End Date equals Appointment End Date. For open-ended appointments, this date is usually 12/31/2999. For Closed Positions, the End Date is the delimit date on the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the latest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the end of the term. For STIP, this is set to the latest date for this account in the term in the stipend distribution section in the RPAGAAID form in MITSIS. UNMATCHED payroll has this set to the latest date in the unmatched Payroll records. In all other tables, END DATE is the thru date of the transaction. |
DATE |
8 |
HR_CIP_KEY |
This field should be used to join HR_CIP table with HR_EMPLOYMENT_CIP_DETAIL table. This field should only be used for linking tables together, NOT for reporting |
VARCHAR2 |
6 |
HR_DEGREE_DESC |
XXX |
VARCHAR2 |
40 |
HR_EMPLOYMENT_CIP_TYPE_KEY |
This field should be used to join HR_EMPLOYMENT_CIP_TYPE table to HR_EMPLOYMENT_CIP_DETAIL table. This field should only be used for linking tables together, NOT for reporting |
VARCHAR2 |
2 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PROGRAM_CODE_DESC |
XXX |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |