LOCATION - AmericanManufacturingCohort/HR-CDM-Data-Transformation GitHub Wiki
The table below presents the data mappings for the LOCATION table where the source variables refer to the column names in the base data set.
| LOCATION Variable | Source Variable | Note |
|---|---|---|
| location_id | N/A | (Auto-generated by a computer program) |
| address_1 | -- | |
| address_2 | -- | |
| city | locatdes | Extract the city name |
| state | locatdes | Extract the state name |
| zip | -- | |
| county | -- | |
| location_source_value | locatdes |