Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LSO REGISTRATION DETAIL Table


Fact table for reporting on registrations in E-learning module


Field Name

Description

Data Type

Length

HR_JOB_KEY

This field should be used to join HR_POSITION and HR_JOB tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions.

VARCHAR2

10

HR_ORG_UNIT_KEY

This field should be used to join HR_ORG_UNIT and HR_ORG_UNIT_HIERARCHY tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions.

VARCHAR2

8

HR_POSITION_KEY

This field should be used to join HR_POSITION and HR_POSITION_LIMITED tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions.

VARCHAR2

10

LSO_ATTENDEE_KEY

XXX

VARCHAR2

12

LSO_COURSE_KEY

XXX

VARCHAR2

10

LSO_REGISTRATION_FEE

XXX

NUMBER

22

LSO_REGISTRATION_STATUS_DATE

XXX

DATE

7

LSO_REGISTRATION_STATUS_KEY

XXX

VARCHAR2

11

LSO_SESSION_CODE

XXX

VARCHAR2

12

LSO_SESSION_END_DATE

XXX

DATE

7

LSO_SESSION_START_DATE

XXX

DATE

7

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

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

WAREHOUSE_LOAD_DATE

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

DATE

8