TEM INSTRUCTOR SCHEDULE DETAIL Table
View exposing TEM instructor schedule detail by class, provider, session, instructor, location, and meeting date including start and end dates and times, hours, record counter, and warehouse load date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
6 |
SESSION_END_DATE |
Date associated with session end. |
DATE |
|
SESSION_MEETING_DATE |
Date associated with session meeting. |
DATE |
|
SESSION_MEETING_END_TIME |
Time associated with session meeting end. |
VARCHAR2 |
9 |
SESSION_MEETING_NO_OF_HOURS |
Session meeting no of hours associated with the record. |
NUMBER |
7,2 |
SESSION_MEETING_START_TIME |
Time associated with session meeting start. |
VARCHAR2 |
9 |
SESSION_START_DATE |
Date associated with session start. |
DATE |
|
TEM_CLASS_KEY |
Surrogate key identifying the tem class. |
VARCHAR2 |
10 |
TEM_INSTRUCTOR_KEY |
Surrogate key identifying the tem instructor. |
VARCHAR2 |
10 |
TEM_LOCATION_KEY |
Surrogate key identifying the tem location. |
VARCHAR2 |
10 |
TEM_PROVIDER_KEY |
Surrogate key identifying the tem provider. |
VARCHAR2 |
10 |
TEM_SESSION_CODE |
Code identifying tem session. |
VARCHAR2 |
10 |
TEM_SESSION_STATUS_KEY |
Surrogate key identifying the tem session status. |
VARCHAR2 |
5 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |