ASA STUDENT GROUP Table
View exposing student group records for ASA-recognized organizations, including group attributes used for student activities administration and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADVISOR |
Advisor as provided by the source. |
VARCHAR2 |
100 |
ASA_STUDENT_GROUP_KEY |
Surrogate key identifying the asa student group. |
NUMBER |
10 |
ATHENA_LOCKER |
Athena locker as provided by the source. |
VARCHAR2 |
30 |
CONSTITUTION_WEB_URL |
Constitution web url as provided by the source. |
VARCHAR2 |
100 |
FUNDING_ACCOUNT_ID |
Business identifier for the funding account. |
VARCHAR2 |
20 |
FUNDING_LIAISON_EMAIL |
Funding liaison email as provided by the source. |
VARCHAR2 |
30 |
GROUP_ACTIVITY_CATEGORY |
Group activity category as provided by the source. |
VARCHAR2 |
20 |
GROUP_CLASS |
Group class as provided by the source. |
VARCHAR2 |
20 |
GROUP_FUNDING_TYPE |
Group funding type as provided by the source. |
VARCHAR2 |
20 |
GROUP_STATUS |
Group status as provided by the source. |
VARCHAR2 |
20 |
MAIN_ACCOUNT_ID |
Business identifier for the main account. |
VARCHAR2 |
20 |
MEETING_TIMES |
Meeting times as provided by the source. |
VARCHAR2 |
200 |
NOTE |
Note as provided by the source. |
VARCHAR2 |
2000 |
NUM_OF_COMMUNITY |
Num of community as provided by the source. |
NUMBER |
|
NUM_OF_GRADUATE |
Num of graduate as provided by the source. |
NUMBER |
|
NUM_OF_OTHERS |
Num of others as provided by the source. |
NUMBER |
|
NUM_OF_UNDERGRADUATE |
Num of undergraduate as provided by the source. |
NUMBER |
|
OFFICER_EMAIL |
Officer email as provided by the source. |
VARCHAR2 |
30 |
OTHER_ACCOUNT_IDS |
Other account ids as provided by the source. |
VARCHAR2 |
610 |
RECOGNITION_DATE |
Date associated with recognition. |
DATE |
|
STUDENT_GROUP_ACRONYM |
Student group acronym as provided by the source. |
VARCHAR2 |
15 |
STUDENT_GROUP_DESCRIPTION |
Description of student group. |
VARCHAR2 |
100 |
STUDENT_GROUP_EMAIL |
Student group email as provided by the source. |
VARCHAR2 |
30 |
STUDENT_GROUP_NAME |
Student group name as provided by the source. |
VARCHAR2 |
100 |
UPDATER |
Updater as provided by the source. |
VARCHAR2 |
20 |
UPDATE_DATE |
Date associated with update. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WEBSITE_URL |
Website url as provided by the source. |
VARCHAR2 |
100 |