Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LSO COURSE Table


Courses offered through E-learning catalog


Field Name

Description

Data Type

Length

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

8

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

LSO_CATEGORY

XXX

VARCHAR2

40

LSO_CATEGORY_CODE

XXX

VARCHAR2

12

LSO_CATEGORY_ID

XXX

VARCHAR2

12

LSO_COURSE

XXX

VARCHAR2

40

LSO_COURSE_CODE

XXX

VARCHAR2

12

LSO_COURSE_DELIVERY_METHOD

XXX

VARCHAR2

40

LSO_COURSE_DESCRIPTION

XXX

VARCHAR2

4000

LSO_COURSE_ID

XXX

VARCHAR2

12

LSO_COURSE_KEY

XXX

VARCHAR2

10

LSO_COURSE_NUMBER_OF_DAYS

XXX

NUMBER

22

LSO_COURSE_NUMBER_OF_HOURS

XXX

NUMBER

22

LSO_PROVIDER_KEY

XXX

VARCHAR2

10

LSO_SENSITIVE_FLAG

XXX

VARCHAR2

1

LSO_SUBJECT_AREA

XXX

VARCHAR2

40

LSO_SUBJECT_AREA_CODE

XXX

VARCHAR2

12

LSO_SUBJECT_AREA_ID

XXX

VARCHAR2

12

WAREHOUSE_LOAD_DATE

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

DATE

8

WEBCOURSE_LAST_UPDATE_DATE

XXX

DATE

7