Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LSO INSTRUCTOR SCHEDULE DETAIL Table


View exposing learning and development instructor scheduling detail by session and date.


Field Name

Description

Data Type

Length

LSO_COURSE_KEY

Surrogate key identifying the lso course.

VARCHAR2

47

LSO_INSTRUCTOR_KEY

Surrogate key identifying the lso instructor.

VARCHAR2

47

LSO_LOCATION_KEY

Surrogate key identifying the lso location.

VARCHAR2

47

LSO_PROVIDER_KEY

Surrogate key identifying the lso provider.

VARCHAR2

47

LSO_SESSION_CODE

Code identifying lso session.

VARCHAR2

10

LSO_SESSION_END_DATE

Date associated with lso session end.

DATE

LSO_SESSION_MEETING_DATE

Date associated with lso session meeting.

DATE

LSO_SESSION_MEETNG_END_TIME

Time associated with lso session meetng end.

VARCHAR2

9

LSO_SESSION_MEETNG_NUM_HOURS

Lso session meetng num hours associated with the record.

NUMBER

34

LSO_SESSION_MEETNG_START_TIME

Time associated with lso session meetng start.

VARCHAR2

9

LSO_SESSION_START_DATE

Date associated with lso session start.

DATE

LSO_SESSION_STATUS_KEY

Surrogate key identifying the lso session status.

VARCHAR2

10

RECORD_COUNTER

Record counter associated with the record.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE