Penn Computing

University of Pennsylvania
Penn Computing << go backback

CNAC_CODES Table
   Tables and Data Elements   General Ledger Home   Data Warehouse Home

CNAC_CODES Table - Data Element Index

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



Data element Definition

CENTER_NAME

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

The name of the school or center that corresponds to the first two characters in the CNAC_CODE.

Example: School of Arts and Sciences (the first two characters of CNAC_CODE 020)


Values: 

Refer to the CNAC_Codes table for values.

CNAC_CODE

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

The 3-character Center Net Asset Class 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.

CNAC_DESC

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

The description that corresponds to the CNAC_CODE.

Example: SAS/UR (020)


Values: 

Refer to the CNAC_Codes table for values.


CNAC_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