Version: 1.0.0 Last Updated: 2026-02-18 Source: CL-PM-SPEC-REVIEW Finding 8.6 This document defines JSONB column shapes for critical CL and PM tables. Implementations MUST validate or document deviations.Documentation Index
Fetch the complete documentation index at: https://docs.encoreos.io/llms.txt
Use this file to discover all available pages before exploring further.
CL-11: Consent Management
cl_consents.consent_scope (if JSONB)
cl_consents.revocation_reason (if JSONB)
PM-02: Insurance & Eligibility
pm_insurance_policies.bh_benefits (if JSONB)
pm_eligibility_checks.benefit_details (if JSONB)
PM-08: Claims
pm_claims.denial_codes (JSONB — array of objects)
Canonical format per PM-08 Clarifications (2026-02-19) and X12-EDI-TECHNICAL-DESIGN.md CAS segment mapping. Preserves per-adjustment amounts and group codes required for ERA 835 posting (PM-09).
pm_claim_lines.adjustment_reason (JSONB — array of objects)
Same structure as claim-level denial_codes, applied per line.
CL-04: Progress Notes
cl_progress_notes.sections or note body (if JSONB)
CL-08: Clinical Decision Support
cl_cds_rules.rule_config (if JSONB)
Unlinked FK Resolution (Reference)
| Spec | Column | Target | Resolution |
|---|---|---|---|
| CL-12 | cl_transitions.discharge_summary_id | Document or CL table | Define in CL-12: e.g. REFERENCES pf_documents(id) or cl_discharge_summaries(id) when spec exists |
| CL-12 | cl_transitions.medication_reconciliation_id | CL-05 | Add cl_medication_reconciliations in CL-05 or reference by ID with doc |
| PM-07 | pm_charges.encounter_id | pm_encounters | FK to pm_encounters(id) per CL-PM-ENCOUNTER-TO-BILLING |
| CL-14 | cl_group_sessions.curriculum_id | Curriculum entity | PF or CL picklist/reference table; document in CL-14 |
| CL-14 | cl_group_sessions.program_id | rh_programs or PF | FK to rh_programs(id) or pf_programs(id) when defined |
| PM-04 | pm_group_definitions.program_id | Same as above | Align with CL-14 program reference |