GF_CLEARING_ACCOUNT_DETAIL Table - Data Element Index   Tables and Data Elements   GF Home   Data Warehouse Home

GF_CLEARING_ACCOUNT_DETAIL Table

(dwngss.gf_clearing_account_detail)

Explanation

Grad Funding allows schools to apply credit to a student's account in advance of knowing the specific funding sources. Allocated awards are applied to students' accounts using a Banner payment function called an "exemption." An exemption applies credit from a school clearing account consistent with award restrictions. 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 for each student. This table shows the details of the amounts being debited and credited in the clearing account.

Common Usage examples

• Find exemptions that have hit the clearing account but that have not yet been credited out.
  
  

GF_GURFEED_TRANS_LOG_ID
     

GF_GURFEED_TRANS_LOG_ID
PENN_ID
BANNER_TERM
      

GF_CLEARING_ACCOUNT_SUMMARY
GF_EXEMPTIONS
GF_TERM

• The columns BRS_TERM and BRS_SUBCODE are populated through October 2015 only, after which time the legacy BRS system was replaced by Pennant Accounts (Banner).
  
  

Source

• The Grad Funding online system

GF_CLEARING_ACCOUNT_DETAIL Table - Data Element Index   Tables and Data Elements   GF Home   Data Warehouse Home