This table contains rows for each entity in the consolidation hierarchy. Parent child relationships among entities in the hierarchy are described by the value in the parent_entity_id column. If this value is -1, the current row is the root of the hierarchy. If the same entity is involved in the consolidation, but under another parent, two separate rows represent the entities involvement for each parent. Each row indicates if the entity was included in the consolidation and foreign key referencing the consolidation structure it belongs to.
Table 26. The CN_Entity Table
Name | Type | Null | Key | Description |
|---|---|---|---|---|
| ID | Integer | N | PK | |
| name | nchar(225) | N | — | Name of the entity |
| excluded | nvarchar(1) | N | — | Indicates if the entity was involved in the consolidation: 0= No 1 = Yes |
| parent_entity_id | Integer | N | RK | ID column in the CN_ENTITY table that represents the parent entity |
| structure_id | Integer | N | FK | Foreign key to the owning CN_STRUCTURE row |