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.