xpms.dim_touchpoint
TableRow level security on
The 90 five-sense touchpoints (Bible tab 10) with Base, Elevated and Premium grades.
Primary key: touchpoint_id
| Column | Type | Nullable | Description |
|---|---|---|---|
| touchpoint_id | xpms.canon_code | No | Touchpoint code. |
| ordinal | integer | No | Position of the touchpoint in its Bible tab; the canonical display order where the code is not numeric. |
| sense | xpms.canon_text | No | Sense family. |
| brief_element | xpms.canon_text | No | Brief element. |
| category | xpms.canon_text | No | Touchpoint category. |
| item | xpms.canon_text | No | Touchpoint item. |
| base | xpms.canon_text | No | Base grade description. |
| elevated | xpms.canon_text | No | Elevated grade description. |
| premium | xpms.canon_text | No | Premium grade description. |
| optional_upgrades | xpms.canon_text | Yes | Optional upgrades. |
| add_ons | xpms.canon_text | Yes | Add-ons. |
| substitutions | xpms.canon_text | Yes | Substitutions. |
| venue_zone | xpms.canon_text | Yes | Venue zone. |
| event_tier_fit | xpms.canon_text | Yes | Event tier fit as canon states it. |
| dept_code | xpms.canon_code | No | Department class.References xpms.dim_department.dept_code |
| division | xpms.canon_text | Yes | Division label. |
| tier_code | xpms.canon_code | No | Tier of experience.References xpms.dim_tier.tier_code |
| lifecycle_phase_code | xpms.canon_code | Yes | Lifecycle gate, relabeled to 4.0; NULL where canon names a value that is not a gated phase (held in xpms.intake). A name an owner ruling reads as a gated phase takes that phase (decision 39: Show is OPR).References xpms.dim_phase.phase_code |
| xyz | xpms.xyz_tag | No | Schema family tag. |