ASA RESOURCE REQ DETAIL Table

Association of Student Activities Resource 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_RESOURCE_TYPE_KEY	Use this field to join together the ASA RESOURCE TYPE table with either the ASA RESOURCE ALLOC DETAIL or the ASA RESOURCE REQ DETAIL tables.	VARCHAR2	10
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
BULLETIN_BOARD_BUILDING	The building where the bulletin board allocated to an ASA student group is located.	VARCHAR2	20
BULLETIN_BOARD_NUMBER	Bulletin board number allocated to an ASA student group.	VARCHAR2	10
LOCKABLE	XXX	VARCHAR2	1
LOCKER_NUMBER	Locker allocated to an ASA Student group.	VARCHAR2	20
MAILBOX_NUMBER	Mailbox allocated to an ASA student group.	VARCHAR2	20
OFFICE_BUILDING	Building number where the office of the ASA student group is located.	VARCHAR2	20
OFFICE_MAX_CAPACITY	XXX	NUMBER	3
OFFICE_NETWORK_DROP	XXX	VARCHAR2	15
OFFICE_NUMBER	Office/Room number.	VARCHAR2	10
OFFICE_PHONE_NUMBER	XXX	VARCHAR2	45
REQUEST_ID	ASA Request Identification Number	NUMBER	12
REQUEST_NOTES	XXX	VARCHAR2	1000
REQUEST_PROCESSED_DATE	XXX	DATE	8
REQUEST_PROCESSING_NOTES	XXX	VARCHAR2	2000
REQUEST_SUBMIT_DATE	The date when the request was submitted.	DATE	8
REQUEST_UPDATER	XXX	VARCHAR2	20
REQUEST_UPDATE_DATE	XXX	DATE	8
RESOURCE_DESCRIPTION	Description of the resource allocated to the ASA student group	VARCHAR2	200
RESOURCE_EFFECTIVE_DATE	XXX	DATE	8
RESOURCE_EXPIRATION_DATE	XXX	DATE	8
RESOURCE_UPDATER	XXX	VARCHAR2	20
RESOURCE_UPDATE_DATE	XXX	DATE	8
WAREHOUSE_LOAD_DATE	The date the record was loaded into the Data Warehouse from the source system.	DATE	8