LSO SESSION SCHEDULE DETAIL Table
Fact table for reporting session schedules
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LSO_COURSE_KEY |
XXX |
VARCHAR2 |
47 |
LSO_LOCATION_KEY |
XXX |
VARCHAR2 |
47 |
LSO_PROVIDER_KEY |
XXX |
VARCHAR2 |
47 |
LSO_SESSION_CODE |
XXX |
VARCHAR2 |
10 |
LSO_SESSION_END_DATE |
XXX |
DATE |
|
LSO_SESSION_MEETING_DATE |
XXX |
DATE |
|
LSO_SESSION_MEETNG_END_TIME |
XXX |
VARCHAR2 |
9 |
LSO_SESSION_MEETNG_NUM_HOURS |
XXX |
NUMBER |
34 |
LSO_SESSION_MEETNG_START_TIME |
XXX |
VARCHAR2 |
9 |
LSO_SESSION_SEQNO |
XXX |
VARCHAR2 |
2 |
LSO_SESSION_START_DATE |
XXX |
DATE |
|
LSO_SESSION_STATUS_KEY |
XXX |
VARCHAR2 |
10 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |