Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP WORKLOAD ABSENTEE Table


XXX


Field Name

Description

Data Type

Length

ABSENTEE_ID

XXX

NUMBER

12

LEAVE_END_DATE

XXX

DATE

LEAVE_START_DATE

XXX

DATE

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

40

UPDATE_TIMESTAMP

Date that a record was last updated by OSP.

DATE

UPDATE_USER

Userid of the person who last updated this record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE