Data Warehouse

ALTERNATIVE_LOAN

XXX

VARCHAR2

1

ANTICIPATED

XXX

VARCHAR2

1

FAID_FUND_CODE

XXX

VARCHAR2

10

FAID_FUND_KEY

XXX

VARCHAR2

20

FAID_FUND_SOURCE

XXX

VARCHAR2

4

FAID_FUND_TITLE

XXX

VARCHAR2

40

FAID_FUND_TYPE

XXX

VARCHAR2

5

FAID_YEAR

XXX

NUMBER

FAID_YEAR_DESC

XXX

VARCHAR2

23

FUND_AMOUNT_ACCEPTED

XXX

NUMBER

FUND_AMOUNT_AWARDED

XXX

NUMBER

FUND_AMOUNT_PAID

XXX

NUMBER

FUND_AVAILABLE_DOLLARS

XXX

NUMBER

FUND_BALANCE

XXX

NUMBER

FUND_GRANT_SUBTYPE

XXX

VARCHAR2

4

FUND_MAXIMUM

XXX

NUMBER

FUND_MINIMUM

XXX

NUMBER

FUND_NUMBER_ACCEPTED

XXX

NUMBER

FUND_NUMBER_AWARDED

XXX

NUMBER

FUND_NUMBER_PAID

XXX

NUMBER

FUND_TOKEN

XXX

NUMBER

INCLUDE_IN_NEED_BASED

XXX

VARCHAR2

1

IS_FEDERAL_DIRECT_LOAN

Whether the fund is a federal direct loan. Y=Yes, N=No.

VARCHAR2

1

IS_PARENT_LOAN

Whether the fund is a parent loan. Y=Yes, N=No.

VARCHAR2

1

IS_REDUCING_NEED

Whether this fund/award will reduce the amount of financial aid need of the aid applicant.

VARCHAR2

1

IS_REPLACING_TFC

XXX

VARCHAR2

1

LOAN_TYPE

XXX

VARCHAR2

1

NET_PROCEEDS_PERCENT

XXX

NUMBER

NON_PARS_FLAG

XXX

VARCHAR2

1

WAREHOUSE_INSERT_TIMESTAMP

XXX

DATE

WAREHOUSE_UPDATE_TIMESTAMP

XXX

DATE