Claim lines with payer, CARC and RARC denial codes, adjudication dates and payments. One row per claim line per adjudication event. Aggregates feed StrataJazz and the denials dashboard.
3 upstream · 3 downstream · Show in the estate graph
Source · Systems of record, untouched
Bronze · Raw landing, append-only
Silver · Cleaned and conformed
Gold · Certified data products
Serve · Reports, research and AI
SG-DP-RC-CLAIMS-READAdded to SG-DP-RC-CLAIMS-READ, recertified every 90 days.
Every 835 line matches an 837 claim
Conformance
CARC code in X12 value set
Validity
No duplicate adjudication events
Uniqueness
Payer mapped to a conformed payer group
Conformance
Refreshed within SLA
Timeliness
Pass at 98% or better, warn from 90%. A failing check blocks certification.
| Column | Type | Description | Class |
|---|---|---|---|
| claim_line_id | varchar(24) | Claim ID plus line number | None |
| mrn | varchar(12) | Patient MRN | PHI |
| payer_group | varchar(40) | Conformed payer group | None |
| carc_code | varchar(5) | Claim adjustment reason code | None |
| is_denied | boolean | True when the line was denied in this event | None |
| adjudication_date | date | 835 adjudication date | None |