|
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 of the associated street address change in this patient record. Together with PAT_ID, this forms the foreign key to the STREET_ADDRESS_CHANGE_HX table. |
|
|
3 |
VALUE_LINE |
INTEGER |
No |
|
|
|
The line number of one of the multiple street address lines that are associated with the patient and the address change from the STREET_ADDRESS_CHANGE_HX table. |
|
|
4 |
STREET_ADDRESS |
VARCHAR |
No |
|
|
|
Audit trail item used to store the previous street address when a new street address is entered or if the current primary address is edited. |
|
|