PAT_IDENTITYCHANGE

Description: |
This table contains information regarding the identity (demographic) changes that are made to the patient. The identity changes include changes to a patient's name, sex, Social Security number and/or date of birth. Whenever a user tries to change the above identity information in the graphical user interface (GUI) this table logs the action.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE | 2 |

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 | LINE | INTEGER | No |
The line number for the information associated with this row. Multiple pieces of information can be associated with this row.
3 | ID_CHANGE_INSTANT | DATETIME (Local) | No |
The instant when someone edited this patient's identity.
4 | ID_CHANGE_USER_ID | VARCHAR | No |
User that changed patient demographics and triggered a potential overlay.
5 | ID_CHANGE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | ID_CHANGE_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
7 | ID_CHANGE_REASON_C_NAME | VARCHAR | No |
Reason selected by user to indicate why the patient's identity is changed.
May contain organization-specific values: Yes
Category Entries:
Demographic Linking
Incoming Interface Demographic Change
Incoming Enrollment Filer
Patient Verified Demographic Change
Verified Photo ID
Fix Needed from Incorrect Patient Merge
8 | ID_CHG_OLD_NAME | VARCHAR | No |
Name before the change.
9 | ID_CHG_OLD_SSN | VARCHAR | No |
Social security number before change.
10 | ID_CHANGE_OLD_SEX_C_NAME | VARCHAR | No |
The category ID of the patient's sex before the change.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
11 | ID_CHG_OLD_DOB_DT | DATETIME | No |
Birth date before change.
12 | ID_CHANGE_NEW_NAME | VARCHAR | No |
The patient's name after the change.
13 | ID_CHANGE_NEW_SSN | VARCHAR | No |
Social security number after change.
14 | ID_CHANGE_NEW_SEX_C_NAME | VARCHAR | No |
The category ID of the patient's sex after the change.
The category values for this column were already listed for column: ID_CHANGE_OLD_SEX_C_NAME
15 | ID_CHG_NEW_DOB_DT | DATETIME | No |
Birth date after change.
16 | ID_CHANGE_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.