FAID STUDENT REQ DOCS Table
View exposing financial aid student required documents tracking including document type, submission status, receipt dates, completeness indicators, and deadline tracking used for application processing, verification workflows, and compliance verification.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_YEAR_NAME |
Award year name associated with the record. |
VARCHAR2 |
10 |
DOC_NAME |
Doc name associated with the record. |
VARCHAR2 |
40 |
DOC_SHORT_NAME |
Doc short name associated with the record. |
VARCHAR2 |
8 |
DOC_STATUS |
Doc status associated with the record. |
VARCHAR2 |
1 |
DOC_TOKEN |
Doc token associated with the record. |
NUMBER |
|
DOC_TYPE |
Doc type associated with the record. |
VARCHAR2 |
1 |
DOC_TYPE_DESC |
Description of doc type. |
VARCHAR2 |
17 |
FAID_APPLICANT_KEY |
Surrogate key identifying the faid applicant. |
VARCHAR2 |
21 |
FAID_YEAR |
Faid year associated with the record. |
NUMBER |
|
IMPACTED_BY_IDOC |
Impacted by idoc associated with the record. |
VARCHAR2 |
1 |
MANUAL_LOCK |
Manual lock associated with the record. |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
10 |
REQUIRED_FOR |
Required for associated with the record. |
VARCHAR2 |
1 |
REQUIRED_FOR_DESC |
Description of required for. |
VARCHAR2 |
12 |
REQ_STATUS_CODE |
Code identifying req status. |
NUMBER |
|
REQ_STATUS_DESCRIPTION |
Description of req status. |
VARCHAR2 |
20 |
SEL_SET_YEAR_TOKEN |
Sel set year token associated with the record. |
NUMBER |
|
STATUS_EFFECTIVE_DT |
Status effective dt associated with the record. |
DATE |
|
STUDENT_FIRST_NAME |
Student first name associated with the record. |
VARCHAR2 |
15 |
STUDENT_LAST_NAME |
Student last name associated with the record. |
VARCHAR2 |
25 |
STUDENT_TOKEN |
Student token associated with the record. |
NUMBER |
|
STU_AWARD_YEAR_TOKEN |
Stu award year token associated with the record. |
NUMBER |
|
STU_REQ_DOC_CREATED_BY |
Stu req doc created by associated with the record. |
NUMBER |
|
STU_REQ_DOC_CREATED_DATE |
Date associated with stu req doc created. |
DATE |
|
STU_REQ_DOC_MODIFIED_BY |
Stu req doc modified by associated with the record. |
NUMBER |
|
STU_REQ_DOC_MODIFIED_DATE |
Date associated with stu req doc modified. |
DATE |