CN_ATTR_Parent Table

This table describes the parent attributes, if applicable, for the entity scenario and the roll-up contribution to the parent. The root entity of the consolidation does not define parent attributes for its scenario rows and will not contain an entry in this table. Each row additionally describes the periods that were preserved and not rolled up to the parent. This Preserve Periods setting defines blocking by time period, and keeps inputs for time periods that are excluded from those in the consolidation. For example, if child entities started consolidating in 2007, but the parent had data for 2005 and 2006, select Preserve Periods when you export to to keep data for 2005 and 2006.

Table 23. The CNS_ATTR_Parent Table

Name

Type

Null

Key Description
IDIntegerNPK 
preserve_pdsnchar(1)NThe periods not rolled up to the parent and are not zeroed out. Either the inputs or output are preserved.[I]nput, [O]utput, [N]one
basis nchar(1)N[C]hild, [P]arent