Each row in this table describes child attributes, if applicable, for the entity scenario and the roll-up contribution to the parent. The leaf entities of the consolidation do not define child attributes for their scenario rows and do have entries in this table. Each row in this table additionally defines the consolidation method used for the roll-up, the period range, the ownership percentage, and an equity subaccount
Table 24. The CNS_ATTR_Child Table
Name | Type | Null | Key | Description |
---|---|---|---|---|
ID | Integer | N | PK | |
method | nchar(1) | N | — | The scenario roll-up method: S]imple, [C]ost, [E]quity, Minority [I]nterest |
percentage | float | N | — | The percent contribution to parent rollup |
first_period | nvarchar(255) | N | — | |
last_period | nvarchar(255) | N | — | |
equity_subacct | nvarchar(255) | Y | — |