Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_AWARD_TERM Table   Tables and Data Elements   FinAid Home   Data Warehouse Home

AWARD Table - Data Element Index

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



 

Data element

Definition

Object name in Business Objects universe (if different from data element name)

Aid_Id

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

Identifies the type and source of aid including federal loans, institutional grant, state grant, work study, etc. Each AIDID has a unique description, and it is used to identify types of aid for each student's account.

 
Calc_Offer

Indexed - no
Format - Number
May be Null? Y

Amount of award offered for this term

 
Calc_Paid

Indexed - no
Format - Number
May be Null? Y

Amount of award paid for this term

 
Coa_Bc

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

 
Coa_Cnac

Indexed - yes
Format - Varchar2(3)
May be Null? Y

 
Coa_Cref

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

 
Coa_Fund

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

 
Coa_Object

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

 
Coa_Org

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

 
Coa_Program

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

 
Enroll_Flag

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

Value of term enrlts flag. Will not propagate to reporting warehouse

 
Gl_Date

Indexed - no
Format - Date
May be Null? Y

 
Last_Updated_By

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

 
Legacy_Account_Number

Indexed - yes
Format - Varchar2(9)
May be Null? Y

Account number used to match award type to BEN Financials

 
Load_Date

Indexed - no
Format - Date
May be Null? Y

 
Long_Description

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

Description of the award, that prints on the Award Letter

 
Long_Name

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

Name of the award, from SAM table file in a decode table

 
Offer_Amount

Indexed - no
Format - Number
May be Null? Y

Amount of award type offered for this term

 
Originally_Populated_By

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

 
Paid_Amount

Indexed - no
Format - Number
May be Null? Y

Amount of award type paid for this term

 
Paid_Status

Indexed - yes
Format - Varchar2(15)
May be Null? Y

Payment status of award, N = Not ready, R = Ready, P = Paid, M=Manual

 
Penn_Id

Indexed - yes
Format - Char
May be Null? Y

 
Program_Name

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

A short, unique description for a specific award type which identifies source of funds. E.g. REF. STF. Describes a referred Stafford Loan

 
SAM_Term

Indexed - yes
Format - Varchar2(5)
May be Null? Y

Identifies the term to which the associated Student Aid Management information pertains. 'B' implies the fall term of the calendar year, followed by the spring term of the following calendar year. 'A' is the label for the summer session before the academic year, and 'C' is the tag for the summer session following the academic year. (E.g. 2009B is Fall 2009 to Spring 2010, 2009C is the first summer session in Summer 2010, followed by 2010A for the second summer session)

 

SAM School Code

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

SAM School Code (NN)  
SID

Indexed - yes
Format - Char
May be Null? N

The Student ID, normally SSN, which serves as the key for the SAM system. The data in this field will be restricted to only those individuals who are granted the SSN role.

 
Source

Indexed - yes
Format - Varchar2(15)
May be Null? Y

Source of funds. Based on 1st number of account (actually should use the legacy account fund type from BEN)

 

SRS School Code

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

SRS School Code (AA)

Note: in the Business Objects universe, there is also a decode for the SRS School Name, using a lookup to the SCHOOL table.

 

SRS Division Code

Indexed - yes
Format - Varchar2(3)
May be Null? Y

SRS Division Code (AAA)

Note: in the Business Objects universe, there is also a decode for the SRS Division Name, using a lookup to the DIVISION table.

 
SRS_Term

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

The term in the Student Records System (SRS) that corresponds to the SAM term on this record. SRS terms use A for Spring, B for Summer and C for Fall.

 
Term_Session

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

The term session in the Student Records System (SRS) that corresponds to the SAM term on this record. SRS term sessions use 1, 2, blank (full term) or S for Special session.

 
FA_AWARD_TERM Table   Tables and Data Elements   FinAid 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