Penn Computing

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

GF_ALLOCATION_STIPEND Table - Data Element Index

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

Data element Definition
Allocation_Id

Indexed - yes
Format - Number
May be Null? N

File key, system-generated.

Accounting_Period

Indexed - yes
Format - Varchar2(6)
May be Null? N

The General Ledger Accounting Period that this stipend is expected to hit, in MMM-YY format.

Allocation_Type_Desc

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

Allocation types are Service, Non-Service, Financial Aid or External.

See DWNGSS.GF_ALOOCATION_TYPE table.

Budgeted_Amount

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

The amount, in US dollars, being budgeted for this stipend.

Fiscal_Year

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

The Fiscal Year that this stipend is to be used. Fiscal years run from July 1 through June 30, and the year is the calendar year of the second half. For example, July 1 2015 through June 30 2016 is Fiscan Year 2016.

Funding_Year

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

The academic year this stipend funding applies to.

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Date the staging table was updated for this record.

Package_Name

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

The name of the package. See GF_FUNDING_PACKAGE.

Package_Line_ID

Indexed - no
Format - Number (22)
May be Null? Y

Internal Grad Funding system key to DWNGSS.GF_FUNDING_PACKAGE_LINE.

(note used by the Grad funding Business Objects universe)

Penn_Id

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

The student's Penn_ID.

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

Date the warehouse was last updated for this record.

Stipend_Type_ID

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

Internal key to the DWNGSS_GF_STIPEND_TYPE table.
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