STREET_ADDRESS_CHANGE_VAL

Description: |
This table contains a list of street address lines used to store the street address changes for a patient.

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 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.