CostCenterData Table

This table stores each of the cost centers known to FNMP. This will map directly to the External Cost Center 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 `CostCenterData` table
Database Column	Details
`CostCenterID`	Type: integer. Key Unique identifier fro this cost center from the FNMP database.
`GroupExID`	Type: text (max 128 characters) Internal identifier for this cost center.
`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
`CostCenterPath`	Type: text (max 500 characters) The full path to this cost center.
`CostCenterName`	Type: text (max 256 characters) The name of this cost center.