Penn Computing

University of Pennsylvania
Penn Computing << go backback
CENTER_REF_CODES Table   Tables and Data Elements   General Ledger Home   Data Warehouse Home

CENTER_REF_CODES Table - Data Element Index

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

 

Data element Definition
CENTER_REF_CODE

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

The 4-character CENTER REFERENCE CODE uniquely defined by the school or center identified in the CNAC_CODE.

CENTER_REF_CODE is used to record information important to a school or center but inappropriate for any other segment of the Accounting Flexfield. No two center references will have the same code within a school or center. However, a given CENTER_REF_CODE will have different meanings to different schools or centers.

CENTER_REF_CODE is the seventh and last segment of the Accounting Flexfield.

Examples: 2000 (DEPARTMENT CHAIR); 2116 (MUSIC).


Values:

Refer to the CENTER_REF_CODES table for values.

CENTER_REF_DESC

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

The name that corresponds to the CENTER_REF_CODE for the school or center. (The school or center is identified in the CNAC_CODE.)

A center reference is used to record information that is important to a school or center but inappropriate for any other segment of the Accounting Flexfield.

Examples: DEPARTMENT CHAIR (2000); MUSIC (2116)


Values:

Refer to the CENTER_REF_CODES tables for values.

CNAC_CODE

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

The 3-character CENTER NET ASSET CLASS code for the school or center that defined the CENTER_REF_CODE.

The first two positions of the CNAC_CODE identify the specific school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). CNAC_CODE is the first segment of the Accounting Flexfield.

Examples: 070 (Wharton General Unrestricted funds); 000 (University General Unrestricted funds).


Values:

Refer to the CNAC_Codes table for values.

ENABLED

Indexed - no
Format - char (1)
May be null - yes

Indicates whether the CENTER_REF_CODE may be used in BEN Financials transactions.

Examples: Y (CENTER_REF_CODE may be used in BEN Financials transactions); N (CENTER_REF_CODE may not be used in BEN Financials transactions)


Values:

Y   CENTER_REF_CODE may be used in BEN Financials transactions.

N   CENTER_REF_CODE may not be used in BEN Financials transactions.


CENTER_REF_CODES Table   Tables and Data Elements   General Ledger 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