Column medicare.qc_enrollments.consistent_curec Lineage SVG

medicare.qc_enrollments.consistent_curec medicare.qc_enrollments.consistent_curec medicare.qc_enrl_bene.consistent_curec medicare.qc_enrl_bene.consistent_curec 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. GENERATED ALWAYS AS (CASE WHEN curec IS NULL THEN 'MISSING' WHEN curec_latest IS NOT NULL THEN 'AMBIGUOUS' ELSE 'CONSISTENT' END) STORED medicare.qc_enrl_bene.consistent_curec->medicare.qc_enrollments.consistent_curec  Transformed medicare.enrollments.consistent_curec medicare.enrollments.consistent_curec 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. GENERATED ALWAYS AS (CASE WHEN curec IS NULL THEN 'MISSING' WHEN curec_latest IS NOT NULL THEN 'AMBIGUOUS' ELSE 'CONSISTENT' END) STORED medicare.enrollments.consistent_curec->medicare.qc_enrl_bene.consistent_curec join natural