Column medicare.qc_admissions.zip Lineage SVG

medicare.qc_admissions.zip medicare.qc_admissions.zip medicare.qc_adm_union.zip medicare.qc_adm_union.zip numeric → (CASE WHEN {column_name} < 100000 THEN {column_name}::int ELSE ({column_name}/10000)::INT END) character varying → SUBSTRING({column_name} FROM 1 FOR 5)::INT medicare.qc_adm_union.zip->medicare.qc_admissions.zip  Transformed medicare.admissions.zip medicare.admissions.zip numeric → (CASE WHEN {column_name} < 100000 THEN {column_name}::int ELSE ({column_name}/10000)::INT END) character varying → SUBSTRING({column_name} FROM 1 FOR 5)::INT medicare.admissions.zip->medicare.qc_adm_union.zip Copied medicare.ip.zip medicare.ip.zip numeric → (CASE WHEN {column_name} < 100000 THEN {column_name}::int ELSE ({column_name}/10000)::INT END) character varying → SUBSTRING({column_name} FROM 1 FOR 5)::INT medicare.ip.zip->medicare.admissions.zip Copied medicare.ip.zip_parent 8 incoming links (columns) medicare.ip.zip_parent->medicare.ip.zip medicare.enrollments.zip medicare.enrollments.zip MAX(zip) medicare.enrollments.zip->medicare.admissions.zip Copied medicare._enrollments.zip medicare._enrollments.zip MAX(zip) medicare._enrollments.zip->medicare.enrollments.zip Copied medicare._ps.zip medicare._ps.zip US Postal ZIP code, the first 5 digits of it numeric → (CASE WHEN {column_name} < 100000 THEN {column_name}::int ELSE ({column_name}/10000)::INT END) character varying → SUBSTRING({column_name} FROM 1 FOR 5)::INT integer → {column_name}::INT medicare._ps.zip->medicare._enrollments.zip  Aggregated On bene_id, year, state medicare.ps.zip medicare.ps.zip US Postal ZIP code, the first 5 digits of it numeric → (CASE WHEN {column_name} < 100000 THEN {column_name}::int ELSE ({column_name}/10000)::INT END) character varying → SUBSTRING({column_name} FROM 1 FOR 5)::INT integer → {column_name}::INT medicare.ps.zip->medicare._ps.zip Copied medicare.ps.zip_parent 8 incoming links (columns) medicare.ps.zip_parent->medicare.ps.zip