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 |
---|---|---|---|
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_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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |