Penn Computing

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

FINANCIAL_DEPARTMENT Table - Data Element Index

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

 

Data element Definition
FIN_DEPARTMENT_CODE

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

The 5-character code in the format used to identify departments in the financial system that was used at Penn before July 1, 1996. Note: This is not the same as the Organization code used in the present General Ledger accounting structure (in use at Penn since July 1, 1996). Example: 11057 (MARKETING)

Values:

Refer to the FINANCIAL_DEPARTMENT Table for values.

FIN_DEPARTMENT_NAME

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

The 30-character name of the department associated with the FIN_DEPARTMENT_CODE. Example: MARKETING (11057)

Values:

Refer to the FINANCIAL_DEPARTMENT Table for values.

FIN_SCHOOL_CODE

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

The 2-character code identifying the school or center for the department (FIN_DEPARTMENT_CODE). FIN_SCHOOL_CODE is stored 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.


FINANCIAL_DEPARTMENT 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