RETURN TO BANNER EDW META DATA REPORTS LIST
Financial Aid Application Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FINANCIAL_AID_BUDGET_GRP

Description Financial Aid Budget Group Dimension table provides information on the financial aid applicant's budget group assigned for the financial aid year. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
FINANCIAL_AID_BUDGET_GRP Student's assigned budget group. VARCHAR2(63)

FINAID_APPLICANT_STATUS

BUDGET_GROUP

NO

NO FINANCIAL AID APPLICATION
FINANCIAL_AID_BUDGET_GRP_KEY Key for the budget group dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID APPLICATION
FINANCIAL_AID_BUDGET_GRP_LD Budget group code long description. VARCHAR2(255)

FINAID_APPLICANT_STATUS

BUDGET_GROUP_DESC

NO

NO FINANCIAL AID APPLICATION
FINANCIAL_AID_BUDGET_GRP_SD Budget group code short description. VARCHAR2(255)

FINAID_APPLICANT_STATUS

BUDGET_GROUP_DESC

NO

NO FINANCIAL AID APPLICATION
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 APPLICATION
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO FINANCIAL AID APPLICATION


Ver: 9.0