Penn Computing

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

GF_ALLOCATION_TYPE Table - Data Element Index

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

Data element Definition
Allocation_Type

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

The code for the allocation type.

Values: S. NS. F. E

Allocation_Type_Desc

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

The name of the allocation type

Values:

S = Service
NS = Non-Service
F = School-based Aid
E = External/Self Funded

Allocation_Type_Id

Indexed - yes
Format - Number
May be Null? N

Internal record key, system-generated.

Display_Order

Indexed - no
Format - Number
May be Null? Y

Used by the online Grad Funding system to control how the allocation will display.

Load_To_Banner

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

A one-character flag (T/F) indicating whether or not allocations of this type will be sent to the Banner (Pennant Accounts) system.

Load_To_Gl

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

A one-character flag (T/F) indicating whether or not allocations of this type will be sent to the General Ledger.

Load_To_Sam

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

A one-character flag (T/F) indicating whether or not allocations of this type will be sent to the Student Accounts Management (SAM) financial aid system.

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Date the staging table was updated for this record.

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

Date the warehouse was last updated for this record.

GF_ALLOCATION_TYPE 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