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.
|