PAT_ADDL_TEMP_ADDR_DETAIL

Description:

The PAT_ADDL_TEMP_ADDR_DETAIL table contains patient temporary address geo location data like latitude and longitude.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	TEMP_ADDR_GEO_KEY_C_NAME	VARCHAR	No
	The geolocation identifier for the row's value stored in TEMP_ADDR_GEO_VAL. TEMP_ADDR_GEO_KEY_C identifies the type of data stored in the value; for instance: latitude and longitude. May contain organization-specific values: No Category Entries: Latitude Longitude Geocoding - Accuracy Rating State FIPS Code County FIPS Code 2020 Census Tract FIPS Code 2020 Census Block Group FIPS Code 2010 Census Tract FIPS Code 2010 Census Block Group FIPS Code Exempt From Geocoding
4	TEMP_ADDR_GEO_VAL	VARCHAR	No
	The geolocation value for the row. The type of geolocation value is determined by the TEMP_ADDR_GEO_KEY_C column. Latitude and Longitude are limited to 6 decimals of accuracy.