FINAID WORK STUDENT Table
View exposing student employment records associated with financial aid work-study programs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
CITIZENSHIP_IND |
Citizenship ind associated with the record. |
VARCHAR2 |
30 |
DATE_OF_BIRTH |
Date of birth associated with the person. |
DATE |
|
DEPARTMENT |
Department associated with the record. |
VARCHAR2 |
6 |
ENROLL_STATUS |
Enroll status associated with the record. |
VARCHAR2 |
30 |
FINAID_CLASS_CODE |
Code identifying finaid class. |
VARCHAR2 |
1 |
FINAID_WORK_STUDENT_KEY |
Surrogate key identifying the finaid work student. |
VARCHAR2 |
13 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
60 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
32 |
HAS_FINAID_LINK |
Indicator identifying whether finaid link (Y/N). |
VARCHAR2 |
1 |
I9_ACTIVITY_DATE |
Date associated with i9 activity. |
DATE |
|
I9_CODE |
Code identifying i9. |
VARCHAR2 |
1 |
I9_DESCRIPTION |
Description of i9. |
VARCHAR2 |
50 |
IS_ATTENDED |
Indicator identifying whether attended (Y/N). |
VARCHAR2 |
1 |
IS_ELIG_TO_REG |
Indicator identifying whether elig to reg (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
VARCHAR2 |
1 |
IS_WORK_STUDY_CHARGED |
Indicator identifying whether work study charged (Y/N). |
VARCHAR2 |
1 |
IS_WORK_STUDY_ELIG |
Indicator identifying whether work study elig (Y/N). |
VARCHAR2 |
1 |
LOAD_LEVEL |
Load level associated with the record. |
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 |
Register type associated with the record. |
VARCHAR2 |
30 |
SSN |
Ssn associated with the record. |
VARCHAR2 |
11 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |