ASA RESOURCE REQ DETAIL Table
View exposing detail records for student group resource requests, including requested resource attributes used for ASA review and allocation processes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASA_REQUEST_STATUS_KEY |
Surrogate key identifying the asa request status. |
VARCHAR2 |
20 |
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 |
REQUEST_ID |
Business identifier for the request. |
NUMBER |
12 |
REQUEST_NOTES |
Request notes as provided by the source. |
VARCHAR2 |
2000 |
REQUEST_PROCESSED_DATE |
Date associated with request processed. |
DATE |
|
REQUEST_PROCESSING_NOTES |
Request processing notes as provided by the source. |
VARCHAR2 |
2000 |
REQUEST_SUBMIT_DATE |
Date associated with request submit. |
DATE |
|
REQUEST_UPDATER |
Request updater as provided by the source. |
VARCHAR2 |
20 |
REQUEST_UPDATE_DATE |
Date associated with request update. |
DATE |
|
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 |