Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID FUND MANAGEMENT Table


View exposing financial aid fund management records associated with the administration and allocation of financial aid funds.


Field Name

Description

Data Type

Length

AID_YEAR

Aid year associated with the record.

VARCHAR2

4

DISBURSE_DETAIL_CODE

Code identifying disburse detail.

VARCHAR2

4

FINAID_FUND_KEY

Surrogate key identifying the finaid fund.

VARCHAR2

10

FINAID_FUND_MANAGEMENT_KEY

Surrogate key identifying the finaid fund management.

VARCHAR2

10

FUND_CATEGORY

Fund category associated with the record.

VARCHAR2

26

FUND_CODE

Code identifying fund.

VARCHAR2

10

FUND_ORIGINATING_DEPT

Fund originating dept associated with the record.

VARCHAR2

4

FUND_SOURCE

Fund source associated with the record.

VARCHAR2

4

FUND_TITLE

Fund title associated with the record.

VARCHAR2

30

FUND_TYPE

Fund type associated with the record.

VARCHAR2

30

IS_AUTO_PACKAGE

Indicator identifying whether auto package (Y/N).

VARCHAR2

1

IS_DISBURSABLE

Indicator identifying whether disbursable (Y/N).

VARCHAR2

1

IS_REDUCING_NEED

Indicator identifying whether reducing need (Y/N).

VARCHAR2

1

IS_REPLACING_TFC

Indicator identifying whether replacing tfc (Y/N).

VARCHAR2

1

NEED_COMAKER

Need comaker associated with the record.

VARCHAR2

1

REDUCE_SELF_HELP_PERCENT

Reduce self help percent associated with the record.

VARCHAR2

4

USE_FED_LOAN_PROCESS

Use fed loan process associated with the record.

VARCHAR2

1

USE_MIT_LOAN_PROCESS

Use mit loan process associated with the record.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE