ENC_DX_EDIT_TRAIL

Description: |
This table stores the audit trail information for encounter diagnosis edits. In order to report on diagnosis edits, this table can be linked with PAT_ENC_DX. This linking can be done using the PAT_ENC_CSN_ID and DX_EDIT_UNIQUE columns in this table along with the PAT_ENC_CSN_ID and DX_UNIQUE columns in the PAT_ENC_DX table.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the unique contact identifier (UCI).
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | DX_EDIT_CHRONIC_YN | VARCHAR | No |
Indicates whether or not the edited diagnosis is chronic. Y indicates that the edited diagnosis is chronic. N indicates that the edited diagnosis is not chronic.
May contain organization-specific values: No
Category Entries:
No
Yes
4 | DX_EDIT_PRIMDX_YN | VARCHAR | No |
Indicates whether or not the edited diagnosis is primary. Y indicates that the edited diagnosis is primary. N indicates that the edited diagnosis is not primary.
The category values for this column were already listed for column: DX_EDIT_CHRONIC_YN
5 | DX_EDIT_STATUS_C_NAME | VARCHAR | No |
Stores category numbers for past values of the Differential diagnosis status.
May contain organization-specific values: No
Category Entries:
Final
In Progress
Ruled Out
Inconclusive
6 | DX_EDIT_ED_YN | VARCHAR | No |
This column stores audit trail information for encounter diagnosis edits, particularly the ED Diagnosis flag of the associated edit.
The category values for this column were already listed for column: DX_EDIT_CHRONIC_YN