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.
Questions about this page? Email us at da-staff@isc.upenn.edu
|