Penn Computing

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

COST_ATTENDANCE 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)

Budget_Amount

Indexed - no
Format - Number
May be Null? Y

 

Budget_Desc

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

 

Budget_Field_Number

Indexed - no
Format - Char
May be Null? Y

 

Budget_Type

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

 

Load_Date

Indexed - no
Format - Date
May be Null? Y


The latest date this student's record was refreshed in the warehouse from the Student Aid Management system (SAM). Does not indicate a specific column in a table has changed; the entire student's record gets refreshed whenever there is any change in SAM.

Penn_Id

Indexed - no
Format - Char
May be Null? Y

The 8-digit identification number assigned to the student; populated from a lookup to an extract from the PennCommunity database.

SID

Indexed - yes
Format - Char
May be Null? N

Social security number from source system. This is a protected field.

SAM_Term SAM term for the budget details.   Where term is defined as YYYYT, for example: 2010A = Summer 1 2010, 2010B = Fall 2010 -> Spring 2011, 2010C = Summer 1 2011  
FA_COST_ATTENDANCE 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