Penn Computing

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

GF_ALLOCATION_CHARGE_SUMMARY Table

(dwngss.gf_allocation_charge_summary)

Explanation
The GF_ALLOCATION_CHARGE_SUMMARY table rolls up all of the allocation charges into one summary amount, per student, per allocation_id, per academic program, per term.

Common Usage examples

  • Find total allocation charges for specific time periods.
  • Show allocations planned for the coming terms.

Primary Key Indexed Data Elements Related Tables
STUDENT_ID
ALLOCATION_ID
BANNER_TERM
ACADEMIC_PROGRAM_ID
STUDENT_ID
ALLOCATION_ID
BANNER_TERM
ACADEMIC_PROGRAM_ID
DWNGSS.GF_ALLOCATION_CHARGE
DWNGWW.GF_CLEARING_ACCOUNT_SUMMARY
      

Cautions
and notes
  • Data for future terms will only be available if those terms have been populated in the source system.
  • When an allocation amount is disbursed to a student's bill, the disbursement is paid from a school clearing account. The distrubition accounts are then used to reimburse the clearing account. In both cases, the Grad Funding system assigns the appropriate object code. See GF_CLEARING_ACCOUNT_DETAIL and GF_CLEARING_ACCOUNT_SUMMARY.


Source

  • The Grad Funding online system
GF_ALLOCATION_CHARGE 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