This is an old revision of the document!
The LOCATION table represents a generic way to capture physical location or address informationof Persons and Care Sites.
|location_id||Yes||integer||A unique identifier for each geographic location.|
|address_1||No||varchar(50)||The address field 1, typically used for the street address, as it appears in the source data.|
|address_2||No||varchar(50)||The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data.|
|city||No||varchar(50)||The city field as it appears in the source data.|
|state||No||varchar(2)||The state field as it appears in the source data.|
|zip||No||varchar(9)||The zip or postal code.|
|location_source_value||No||varchar(50)||The verbatim information that is used to uniquely identify the location as it appears in the source data.|