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.