Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_BUDGET_GRP_BY_PERIOD column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Budget Group by Period table

(dwngss_pf.fa_budget_grp_by_period)

Explanation

Applicant period budget group table. This table lists the budget group assigned to the fiancial aid applicant for a period within the aid year.

Source

The warehouse Financial Aid Budget Group by Period (dwngss_pf.fa_budget_grp_by_period) table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source tables are FAISMGR_RBRAPBG and FAISMGR_RTVPBGP.

Common Uses

  • Identify budget group for individual applicants for a given period within an aid year.

 

Primary Key Indexed Data Elements Related Tables
FA_BUDGET_GRP_PRD_PK

AIDY_CODE
PIDM
RUN_NAME
PERIOD

FA_BUDGET_COMP_BY_PERIOD
FA_BUDGET_RULES_V

Cautions and notes

  • When joining to this table, keep in mind that the table is based on period rather than aid year. If your other tables are based on aid year, your join may duplicate the information from the other table.
FA_BUDGET_GRP_BY_PERIOD column definitions . Pennant Financial Aid Home . Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania