Column medicare.qc_admissions.year Lineage SVG

medicare.qc_admissions.year medicare.qc_admissions.year medicare.qc_adm_union.year medicare.qc_adm_union.year (CASE WHEN "year"::int < 20 THEN (2000 + "year"::int) WHEN (20 < "year"::int AND "year"::int < 100) THEN (1900 + "year"::int) WHEN "year" IS NULL THEN 2000 ELSE "year"::int END) medicare.qc_adm_union.year->medicare.qc_admissions.year  Transformed medicare.admissions.year medicare.admissions.year (CASE WHEN "year"::int < 20 THEN (2000 + "year"::int) WHEN (20 < "year"::int AND "year"::int < 100) THEN (1900 + "year"::int) WHEN "year" IS NULL THEN 2000 ELSE "year"::int END) medicare.admissions.year->medicare.qc_adm_union.year  Transformed medicare.ip.year medicare.ip.year (CASE WHEN "year"::int < 20 THEN (2000 + "year"::int) WHEN (20 < "year"::int AND "year"::int < 100) THEN (1900 + "year"::int) WHEN "year" IS NULL THEN 2000 ELSE "year"::int END) medicare.ip.year->medicare.admissions.year  Transformed medicare.ip.year_parent 8 incoming links (columns) medicare.ip.year_parent->medicare.ip.year medicare.enrollments.year medicare.enrollments.year medicare.enrollments.year->medicare.admissions.year parent-child medicare._enrollments.year medicare._enrollments.year medicare._enrollments.year->medicare.enrollments.year Copied medicare._ps.year medicare._ps.year (CASE WHEN "year"::int < 20 THEN (2000 + "year"::int) WHEN (20 < "year"::int AND "year"::int < 100) THEN (1900 + "year"::int) WHEN "year" IS NULL THEN 2000 ELSE "year"::int END) medicare._ps.year->medicare._enrollments.year  Aggregated On bene_id, year, state medicare.ps.year medicare.ps.year (CASE WHEN "year"::int < 20 THEN (2000 + "year"::int) WHEN (20 < "year"::int AND "year"::int < 100) THEN (1900 + "year"::int) WHEN "year" IS NULL THEN 2000 ELSE "year"::int END) medicare.ps.year->medicare._ps.year Copied medicare.ps.year_parent 8 incoming links (columns) medicare.ps.year_parent->medicare.ps.year