location.Rmd| Destination Field | Source field | Logic | Comment field |
|---|---|---|---|
| location_id | Autogenerated | ||
| address_1 | cast(null as varchar) | ||
| address_2 | cast(null as varchar) | ||
| city | city | ||
| state | state | Map state to “states_map” table to crosswalk the full state text to the abbreviation | |
| county | cast(null as varchar) | ||
| zip | zip | ||
| location_source_value | zip |