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