ASA OFFICER DETAIL Table
View exposing student group officer detail records, including officer assignments and related attributes used for student organization administration and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASA_OFFICER_FULL_NAME |
Asa officer full name as provided by the source. |
VARCHAR2 |
133 |
ASA_OFFICER_ROLE_KEY |
Surrogate key identifying the asa officer role. |
VARCHAR2 |
30 |
ASA_OFFICER_TYPE |
Asa officer type as provided by the source. |
VARCHAR2 |
14 |
ASA_STUDENT_GROUP_KEY |
Surrogate key identifying the asa student group. |
NUMBER |
10 |
EFFECTIVE_DATE |
Date associated with effective. |
DATE |
|
EXPIRATION_DATE |
Date associated with expiration. |
DATE |
|
KERBEROS_NAME |
Kerberos name as provided by the source. |
VARCHAR2 |
8 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
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 |