FAID STUDENT REQ DOCS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_YEAR_NAME |
XXX |
VARCHAR2 |
10 |
DOC_NAME |
XXX |
VARCHAR2 |
40 |
DOC_SHORT_NAME |
XXX |
VARCHAR2 |
8 |
DOC_STATUS |
XXX |
VARCHAR2 |
1 |
DOC_TOKEN |
XXX |
NUMBER |
|
DOC_TYPE |
XXX |
VARCHAR2 |
1 |
DOC_TYPE_DESC |
XXX |
VARCHAR2 |
17 |
FAID_APPLICANT_KEY |
XXX |
VARCHAR2 |
21 |
FAID_YEAR |
XXX |
NUMBER |
|
IMPACTED_BY_IDOC |
XXX |
VARCHAR2 |
1 |
MANUAL_LOCK |
XXX |
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 |
XXX |
VARCHAR2 |
1 |
REQUIRED_FOR_DESC |
XXX |
VARCHAR2 |
12 |
REQ_STATUS_CODE |
XXX |
NUMBER |
|
REQ_STATUS_DESCRIPTION |
XXX |
VARCHAR2 |
20 |
SEL_SET_YEAR_TOKEN |
XXX |
NUMBER |
|
STATUS_EFFECTIVE_DT |
XXX |
DATE |
|
STUDENT_FIRST_NAME |
XXX |
VARCHAR2 |
15 |
STUDENT_LAST_NAME |
XXX |
VARCHAR2 |
25 |
STUDENT_TOKEN |
XXX |
NUMBER |
|
STU_AWARD_YEAR_TOKEN |
XXX |
NUMBER |
|
STU_REQ_DOC_CREATED_BY |
XXX |
NUMBER |
|
STU_REQ_DOC_CREATED_DATE |
XXX |
DATE |
|
STU_REQ_DOC_MODIFIED_BY |
XXX |
NUMBER |
|
STU_REQ_DOC_MODIFIED_DATE |
XXX |
DATE |