LSO COURSE Table
View exposing learning and development course reference data including course identifiers, names, and categorization attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_USER |
Last update user associated with the record. |
VARCHAR2 |
12 |
LSO_CATEGORY |
Lso category associated with the record. |
VARCHAR2 |
40 |
LSO_CATEGORY_CODE |
Code identifying lso category. |
VARCHAR2 |
10 |
LSO_CATEGORY_ID |
Business identifier for the lso category. |
VARCHAR2 |
12 |
LSO_COURSE |
Lso course associated with the record. |
VARCHAR2 |
50 |
LSO_COURSE_CODE |
Code identifying lso course. |
VARCHAR2 |
10 |
LSO_COURSE_DELIVERY_METHOD |
Lso course delivery method associated with the record. |
VARCHAR2 |
40 |
LSO_COURSE_DESCRIPTION |
Description of lso course. |
VARCHAR2 |
4000 |
LSO_COURSE_ID |
Business identifier for the lso course. |
VARCHAR2 |
12 |
LSO_COURSE_KEY |
Surrogate key identifying the lso course. |
VARCHAR2 |
10 |
LSO_COURSE_NUMBER_OF_DAYS |
Lso course number of days associated with the record. |
VARCHAR2 |
1 |
LSO_COURSE_NUMBER_OF_HOURS |
Lso course number of hours associated with the record. |
VARCHAR2 |
1 |
LSO_PROVIDER_KEY |
Surrogate key identifying the lso provider. |
VARCHAR2 |
47 |
LSO_SENSITIVE_FLAG |
Indicator identifying whether lso sensitive (Y/N). |
VARCHAR2 |
1 |
LSO_SUBJECT_AREA |
Lso subject area associated with the record. |
VARCHAR2 |
40 |
LSO_SUBJECT_AREA_CODE |
Code identifying lso subject area. |
VARCHAR2 |
10 |
LSO_SUBJECT_AREA_ID |
Business identifier for the lso subject area. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WEBCOURSE_LAST_UPDATE_DATE |
Date associated with webcourse last update. |
DATE |