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_LOC_NAME
VARCHAR
No
The name of the revenue location.
4
LOCATION_DATE
DATETIME
No
The most recent date associated with the patient location