CLASSIFICATIONS - Registry Table
Use the CLASSIFICATIONS registry table to specify which tables are classification tables, and which columns in those tables represent the code and the name.
A table cannot be both a fact table and a classification. If the same table is incorrectly specified in both the FACTS registry table and the CLASSIFICATIONS registry table, then the FACTS table takes priority.
If a table is not defined as either a fact or classification table, it will automatically be treated as a plain table (these tables are not included in the SuperSTAR database).
Table Definition
| Column Name | Data Type | Size | Primary Key | Specifies... |
|---|---|---|---|---|
| TABLENAME | string | 128 | YES | The name of a table that should be treated as a classification table. |
| VALUECODE | string | 128 | The column in this table to use as the Code for the classification. The Code column must be a primary key in the classification table. | |
| DISPLAYNAME | string | 128 | The column in this table to use as the Name. | |
| TOTALSAPPROPRIATE | string | 128 | Whether to allow totals for this classification table. This setting is designed for situations where it does not make sense to generate totals based on this classification (for example, you may have a time series database where it does not make sense to sum across years). The setting currently applies to SuperWEB2 only; it does not affect totals in SuperCROSS. This column takes one of the following values:
|
Example
