Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LSO REGISTRATION DETAIL Table


View exposing learning and development registration detail including status, attendee, session, and timing attributes.


Field Name

Description

Data Type

Length

HR_JOB_KEY

Surrogate key identifying the hr job.

VARCHAR2

9

HR_ORG_UNIT_KEY

Surrogate key identifying the hr org unit.

VARCHAR2

9

HR_POSITION_KEY

Surrogate key identifying the hr position.

VARCHAR2

9

LSO_ATTENDEE_KEY

Surrogate key identifying the lso attendee.

VARCHAR2

9

LSO_COURSE_KEY

Surrogate key identifying the lso course.

VARCHAR2

9

LSO_REGISTRATION_FEE

Lso registration fee associated with the record.

NUMBER

17,2

LSO_REGISTRATION_STATUS_DATE

Date associated with lso registration status.

DATE

LSO_REGISTRATION_STATUS_KEY

Surrogate key identifying the lso registration status.

VARCHAR2

11

LSO_SESSION_CODE

Code identifying lso session.

VARCHAR2

10

LSO_SESSION_END_DATE

Date associated with lso session end.

DATE

LSO_SESSION_START_DATE

Date associated with lso session start.

DATE

MIT_ID

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

VARCHAR2

9

RECORD_COUNTER

Record counter associated with the record.

NUMBER

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE