Penn Computing

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

GF_ALLOCATION_FUNDING_SOURCE Table - Data Element Index

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

Data element Definition
Account_Group_Id

Indexed - no
Format - Number
May be Null? Y

The Account group from which funding will come. This is a foreign key to the LOV_ACCOUNT_GROUP table

Account_Group_Name

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

The Account group name is a way to categorize Accounts. A set of Account groups are owned by a single org, which allows editing and retirement of this account group.

Allocation_Funding_Id

Indexed - yes
Format - Number
May be Null? N

The primary key of the GF_ALLOCATION_FUNDING_SOURCE table.

Allocation_Id

Indexed - no
Format - Number
May be Null? Y

The foreign key to the GF_ALLOCATION_ORIG table

Appointment_Org

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

The Organization code from which the distribution funding will come

Covers_Fall

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

This boolean indicates whether or not the funding is for the Fall semester of the allocation year. Note that funding sources can cover more than one term.

Values:

T - funding covers Fall term
F - funding does not cover Fall term

Covers_Spring

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

This boolean indicates whether or not the funding is for the Spring semester of the allocation year. Note that funding sources can cover more than one term.

Values:

T - funding covers Spring term
F - funding does not cover Spring term

Covers_Summer1

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

This boolean indicates whether or not the funding is for the Summer 1 semester of the allocation year. Note that funding sources can cover more than one term.

Values:

T - funding covers Summer 1 term
F - funding does not cover Summer 2 term

Covers_Summer2

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

This boolean indicates whether or not the funding is for the Summer 2 semester of the allocation year. Note that funding sources can cover more than one term.

Values:

T - funding covers Summer 2 term
F - funding does not cover Summer 2 term

Entered_By

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

The Penn ID of the user who created the Allocation funding record

Entered_On

Indexed - no
Format - Date
May be Null? Y

The date the record was created

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

GF_ALLOCATION_FUNDING_SOURCE 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