FINAID APPLICANT Table
View exposing financial aid applicant records including student attributes used in financial aid eligibility and award processing.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
CITIZENSHIP_IND |
Citizenship ind associated with the record. |
VARCHAR2 |
100 |
DEPARTMENT |
Department associated with the record. |
VARCHAR2 |
6 |
ENROLL_STATUS |
Enroll status associated with the record. |
VARCHAR2 |
100 |
FINAID_CLASS_CODE |
Code identifying finaid class. |
NUMBER |
1 |
FINAID_CLASS_CODE_DESC |
Description of finaid class code. |
VARCHAR2 |
100 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
93 |
IS_AID_APPLICANT |
Indicator identifying whether aid applicant (Y/N). |
VARCHAR2 |
1 |
IS_APPLICANT |
Indicator identifying whether applicant (Y/N). |
VARCHAR2 |
1 |
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 |
LOAD_LEVEL |
Load level associated with the record. |
VARCHAR2 |
100 |
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 |
100 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |