This table contains information about the scenarios for entities in a consolidation. It indicates scenario involvement in the entity roll-up, and referencing foreign keys, such as those for child and parent attributes. The root entity of the consolidation does not define parent attributes for any scenario rows. Conversely, leaf entities in the consolidation do not define child attributes for any scenario row, and contain a NULL as the child id FK
Table 25. The CN_Scenario Table
Name | Type | Null | Key | Description |
|---|---|---|---|---|
| ID | Integer | N | PK | |
| name | nchar(1) | N | — | Name of the scenario |
| parent scenario | float | Y | — | Name of the parent scenario |
| excluded | nvarchar(1) | N | — | Indicates if the scenario was used in the entity roll–up: 0 = No 1 = Yes |
| parent_attribute_id | Integer | Y | FK | Foreign key to the owned CN_ATTR_PARENT row |
| child_attr_id | Integer | Y | FK | Foreign key to the owned CN_ATTR_CHILD row |
| entity_id | Integer | N | FK | Foreign key to the owning CN_ENTITY row |