xpms.dim_record_subtype
TableRow level security on
The 124 kind-scoped record subtypes (Bible tab 25). The composite key lets a record carry a subtype only for its own kind.
Primary key: record_kind, record_subtype
| Column | Type | Nullable | Description |
|---|---|---|---|
| record_kind | xpms.canon_text | No | Kind the subtype belongs to.References xpms.dim_record_kind.record_kind |
| record_subtype | xpms.canon_text | No | Subtype label. |
| ordinal | integer | No | Position of the subtype in its Bible tab; the canonical display order where the code is not numeric. |
| unspsc_segment | xpms.canon_text | Yes | UNSPSC segment and its title, where canon gives one. |