CorporateUnitData Table

This table will store each of the corporate units known to FNMP. This will map directly to the External Corporate Unit Dimension.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.

Table 1. Database columns for `CorporateUnitData` table
Database Column	Details
`CorporateUnitID`	Type: integer. Key Unique identifier for this corporate unit from the FNMP database.
`GroupExID`	Type: text (max 128 characters) Internal identifier for this corporate unit.
`Level1`	Type: integer Parsed GroupExID, first level
`Level1Name`	Type: text (max 500 characters) Parsed Path, first level
`Level2`	Type: integer. Nullable Parsed GroupExID, second level
`Level2Name`	Type: text (max 500 characters). Nullable Parsed Path, second level
`Level3`	Type: integer. Nullable Parsed GroupExID, third level
`Level3Name`	Type: text (max 500 characters). Nullable Parsed Path, third level
`Level4`	Type: integer. Nullable Parsed GroupExID, fourth level
`Level4Name`	Type: text (max 500 characters). Nullable Parsed Path, fourth level
`Level5`	Type: integer. Nullable Parsed GroupExID, fifth level
`Level5Name`	Type: text (max 500 characters). Nullable Parsed Path, fifth level
`Level6`	Type: integer. Nullable Parsed GroupExID, sixth level
`Level6Name`	Type: text (max 500 characters). Nullable Parsed Path, sixth level
`Level7`	Type: integer. Nullable Parsed GroupExID, seventh level
`Level7Name`	Type: text (max 500 characters). Nullable Parsed Path, seventh level
`Level8`	Type: integer. Nullable Parsed GroupExID, eighth level
`Level8Name`	Type: text (max 500 characters). Nullable Parsed Path, eighth level
`Level9`	Type: integer. Nullable Parsed GroupExID, ninth level
`Level9Name`	Type: text (max 500 characters). Nullable Parsed Path, ninth level
`Level10`	Type: integer. Nullable Parsed GroupExID, tenth level
`Level10Name`	Type: text (max 500 characters). Nullable Parsed Path, tenth level
`CorporateUnitPath`	Type: text (max 500 characters) The full path to this corporate unit.
`CorporateUnitName`	Type: text (max 256 characters) The name of this corporate unit.