|
| |
Related Links: |
|---|---|
| |
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 |
