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