FINAID WORK STUDENT Table
This table contains records of students who have worked on campus. Fields of records include MIT ID, full name, and some enrollment information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_YEAR |
Financial aid year. |
VARCHAR2 |
4 |
CITIZENSHIP_IND |
Status of US Citizenship. Values are: US Citizen, US Permanent Resident, International, and Unknown. |
VARCHAR2 |
30 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
DEPARTMENT |
The department of the primary Course/major: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
ENROLL_STATUS |
The status of the student's registration for the term. Values include: Eligible to register, Registered, Early Thesis, Withdrew After 5th Week, etc. In the STUDENT and STUDENT_TERM_ENROLLMENT tables, only the codes (eg. EL, RE, ET, WR, WE) are shown. |
VARCHAR2 |
2 |
FINAID_CLASS_CODE |
Financial Aid Class Code -- One of these codes: 0,1,2,3,4,5,6 -- indicating the student's year of studies at MIT according to the rules of receiving financial aid. |
VARCHAR2 |
1 |
FINAID_WORK_STUDENT_KEY |
Use this field to join between the FINAID WORK STUDENT table to a financial aid fact table which contains the same-name field, eg. FINAID WORK EARNINGS DETAIL, FINAID PAYROLL DIST DETAIL. |
VARCHAR2 |
13 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
HAS_FINAID_LINK |
'Y' indicates that this student has a financial aid record (most probably because he/she is a financial aid applicant/recipient) for the financial aid year. 'N' indicates that the student does not have a financial aid record for the aid year. |
VARCHAR2 |
1 |
I9_ACTIVITY_DATE |
Date when the I9 form information was last updated |
DATE |
8 |
I9_CODE |
Codes represent the status of the I9 (Employment Eligibility Verification) form. |
VARCHAR2 |
1 |
I9_DESCRIPTION |
Descriptive text for the codes represent the status of the I9 Form. |
VARCHAR2 |
50 |
IS_ATTENDED |
"Y" indicates that the student attended at least some part of the current term. "N" indicates that the student never attended this term. In the FINAID AID APPLICANT and FINAID APPLICANT tables, "Y" indicates that the student has attended at least partially in any one of the three terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not attended in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_ELIG_TO_REG |
Whether the student is eligible to register in any one of the three terms (in this order: Spring, Fall, Summer)) of the aid year. Y=Yes, N=No. |
VARCHAR2 |
1 |
IS_REGISTERED |
"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_WORK_STUDY_CHARGED |
A flag (Y=Yes, N=No) indicate whether this student has work study charges for the financial aid year. The work study charged amount is found in the CHARGED CWSP AMOUNT field in the FINAID PAYROLL DIST DETAIL table. |
VARCHAR2 |
1 |
IS_WORK_STUDY_ELIG |
A flag (Y=Yes, N=No) indicates whether this student is work-study eligible for the financial aid year. A student is work-study eligible (ie.. a "Work Study" student) if he/she is offered one or more of the financial awards that fall into the "college work study program" category (e.g. CWSG, CWSP, CWSS, FWSCS, FWSS, FWSSB). A student is not work-study eligible (ie. a "Non Work-Study" student), if he or she is not offered one of the aforementioned financial aid awards. |
VARCHAR2 |
1 |
LOAD_LEVEL |
The course load of the student in the registered term. Values: Full Time, Half Time, 3/4 Time, Early Thesis, No Load, Cross-registered, Less Than Half Time, Full Time Senior. |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
REGISTER_TYPE |
The type of registration of the student of the term (any one of the three terms of the aid year, in this order: Spring, Fall, Summer) which he/she is registered. Possible types of registration are: Regular, Special, Cross-Registered and Non-Resident. |
VARCHAR2 |
30 |
SSN |
The person's social security number. |
VARCHAR2 |
9 |
STUDENT_YEAR |
The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |