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

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FINANCIAL_AID_PACKAGE_GRP

Description Financial Aid Package Group Dimension table provides information on the financial aid applicant's package 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_PACKAGE_GRP Assigned packaging group for this financial aid applicant. VARCHAR2(63)

FINAID_APPLICANT_STATUS

PACKAGING_GROUP

NO

NO FINANCIAL AID APPLICATION
FINANCIAL_AID_PACKAGE_GRP_KEY Key for the package group dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID APPLICATION
FINANCIAL_AID_PACKAGE_GRP_LD Long description assigned to the packaging group. VARCHAR2(255)

FINAID_APPLICANT_STATUS

PACKAGING_GROUP_DESC

NO

NO FINANCIAL AID APPLICATION
FINANCIAL_AID_PACKAGE_GRP_SD Short description assigned to the packaging group. VARCHAR2(255)

FINAID_APPLICANT_STATUS

PACKAGING_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