Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAID TERM Table


View exposing financial aid term reference data including term codes, start/end dates, enrollment periods, cost-of-attendance attributes, and aid-year definitions used for financial aid packaging, disbursement sequencing, and term-based aid administration.


Field Name

Description

Data Type

Length

ACADEMIC_YEAR_BEGIN_DATE

Date associated with academic year begin.

DATE

ACADEMIC_YEAR_END_DATE

Date associated with academic year end.

DATE

FAID_TERM_CODE

Code identifying faid term.

VARCHAR2

13

FAID_TERM_DESCRIPTION

Description of faid term.

VARCHAR2

30

FAID_TERM_END_DATE

Date associated with faid term end.

DATE

FAID_TERM_KEY

Surrogate key identifying the faid term.

VARCHAR2

13

FAID_TERM_START_DATE

Date associated with faid term start.

DATE

FAID_YEAR

Faid year associated with the record.

NUMBER

FAID_YEAR_DESC

Description of faid year.

VARCHAR2

23

MITSIS_TERM_CODE

Code identifying mitsis term.

VARCHAR2

42

POE_TOKEN

Poe token associated with the record.

NUMBER

WAREHOUSE_INSERT_TIMESTAMP

Warehouse insert timestamp associated with the warehouse record.

DATE

WAREHOUSE_UPDATE_TIMESTAMP

Warehouse update timestamp associated with the warehouse record.

DATE