Column medicare._enrollments.curec_latest

Overview of column curec_latest in table medicare._enrollments


Table	medicare._enrollments
Qualified name	medicare._enrollments.curec_latest
Datatype	string
Column type	computed

Non-null only when duplicate source records disagree on CUREC within a (bene_id, year, state) group. Drives consistent_curec. Defensive / future-proofing: this multiplicity does not occur in the synthetic dataset (every group is a single row) but can arise in real Medicare data from overlapping or reissued MBSF files, where MAX(curec) would otherwise silently pick one value.

Expressions

SELECT CASE
  WHEN MIN(curec) <> MAX(curec) THEN MAX(curec)
END

Column medicare._enrollments.curec_latest Lineage SVG — Data lineage for column medicare._enrollments.curec_latest