Penn Computing

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

GF_EXEMPTION Table - Data Element Index

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

Data element Definition
Allocation_Type_Id

Indexed - no
Format - Number
May be Null? Y

Foreign key to the GF_ALLOCATION_TYPE table.

BRS_Subcode

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

Code from the legacy billing system associated with this exemption

Coa_Bc

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

Budget Code to be used with this exemption

Coa_Cnac

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

CNAC code to be used with this exemption

Coa_Cref

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

Center Ref code to be used with this exemption

Coa_Fund

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

Fund code to be used with this exemption

Coa_Object

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

Object code to be used with this exemption

Coa_Org

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

Organization code to be used with this exemption

Coa_Program

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

Program code to be used with this exemption

Detail_Code

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

Pennant Accounts Detail Code to be used with this exemption

Exemption_Code

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

Numeric code which identifies the exemption to be used for the specified school and allocation type (described in the Exemption_Desc).

See explanation in GF_EXEMPTION Table

Exemption_Desc

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

The text descriptive name of the exemption, which usually contains an abbreviation of the school and degree that will use the exemption, and whether it is Service or Non-Service. For example:

ED, Ph.D., Non-Service
SW, Other Deg, Service
CGS, Non Degree, Non-Service

etc.

Exemption_Id

Indexed - yes
Format - Number
May be Null? N

Primary key of the GF_EXEMPTION table. Generated by Hibernate Sequence

Legacy_Account

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

Old accounting number, used in the legacy system.

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Date the staging table was updated for this record.

Sam_Aid_Id

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

Alpha-numeric code for the AID ID from the Student Aid Management (SAM) system

School_Id

Indexed - no
Format - Number
May be Null? Y

Foreign key to the GF_SCHOOL table. Indicates the school that uses this exemption

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

Date the warehouse was last updated for this record.

Type_Of_Student

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

One character code for the type of student for whom this exemption is used.

Values:

C - Certificate or non-degree student
P - PhD student
G - other graduate student

GF_EXEMPTION 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