ASA OFFICER DETAIL Table

Association of Student Activities Student Group Officers

Field Name	Description	Data Type	Length
ASA_OFFICER_FULL_NAME	XXX	VARCHAR2	93
ASA_OFFICER_ROLE_KEY	Use this field to join together the ASA OFFICER ROLE and the ASA OFFICER DETAIL tables	VARCHAR2	30
ASA_OFFICER_TYPE	XXX	VARCHAR2	14
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
EFFECTIVE_DATE	In the COST COLLECTOR table: this represents the effective date or starting date of the fund cost collector. In the ASA OFFICER DETAIL table this is the starting date of the tenure of the officer.	DATE	8
EXPIRATION_DATE	In the COST COLLECTOR table: Final or expiration date of the fund cost collector. In the ASA OFFICER DETAIL table, this is the date when the officer's term expires.	DATE	8
KERBEROS_NAME	The Kerberos username of the person. If this field starts with a dollar sign ($), then it is not a real Kerberos username, but an algorithmically generated pseudo Kerberos username, used as a placeholder in the EHS system.	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	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