LSO SESSION DETAIL Table
Fact table for reporting statistics on course sessions in E-learning module
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LSO_BUILDING_KEY |
XXX |
VARCHAR2 |
10 |
LSO_COURSE_KEY |
XXX |
VARCHAR2 |
10 |
LSO_PROVIDER_KEY |
XXX |
VARCHAR2 |
10 |
LSO_SESSION_CODE |
XXX |
VARCHAR2 |
12 |
LSO_SESSION_END_DATE |
XXX |
DATE |
7 |
LSO_SESSION_EXTERNAL_COST |
XXX |
NUMBER |
22 |
LSO_SESSION_INTERNAL_COST |
XXX |
NUMBER |
22 |
LSO_SESSION_MAXIMUM_SIZE |
XXX |
NUMBER |
22 |
LSO_SESSION_MINIMUM_SIZE |
XXX |
NUMBER |
22 |
LSO_SESSION_NUMBER_OF_DAYS |
XXX |
NUMBER |
22 |
LSO_SESSION_NUMBER_OF_HOURS |
XXX |
NUMBER |
22 |
LSO_SESSION_OPTIMUM_SIZE |
XXX |
NUMBER |
22 |
LSO_SESSION_START_DATE |
XXX |
DATE |
7 |
LSO_SESSION_STATUS_KEY |
XXX |
VARCHAR2 |
5 |
LSO_SESSN_NUMBER_OF_ATTENDED |
XXX |
NUMBER |
22 |
LSO_SESSN_NUMBER_OF_CANCELED |
XXX |
NUMBER |
22 |
LSO_SESSN_NUMBER_OF_REGISTERED |
XXX |
NUMBER |
22 |
LSO_SESSN_NUMBER_ON_WAITLIST |
XXX |
NUMBER |
22 |
LSO_SESSN_NUMBER_WAITLIST_PEAK |
XXX |
NUMBER |
22 |
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 |