Penn Computing

University of Pennsylvania
Penn Computing << go backback
FINANCIAL_SCHOOL Table   Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home

FINANCIAL_SCHOOL Table - Data Element Index

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

 

Data element Definition
FIN_SCHOOL_CODE

Indexed - yes
Format - char (2)
May be null? no

The 2-character code in the format used to identify schools and centers in the financial system that was used at Penn before July 1, 1996. Note: This is not the same as the school/center code in the present General Ledger accounting structure (in use at Penn since July 1, 1996). Example: 35 (SOCIAL WORK). 

Values:

Refer to the FINANCIAL_SCHOOL Table for values.

FIN_SCHOOL_NAME

Indexed - no
Format - char (30)
May be null? yes

The 30-character name of the school or center associated with the FIN_SCHOOL_CODE. Example: SOCIAL WORK (35). 

Values:

Refer to the FINANCIAL_SCHOOL Table for values.


FINANCIAL_SCHOOL Table   Tables and Data Elements   Sponsored Projects 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