PAT_SEEN_IN_LOCATIONS
Description:
A list of locations where the patient has been seen.

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 PAT_LOC_ID NUMERIC No
A list of all the locations that a patient has been seen, or is scheduled to be seen
4 LOCATION_DATE DATETIME No
The most recent date associated with the patient location