LSO SESSION DETAIL Table
View exposing learning and development session detail including course, provider, location, schedule, and status attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LSO_BUILDING_KEY |
Surrogate key identifying the lso building. |
VARCHAR2 |
47 |
LSO_COURSE_KEY |
Surrogate key identifying the lso course. |
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_EXTERNAL_COST |
Lso session external cost associated with the record. |
NUMBER |
16,2 |
LSO_SESSION_INTERNAL_COST |
Lso session internal cost associated with the record. |
NUMBER |
16,2 |
LSO_SESSION_MAXIMUM_SIZE |
Lso session maximum size associated with the record. |
NUMBER |
5 |
LSO_SESSION_MINIMUM_SIZE |
Lso session minimum size associated with the record. |
NUMBER |
5 |
LSO_SESSION_NUMBER_OF_DAYS |
Lso session number of days associated with the record. |
NUMBER |
4 |
LSO_SESSION_NUMBER_OF_HOURS |
Lso session number of hours associated with the record. |
NUMBER |
8,2 |
LSO_SESSION_OPTIMUM_SIZE |
Lso session optimum size associated with the record. |
NUMBER |
5 |
LSO_SESSION_START_DATE |
Date associated with lso session start. |
DATE |
|
LSO_SESSION_STATUS_KEY |
Surrogate key identifying the lso session status. |
VARCHAR2 |
10 |
LSO_SESSN_NUMBER_OF_ATTENDED |
Lso sessn number of attended associated with the record. |
NUMBER |
18 |
LSO_SESSN_NUMBER_OF_CANCELED |
Lso sessn number of canceled associated with the record. |
NUMBER |
18 |
LSO_SESSN_NUMBER_OF_REGISTERED |
Lso sessn number of registered associated with the record. |
NUMBER |
18 |
LSO_SESSN_NUMBER_ON_WAITLIST |
Lso sessn number on waitlist associated with the record. |
NUMBER |
18 |
LSO_SESSN_NUMBER_WAITLIST_PEAK |
Lso sessn number waitlist peak associated with the record. |
NUMBER |
6 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |