ASA MIDWAY REQ DETAIL Table
View exposing detail records for student group Midway participation requests, including request attributes used to manage ASA Midway planning and operations.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASA_REQUEST_STATUS_KEY |
Surrogate key identifying the asa request status. |
VARCHAR2 |
20 |
ASA_STUDENT_GROUP_KEY |
Surrogate key identifying the asa student group. |
NUMBER |
10 |
ASSIGNED_LOCATION |
Assigned location as provided by the source. |
VARCHAR2 |
30 |
CONTACT_EMAIL |
Contact email as provided by the source. |
VARCHAR2 |
30 |
CONTACT_NAME |
Contact name as provided by the source. |
VARCHAR2 |
30 |
ELECTRICITY_APPROVED |
Electricity approved as provided by the source. |
VARCHAR2 |
1 |
FAR |
Far as provided by the source. |
VARCHAR2 |
100 |
IS_ELECTRICITY_REQUESTED |
Indicator identifying whether electricity requested (Y/N). |
VARCHAR2 |
1 |
IS_MUSIC_REQUESTED |
Indicator identifying whether music requested (Y/N). |
VARCHAR2 |
1 |
IS_NETWORK_REQUESTED |
Indicator identifying whether network requested (Y/N). |
VARCHAR2 |
1 |
IS_PERF_SPACE_REQUESTED |
Indicator identifying whether perf space requested (Y/N). |
VARCHAR2 |
1 |
IS_TVVCR_REQUESTED |
Indicator identifying whether tvvcr requested (Y/N). |
VARCHAR2 |
1 |
MUSIC_APPROVED |
Music approved as provided by the source. |
VARCHAR2 |
1 |
NEAR |
Near as provided by the source. |
VARCHAR2 |
100 |
NETWORK_APPROVED |
Network approved as provided by the source. |
VARCHAR2 |
1 |
NUM_OF_TABLES_APPROVED |
Num of tables approved as provided by the source. |
NUMBER |
3 |
NUM_OF_TABLES_REQUESTED |
Num of tables requested as provided by the source. |
NUMBER |
3 |
PERF_SPACE_APPROVED |
Perf space approved as provided by the source. |
VARCHAR2 |
1 |
PROCESSED_DATE |
Date associated with processed. |
DATE |
|
PROCESSING_EBM |
Processing ebm as provided by the source. |
VARCHAR2 |
8 |
PROCESSING_NOTES |
Processing notes as provided by the source. |
VARCHAR2 |
500 |
REQUEST_ID |
Business identifier for the request. |
NUMBER |
12 |
REQUEST_NOTES |
Request notes as provided by the source. |
VARCHAR2 |
1000 |
REQUEST_SUBMIT_DATE |
Date associated with request submit. |
DATE |
|
TVVCR_APPROVED |
Tvvcr approved as provided by the source. |
VARCHAR2 |
1 |
UPDATER |
Updater as provided by the source. |
VARCHAR2 |
20 |
UPDATE_DATE |
Date associated with update. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |