ADDR_HX_DESC
Description:
This table extracts descriptions of each patient's historical addresses.
Primary Key
Column Name
Ordinal Position
PAT_ID
1
GROUP_LINE
2
VALUE_LINE
3
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
GROUP_LINE
INTEGER
No
The line number for the information associated with this record.
3
VALUE_LINE
INTEGER
No
The line number of one of the multiple values associated with a specific group of data within this record.
4
ADDR_HX_DESC
VARCHAR
No
This item stores the description of a patient's historical address.