|
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 |
Incoming Enrollment Filer |
Patient Verified Demographic Change |
Verified Photo ID |
Fix Needed from Incorrect Patient Merge |
|
|
8 |
ID_CHG_OLD_NAME |
VARCHAR |
No |
|
|
|
|
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 |
|
|
|
|
16 |
ID_CHANGE_LOC_ID_LOC_NAME |
VARCHAR |
No |
|
|
|
The name of the revenue location. |
|
|