Penn Computing

University of Pennsylvania
Penn Computing << go backback
CNAC_CODES Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

CNAC_CODES Table

Explanation
Reference table for codes identifying the school or center and the net asset class: 0 (Restricted), 1 (Temporarily Restricted), 2 (Permanently Restricted).

Contains the 3-character CNAC_CODE, the 30-character CNAC_DESC, and the 70-character CENTER_NAME. For example, the description corresponding to CNAC_CODE 020 is SAS/UR, and the corresponding center name is School of Arts and Sciences.

Common Uses
Displaying the description of the school or center and the net asset class (or the name of the school or center), rather than the Center Net Asset Class code that appears in a related table. ("Don't show the codes in the report. Show the English instead.")

Primary Key Indexed Data Elements Related Tables

CNAC_CODE

CNAC_CODE


BALANCES

CENTER_REF_CODES

GL_FULL_OLD_TO_NEW

GL_PART_OLD_TO_NEW 

PARENT_CNAC_CODES

SUMMARY_BALANCES


Cautions
  • Remember that CNAC is a combination of Center and Net Asset Class. There will be multiple records for a given center because a center may use more than one Net Asset Class.
CNAC_CODES Table - Data Element Index   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