RETURN TO BANNER EDW META DATA REPORTS LIST
Financial Aid Award By Academic Period Star  Financial Aid Award By Aid Year Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FINANCIAL_AID_FUND_STATUS

Description The Financial Aid Fund Status Dimension table provides information on the financial aid fund stage of processing. This information includes award offered, accepted, declined, canceled and paid indicators.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
AWARD_ACCEPTED_IND Indicates the current award accepted amount has a value greater than zero. VARCHAR2(63)

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
AWARD_CANCELED_IND Indicates the current award canceled amount has a value greater than zero. VARCHAR2(63)

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
AWARD_DECLINED_IND Indicates the current award declined amount has a value greater than zero. VARCHAR2(63)

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
AWARD_OFFERED_IND Indicates the current award offered amount has a value greater than zero. VARCHAR2(63)

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
AWARD_PAID_IND Indicates the current award paid amount has a value greater than zero. VARCHAR2(63)

ETL GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_FUND_STATUS_KEY Key for the financial aid fund status dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR


Ver: 9.0