Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID NA METHODOLOGY Table


Contains the definitions of need analysis methodologies used by MIT Student Financial Services to determine financial aid eligibility of student financial aid applicants.


Field Name

Description

Data Type

Length

IS_CUSTODIAL_PARENT

A flag indicates whether the methodology is used for custodial parent(s). Y=Yes, N=No.

VARCHAR2

1

IS_FEDERAL

A flag indicates whether the methodology is a Federal Methodolgy. Y=Yes, N=No.

VARCHAR2

1

IS_INSTITUTIONAL

A flag indicates whether the methodology is an Institutional Methodology. Y=Yes, N=No.

VARCHAR2

1

IS_NON_CUSTODIAL_PARENT

A flag indicates whether the methodology is used for non-custodial parent(s). Y=Yes, N=No.

VARCHAR2

1

METHODOLOGY_DESC

Description of a methodology.

VARCHAR2

50

METHODOLOGY_TYPE

Codes for the different types of methodology: FM (Federal Methodology), IMC (Institutional Methodology for Custodial Parents), and IMN (Instituional Methodology for Non-custodial parents)

VARCHAR2

4

METHODOLOGY_TYPE_KEY

Key indentifying an entry in the Financial Aid Need Analysis Methodology Table. This field should only be used for linking together the tables of FINAID NA METHODOLOGY and FINAID NEED ANALYSIS DETAIL, NOT for reporting.

VARCHAR2

4