Column medicare.qc_enrl_bene.consistent_curec
Overview of column consistent_curec in table medicare.qc_enrl_bene
Table |
|
Qualified name |
medicare.qc_enrl_bene.consistent_curec |
Datatype |
VARCHAR(12) |
Column type |
generated |
QC flag for CUREC (Current Reason for Entitlement) consistency within this single enrollment record (bene_id, year, state). CUREC legitimately varies across years, so this is a per-year property of the enrollment and lives on this table, not on the beneficiary-grain qc_enrl_bene. AMBIGUOUS means duplicate source records disagreed on CUREC within the year and MAX(curec) picked one. Defensive: expected CONSISTENT on the synthetic dataset (every group is a single row); meaningful on real data with overlapping or reissued MBSF files.
Expressions
SELECT GENERATED ALWAYS AS (CASE WHEN curec IS NULL THEN 'MISSING' WHEN curec_latest IS NOT NULL THEN 'AMBIGUOUS' ELSE 'CONSISTENT' END) STORED