Column medicare._enrollments.zip Lineage SVG

medicare._enrollments.zip medicare._enrollments.zip MAX(zip) 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