PAT_ADDR_CHNG_HX
Description:
This table keeps track of changes in the patient's address.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
Patient ID for whom address is changed.
2 LINE INTEGER No
Line count in the address change history.
3 ADDR_HX_LINE1 VARCHAR No
First line of patient's home address, current between dates recorded in columns EFF_START_DATE and EFF_END_DATE.
4 ADDR_HX_LINE2 VARCHAR No
Second line of patient's home address, current between dates recorded in columns EFF_START_DATE and EFF_END_DATE.
5 ADDR_HX_LN_EXTRA VARCHAR No
Additional line of patient's home address, current between dates recorded in columns EFF_START_DATE and EFF_END_DATE.
6 CITY_HX VARCHAR No
Patient's home city, current between dates recorded in columns EFF_START_DATE and EFF_END_DATE.
7 COUNTY_HX_C_NAME VARCHAR No
Patient's home county, current between dates recorded in columns EFF_START_DATE and EFF_END_DATE.
May contain organization-specific values: Yes
8 ZIP_HX VARCHAR No
Patient's home ZIP, current between dates recorded in columns EFF_START_DATE and EFF_END_DATE.
9 ADDR_CHNG_SOURCE_C_NAME VARCHAR No
Source of address changes.
May contain organization-specific values: Yes
Category Entries:
Bridges
EpicCare
Cadence
Professional Billing
ManageCare
Chronicles
CRM
Nurse Triage
EpicWeb
EpicCare Link
Welcome
10 EFF_START_DATE DATETIME No
Effective start date of changed address (date when address was changed).
11 EFF_END_DATE DATETIME No
Effective end date of changed address (date of the next address change or NULL if this is the last address change).
12 PREV_HOUSE_NUM VARCHAR No
Audit trail item used to store the previous house number when a new house number is entered or if the current primary address is edited.
13 PREV_DISTRICT_C_NAME VARCHAR No
Audit trail item used to store the previous district when a new district is entered or if the current primary address is edited.
May contain organization-specific values: Yes
14 SIGNIFICANT_CHANGE_YN VARCHAR No
Audit trail item used to store whether the address change should be considered significant when a new address is entered or if the current primary address is edited.
May contain organization-specific values: No
Category Entries:
No
Yes
15 ADDR_HX_VALID_YN VARCHAR No
This columns specifies if the historical address stored on the patient record is invalid or incorrect. A blank value means historical address is a valid older address. Use this item to indicate a patient's address was captured due to error, for example, in the case of a patient overlay.
The category values for this column were already listed for column: SIGNIFICANT_CHANGE_YN
16 PREV_FLOOR VARCHAR No
Audit trail item used to store the previous floor number when a new floor number is entered or if the current primary address is edited.
17 PREV_UNIT VARCHAR No
Audit trail item used to store the previous unit number when a new unit number is entered or if the current primary address is edited.
18 PREV_BLDG_NAM VARCHAR No
Audit trail item used to store the previous building name when a new building is entered or if the current primary address is edited.
19 COUNTRY_C_NAME VARCHAR No
Audit trail item used to store the previous country when a new country is entered or if the current primary address is edited.
May contain organization-specific values: Yes