|
| |
Related Links: |
|---|---|
| |
ASA STUDENT GROUP Table
Association of Student Activities Student Groups
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADVISOR |
XXX |
VARCHAR2 |
100 |
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 |
ATHENA_LOCKER |
XXX |
VARCHAR2 |
30 |
CONSTITUTION_WEB_URL |
XXX |
VARCHAR2 |
100 |
FUNDING_ACCOUNT_ID |
XXX |
VARCHAR2 |
20 |
FUNDING_LIAISON_EMAIL |
XXX |
VARCHAR2 |
30 |
GROUP_ACTIVITY_CATEGORY |
Activity categor of the ASA student group. Eg.: Service, Social, Technology. |
VARCHAR2 |
20 |
GROUP_CLASS |
Eg. Standard, Sponsored, Club Sport, Dorm/FSILG. |
VARCHAR2 |
20 |
GROUP_FUNDING_TYPE |
Funding type of the ASA student group. Eg.: undergraduate, graduate, sports council, none. |
VARCHAR2 |
20 |
GROUP_STATUS |
Status of an ASA student group. Eg.Active, Derecognized, Provisional, Suspended. |
VARCHAR2 |
20 |
MAIN_ACCOUNT_ID |
XXX |
VARCHAR2 |
20 |
MEETING_TIMES |
XXX |
VARCHAR2 |
200 |
NOTE |
For the LIBRARY FINANCIAL DETAIL and LIBRARY ALLOCATION DETAIL tables, the NOTE field contains detailed explanation of the budget transaction. May be system assigned e.g. INVOICE, ORDER ENCUMBRANCE (Z601-NOTE). For the CIP and CIP WITH VERSION tables, this field contains additional information regarding the Program Title. |
VARCHAR2 |
100 |
NUM_OF_COMMUNITY |
XXX |
NUMBER |
4 |
NUM_OF_GRADUATE |
XXX |
NUMBER |
4 |
NUM_OF_OTHERS |
XXX |
NUMBER |
4 |
NUM_OF_UNDERGRADUATE |
XXX |
NUMBER |
4 |
OFFICER_EMAIL |
XXX |
VARCHAR2 |
30 |
OTHER_ACCOUNT_IDS |
XXX |
VARCHAR2 |
610 |
RECOGNITION_DATE |
XXX |
DATE |
8 |
STUDENT_GROUP_ACRONYM |
The acronym of a student group recognized by the Association of Student Activities (ASA). |
VARCHAR2 |
15 |
STUDENT_GROUP_DESCRIPTION |
The description of a student group recognized by the Association of Student Activities (ASA). |
VARCHAR2 |
100 |
STUDENT_GROUP_EMAIL |
XXX |
VARCHAR2 |
30 |
STUDENT_GROUP_NAME |
The name of a student group recognized by the Association of Student Activities (ASA). |
VARCHAR2 |
100 |
UPDATER |
The person who last updated the information in the record. |
VARCHAR2 |
20 |
UPDATE_DATE |
Date this record was last updated by the source system. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WEBSITE_URL |
XXX |
VARCHAR2 |
100 |
