LOCATION

LOCATION Table Schema

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