Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR EDUCATION DETAIL Table


Data about degrees earned by MIT employees. This information is self reported using the SAP Self-Service application.


Field Name

Description

Data Type

Length

ALTERNATE_DEGREE

XXX

VARCHAR2

200

BEGIN_DATE

Date when the transaction starts become effective.

DATE

8

CIP_KEY

XXX

VARCHAR2

7

DEGREE_COMPLETION_MONTH

Month the degree was finished

VARCHAR2

2

DEGREE_COMPLETION_YEAR

Year the degree was finished

VARCHAR2

4

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_DEGREE_DESC

XXX

VARCHAR2

40

HR_DEGREE_KEY

XXX

VARCHAR2

2

HR_DEGREE_TYPE_DESC

XXX

VARCHAR2

40

HR_DEGREE_TYPE_KEY

XXX

VARCHAR2

2

HR_EDU_INSTITUTION_KEY

XXX

VARCHAR2

6

HR_EDU_SPECIALIZATION

XXX

VARCHAR2

40

INSTITUTE_SOURCE_DESC

XXX

VARCHAR2

50

IS_TERM_DEGREE

Is this a terminal degree? Y, N.

VARCHAR2

1

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

8

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

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