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.