Penn Computing

University of Pennsylvania
Penn Computing << go backback
GF_CLEARING_ACCOUNT_SUMMARY Table . Tables and Data Elements . Grad Funding Home . Data Warehouse Home

GF_CLEARING_ACCOUNT_SUMMARY Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Amount

Indexed - no
Format - Number
May be Null? Y

The sum of the amounts in the clearing account, for a student in a term for each detail code's amounts. This is the term balance for those charge for that student. For example, if in the GF_CLEARING_ACCOUNT_DETAIL table there is a row with amount 500 and another row with -500 for the same student in the same term for the same detail code, the amount in the GF_CLEARING_ACCOUNT_SUMMARY table will be zero.

Banner_Term

Indexed - yes
Format - Varchar2(24)
May be Null? Y

The Banner Term to which the exemptions apply, in YYYYTT format, where TT is:

10 = SPring, 22 = Summer1, 24 = Summer2, 30 = Fall

Brs_Subcode

Indexed - no
Format - Varchar2(20)
May be Null? Y

The legacy billing system's subcode, if applicable

Note: BRS was replaced by Pennant Accounts in October of 2015. This column will only be populated for account actiivity that transpired prior to Pennant Accounts..

Brs_Term

Indexed - no
Format - Varchar2(12)
May be Null? Y

The legacy billing systems code for the academic term

Note: BRS was replaced by Pennant Accounts in October of 2015. This column will only be populated for account actiivity that transpired prior to Pennant Accounts..

Clearing_Account_Id

Indexed - yes
Format - Number
May be Null? N

Internal record key, system-generated.

Detail_Code

Indexed - no
Format - Varchar2(16)
May be Null? Y

The Pennant Accounts Detail Code applicable for this record. Note that Detail Codes used for exemptions all start with 'X'

See DWNGSS.DETAIL_CODE for valid values.

Entered_By

Indexed - no
Format - Varchar2(32)
May be Null? Y

Entered_On

Indexed - no
Format - Date
May be Null? Y

The date the record was created in the Grad Funding system.

Exemption_Code

Indexed - no
Format - Varchar2(32)
May be Null? Y

a numeric code that can be mapped to an exemption description.

See also GF_EXEMPTION

Exemption_Desc

Indexed - no
Format - Varchar2(320)
May be Null? Y

The text description of the exemption, in Grad Funding.

See also GF_EXEMPTION.

Gfc_Account

Indexed - no
Format - Varchar2(104)
May be Null? Y

The 26-digit Chart of Accounts number in BEN, for the clearing account to which the summary amount applies.

GF_Exemption_Id

Indexed - no
Format - Number
May be Null? Y

Internal numeric foreign key to the GF_Exemption table, where exemptions are decoded and mapped to COA segments.

GF_Student_Id

Indexed - no
Format - Number
May be Null? Y

Internal numeric foreign key to the GF_Student table. For reporting purposes, it is better to use Penn_ID instead of Student_ID.

GF_Term_Id

Indexed - no
Format - Number
May be Null? Y

Internal numeric foreign key to the GF_Term table, where terms are decoded and mapped to term codes from other systems (SRS, BRS, Banner, PLS)

GF_Year

Indexed - no
Format - Number
May be Null? Y

The Funding year, which runs from Fall of the first year through the summer terms of the following year. For example, Fall 2015, Spring 2016, Summer1 2016 and Summer2 2016 all fall within GF_Year 2016.

Last_Edited_By

Indexed - no
Format - Varchar2(32)
May be Null? Y

Last_Edited_On

Indexed - no
Format - Date
May be Null? Y

The date the record was last changed in the Grad Funding system.

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Date the staging table was updated for this record.

Penn_Id

Indexed - yes
Format - Varchar2(32)
May be Null? Y

The student's Penn_ID.

Sam_Aid_Id

Indexed - no
Format - Varchar2(16)
May be Null? Y

The Aid identification code from the Student Aid Management system (AID).

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

Date the warehouse was last updated for this record.

GF_CLEARING_ACCOUNT_SUMMARY Table . Tables and Data Elements . Grad Funding 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