ASA RESOURCE ALLOC DETAIL Table
View exposing detail records for resources allocated to student groups, including allocation attributes used for ASA resource management and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALLOCATION_DATE |
Date associated with allocation. |
DATE |
|
ALLOC_UPDATER |
Alloc updater as provided by the source. |
VARCHAR2 |
20 |
ALLOC_UPDATE_DATE |
Date associated with alloc update. |
DATE |
|
ASA_RESOURCE_TYPE_KEY |
Surrogate key identifying the asa resource type. |
VARCHAR2 |
10 |
ASA_STUDENT_GROUP_KEY |
Surrogate key identifying the asa student group. |
NUMBER |
10 |
BULLETIN_BOARD_BUILDING |
Bulletin board building as provided by the source. |
VARCHAR2 |
20 |
BULLETIN_BOARD_NUMBER |
Bulletin board number as provided by the source. |
VARCHAR2 |
10 |
LOCKABLE |
Lockable as provided by the source. |
VARCHAR2 |
1 |
LOCKER_NUMBER |
Locker number as provided by the source. |
VARCHAR2 |
20 |
MAILBOX_NUMBER |
Mailbox number as provided by the source. |
VARCHAR2 |
20 |
OFFICE_BUILDING |
Office building as provided by the source. |
VARCHAR2 |
20 |
OFFICE_MAX_CAPACITY |
Office max capacity as provided by the source. |
NUMBER |
3 |
OFFICE_NETWORK_DROP |
Office network drop as provided by the source. |
VARCHAR2 |
15 |
OFFICE_NUMBER |
Office number as provided by the source. |
VARCHAR2 |
10 |
OFFICE_PHONE_NUMBER |
Office phone number as provided by the source. |
VARCHAR2 |
45 |
RESOURCE_DESCRIPTION |
Description of resource. |
VARCHAR2 |
200 |
RESOURCE_EFFECTIVE_DATE |
Date associated with resource effective. |
DATE |
|
RESOURCE_EXPIRATION_DATE |
Date associated with resource expiration. |
DATE |
|
RESOURCE_UPDATER |
Resource updater as provided by the source. |
VARCHAR2 |
20 |
RESOURCE_UPDATE_DATE |
Date associated with resource update. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |