ASA MIDWAY REQ DETAIL Table

Association of Student Activities Midway Requests

Field Name	Description	Data Type	Length
ASA_REQUEST_STATUS_KEY	Use this field to join together the ASA REQUEST STATUS table and another ASA fact table with the same-name field.	VARCHAR2	20
ASA_STUDENT_GROUP_KEY	Use this field to join together the ASA STUDENT GROUP table and another ASA Fact table with the same name field.	NUMBER	10
ASSIGNED_LOCATION	XXX	VARCHAR2	30
CONTACT_EMAIL	XXX	VARCHAR2	30
CONTACT_NAME	XXX	VARCHAR2	30
ELECTRICITY_APPROVED	XXX	VARCHAR2	1
FAR	XXX	VARCHAR2	100
IS_ELECTRICITY_REQUESTED	XXX	VARCHAR2	1
IS_MUSIC_REQUESTED	XXX	VARCHAR2	1
IS_NETWORK_REQUESTED	XXX	VARCHAR2	1
IS_PERF_SPACE_REQUESTED	XXX	VARCHAR2	1
IS_TVVCR_REQUESTED	XXX	VARCHAR2	1
MUSIC_APPROVED	XXX	VARCHAR2	1
NEAR	XXX	VARCHAR2	100
NETWORK_APPROVED	XXX	VARCHAR2	1
NUM_OF_TABLES_APPROVED	XXX	NUMBER	3
NUM_OF_TABLES_REQUESTED	XXX	NUMBER	3
PERF_SPACE_APPROVED	XXX	VARCHAR2	1
PROCESSED_DATE	XXX	DATE	8
PROCESSING_EBM	XXX	VARCHAR2	8
PROCESSING_NOTES	XXX	VARCHAR2	500
REQUEST_ID	ASA Request Identification Number	NUMBER	12
REQUEST_NOTES	XXX	VARCHAR2	1000
REQUEST_SUBMIT_DATE	The date when the request was submitted.	DATE	8
TVVCR_APPROVED	XXX	VARCHAR2	1
UPDATER	The person who last updated the information in the record.	VARCHAR2	20
UPDATE_DATE	Date this record was last updated by the source system.	DATE	8
WAREHOUSE_LOAD_DATE	The date the record was loaded into the Data Warehouse from the source system.	DATE	8