ASA RESOURCE ALLOC DETAIL Table

Association of Student Activities Resource Allocations

Field Name	Description	Data Type	Length
ALLOCATION_DATE	XXX	DATE	8
ALLOC_UPDATER	XXX	VARCHAR2	20
ALLOC_UPDATE_DATE	XXX	DATE	8
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
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