Skip to main content
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.

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)

Use consistent keys per template; validate required sections before finalize.

CL-08: Clinical Decision Support

cl_cds_rules.rule_config (if JSONB)


Unlinked FK Resolution (Reference)

Implement migrations with FKs when target tables exist; otherwise document as “intentionally unlinked until [spec].”