Penn Computing

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

GF_CLEARING_ACCOUNT_DETAIL Table - Data Element Index

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

Data element Definition
Account

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

The 26-digit Chart of Accounts number in BEN, for the clearing account that was debited or credited for the funded amount.

Amount

Indexed - no
Format - Number
May be Null? Y

The amount in the Clearing Account that was either debited or credited. When the clearing account is debited the amount will be positive. When the clearing account is credited (meaning the actual funding source account will be debited), the amount will appear with a minus sign, i.e., as a negative number in GF_CLEARING_ACCOUNT_DETAIL.

.

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(40)
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..

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.

GF_Allocation_Id

Indexed - no
Format - Number
May be Null? Y

n/a

GF_Exemption_Id

Indexed - no
Format - Number
May be Null? Y

Internal key to the GF_EXEMPTION table.

GF_Gurfeed_Trans_Log_Id

Indexed - yes
Format - Number
May be Null? N

Internal unique key to this table.

GF_Job_Id

Indexed - no
Format - Number
May be Null? Y

GF_Student_Id

Indexed - no
Format - Number
May be Null? Y

Internal identifying for the student in the Grad Funding system. For reporting purposes, use Penn_ID instead of GF_Student_ID.

GF_Term_Id

Indexed - no
Format - Number
May be Null? Y

Internal key to the GF_Term table, that contains mapping of terms to other systems (SRS, 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.

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

Processed_Date

Indexed - no
Format - Date
May be Null? Y

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

Date the Data Warehouse was last updated for this record.

GF_CLEARING_ACCOUNT_DETAIL 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