xpms.elements
TableRow level security on
The catalog: 1,211 elements (Bible tab 32 and the Item Catalog CSV). Item IDs follow {URID}-{ORG}-{SEQ}.
Primary key: element_id
| Column | Type | Nullable | Description |
|---|---|---|---|
| element_id | xpms.canon_code | No | Item ID {URID}-{ORG}-{SEQ}. |
| urid | xpms.canon_code | No | Category URID of the element.References xpms.dim_category.cat_urid |
| item | xpms.canon_text | No | Item name in Title Case. |
| common_name | xpms.canon_text | Yes | Common name. |
| kind | xpms.canon_code | No | Resource kind. |
| unit_basis | xpms.canon_text | No | Unit basis.References xpms.dim_unit_alias.alias |
| grade | xpms.canon_text | No | Experience grade of the element: Standard, Base, Elevated or Premium. |
| description | xpms.canon_text | Yes | Description, sentence case. |
| specification | xpms.canon_text | Yes | Specification. |
| xyz | xpms.xyz_tag | No | Schema family tag. |
| xyz_basis | xpms.canon_text | No | Basis of the XYZ tag, stored beside it. |
| tier_code | xpms.canon_code | No | Tier of experience.References xpms.dim_tier.tier_code |
| lead_time_hours | numeric | Yes | Lead time in hours. |
| crew | xpms.canon_text | Yes | Crew needed. |
| unspsc | xpms.canon_code | Yes | UNSPSC identifier; recorded, never minted. |
| purchase_account | xpms.canon_code | Yes | Purchase account: the item's explicit GL default (ruling D13 as owner decision 39 reads it), which a posting uses before its class's account.References xpms.dim_gl_account.account_code |
| sales_account | xpms.canon_code | Yes | Sales account: the item's explicit GL default on the revenue side (ruling D13 as owner decision 39 reads it).References xpms.dim_gl_account.account_code |
| default_cost_center | xpms.canon_code | No | Default dimension 1.References xpms.dim_cost_center_template.cost_center_id |
| price_evidence | xpms.canon_text | Yes | Source of the price bands. |
| source | xpms.canon_text | No | Where the element entered canon. |
| mapping_confidence | xpms.canon_text | No | How the element was mapped to its URID. |
| lifecycle_state | xpms.canon_text | No | Lifecycle state from the shared vocabulary.References xpms.dim_state.state |
| external_ref | xpms.canon_text | Yes | Legacy code or touchpoint ID; never a join key. |
| source_row | integer | Yes | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |