Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR OBJ RELATION FAC SPONSOR Table


XXX


Field Name

Description

Data Type

Length

HR_OBJECT_CODE

XXX

VARCHAR2

8

HR_OBJECT_RELATIONSHIP

XXX

VARCHAR2

25

HR_OBJECT_RELATIONSHIP_CODE

XXX

VARCHAR2

4

HR_OBJECT_RELATION_END_DATE

XXX

DATE

HR_OBJECT_RELATION_START_DATE

XXX

DATE

HR_OBJECT_TYPE

XXX

VARCHAR2

25

HR_OBJECT_TYPE_CODE

XXX

VARCHAR2

2

HR_OBJECT_WITH_TYPE

XXX

VARCHAR2

10

HR_RELATED_OBJECT_CODE

XXX

VARCHAR2

45

HR_RELATED_OBJECT_TYPE

XXX

VARCHAR2

25

HR_RELATED_OBJECT_TYPE_CODE

XXX

VARCHAR2

2

HR_RELATED_OBJECT_WITH_TYPE

XXX

VARCHAR2

47

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

RELATIONSHIP_ACTIVE_FLG

XXX

CHAR

WAREHOUSE_LOAD_DATE

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

DATE