Penn Computing

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

PARENT_CNAC_CODES Table - Data Element Index

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



Data Element Definition
CHILD_CNAC

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

The 3-character Center Net Asset Class (CNAC) code for the CNAC associated with the PARENT_CNAC (or rollup group).

Amounts for the CHILD_CNAC will be included when data is summarized by the PARENT_CNAC.

A given PARENT_CNAC may be associated with more than one Child_CNAC, and a given CHILD_CNAC may have more than one parent. For example, CNAC 132 (EAS/PR) has parents 13T (EAS-130, 131, 132), AX2 (NAC 2, (XX2, except 992)), and AC2 (NAC 2, Permanently Restricted). The first two positions of the CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted


Values:

Refer to the CNAC_Codes Table.

PARENT_CNAC_CODE

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

The 3-character Center Net Asset Class (CNAC) code that serves as the parent (or rollup group) for one or more other CNACs, allowing amounts to be summarized at the parent level.

A given CNAC may have more than one parent. For example, CNAC 132 (EAS/PR) has parents 13T (EAS-130, 131, 132) AX2 (NAC 2, (XX2, except 992)), and AC2 (NAC 2, Permanently Restricted). The first two positions of the PARENT_CNAC_CODE identify the parent school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted).


Values:

Refer to the CNAC_CODES Table for values.

PARENT_CNAC_DESC

Indexed - yes
Format - varchar2 (240)
May be null? yes

The description that corresponds to the PARENT_CNAC_Code.

Example: SAS-020, 021, 022 (02T)


Values:

Refer to the CNAC_CODES Table for values.

 
PARENT_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