Penn Computing

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

GF_ALLOCATION_CHARGE Table - Data Element Index

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

Data element Definition
Academic_Program_Id

Indexed - no
Format - Number
May be Null? Y

The foreign key to the GF_ACADEMIC_PROGRAM table.

Active

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

Allocation_Component_Id

Indexed - yes
Format - Number
May be Null? N

The primary key for the GF_ALLOCATION_CHARGE table.

Allocation_Id

Indexed - no
Format - Number
May be Null? Y

The foreign key to the GF_ALLOCATION_ORIG table.

Allocation_Type

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

Abbreviation of the allocation type, from the GF_ALLOCATION_TYPE table. Allocation types are Service/Non-Service, Financial Aid or External.

Allocation_Type_Id

Indexed - no
Format - Number
May be Null? Y

The foreign key to the GF_ALLOCATIN_TYPE table.

Amount

Indexed - no
Format - Number
May be Null? Y

The value of Cash, or CUs if Course Charge type is used for the allocation. For most reporting purposes, use Derived_Amount.

Banner_Term

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

The term in Banner to which this Allocation applies.

Charge_Type

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

From the GF_CHARGE_TYPE table: this description is the label used on the Allocation and Funding pages for a given Charge Type

Charge_Type_Id

Indexed - no
Format - Number
May be Null? Y

The foreign key to the GF_CHARGE_TYPE table.

Derived_Amount

Indexed - no
Format - Number
May be Null? Y

The dollar value amount of the allocation.

Entered_By

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

The Penn ID of the user who entered the record

Entered_On

Indexed - no
Format - Date
May be Null? Y

The date the record was created

Last_Edited_By

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

The Penn ID of the last editor of the record

Last_Edited_On

Indexed - no
Format - Date
May be Null? Y

The date the record was last edited

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Package_Name

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

The name of the package. See GF_FUNDING_PACKAGE.

Package_Year

Indexed - no
Format - Number
May be Null? Y

Generic counter for the years, starts with 0 and will contain records up to the max years allowed for the package. This value, combined with the entry year of the student, will ensure that the correct plan for a given year is created correctly.

Penn_Id

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

The student's Penn_ID.

Percentage

Indexed - no
Format - Number
May be Null? Y

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

GF_ALLOCATION_CHARGE 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