CategoryData Table

This table stores each of the categories known to FNMP. This maps directly to the External Category 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 `CategoryData` table
Database Column	Details
`CategoryID`	Type: integer. Key Unique identifier for this category from the FNMP database.
`GroupExID`	Type: text (max 128 characters) Internal identifier for this category.
`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
`CategoryPath`	Type: text (max 500 characters) The full path to this category.
`CategoryName`	Type: text (max 256 characters) The full name of this category.