Penn Computing

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

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

Address

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

 

City

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

 

Country

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

 

Postal_Code

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

 

Province

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

 

School_Code

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

 

School_Name

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

 

State_Code

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

 

Zip_Code

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

 

FA_FED_SCHOOL_LIST 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