Penn Computing

University of Pennsylvania
Penn Computing << go backback
GF_EXEMPTION Table - Data Element Index   Tables and Data Elements   GF Home   Data Warehouse Home

GF_EXEMPTION Table

(dwngss.gf_exemption)

Explanation
In Grad Funding, schools can allocate funds to students in advance of knowing the specific funding sources. Allocated awards are applied to students' accounts using Banner's "exemptions." An exemption applies credit from a school clearing account. Once specific funding sources are identified, they are defined as "distributions" in Grad Funding. The application will automatically generate BEN journal entries to credit the school's clearing account and debit the actual source(s) of funding.

The GF_EXEMPTION table contains the exemptions that have been defined in Grad Funding, and includes the definition, SAM AID_ID, legacy account, and the related School_ID and clearing account information. The clearing account tables can link to these definitions and exemption attributes using the Exemption_ID.

Common Usage examples

  • Find the descriptive name of an Exemption, using either the Exemption_ID or the Exemption_Code.
  • Identify the clearing account COA Org, COA fund, COA CREF, etc. for a specified Examption.

Primary Key Indexed Data Elements Related Tables
EXEMPTION_ID
     
EXEMPTION_ID
DWNGSS.GF_CLEARING_ACCOUNT_DETAIL
DWMGSS.GS_CLEARING_ACCOUNT_SUMMARY

Cautions
and notes
  • At the initial rollout of Grad Funding, the legacy billing system, BRS, was still in use so the Exemptions created at that time have a related BRS Subcode. Exemptions created after the implementation of Pennant Accounts will not have a BRS Subcode.


Source

  • The Grad Funding online system
GF_EXEMPTION Table - Data Element Index   Tables and Data Elements   GF 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