Penn Computing

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

FINANCIAL_SCHOOL Table

Explanation
Lookup table for financial school codes in the format used in the financial system that was used at Penn before July 1, 1996. For example, the name that corresponds to school 35 is "SOCIAL WORK."

Common Uses

  • Displaying the name of the school instead of the school code that appears in one of the related tables. ("Don't show the codes in the report. Show the English instead.")
Primary Key Indexed Data Elements Related Tables
FIN_SCHOOL_CODE

FIN_SCHOOL_CODE

MONTHLY_EXPENDITURE

PROJECT_EXPENDITURE

Cautions
  • FIN_SCHOOL_CODE is the 2-digit school code used in the financial system that was used at Penn before July 1, 1996. It is not the same as the school/center code in the present General Ledger accounting structure (in use at Penn since July 1, 1996).
FINANCIAL_SCHOOL Table - Data Element Index    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