Several tables within the Medical Records schema use enumeration values to indicate a status, activity type, or other setting. The tables below document these enumeration values.
CHART
The CHART table contains a chtstatus column which indicates the status of the chart’s progression through the Chart Completion process. The table below lists all possible chtstatus values for the CHART table.
Chart Status | chtstatus Value |
---|---|
Has not yet begun processing |
0 |
Waiting for Chart E-Form Creation | 1 |
Needs Review (Charts Requiring Review) |
5 |
In Coding (Chart requires both Analysis and Coding but has only progressed to Coding) |
10 |
In Analysis (Chart requires both Analysis and Coding but has only progressed to Analysis) |
20 |
Open (Chart has progressed to all appropriate contexts) |
30 |
Inactive (Chart has met requirements to be marked Inactive) | 40 |
Stalled Unknown (Chart went inactive prior to entering Coding or Analysis) |
50 |
Stalled Coding (Chart went inactive prior to entering Analysis) |
60 |
Stalled Analysis (Chart went inactive prior to entering Coding) |
70 |
Admin Override Coding |
80 |
Admin Override Analysis | 90 |
Closed (Chart has met requirements for Closure) |
100 |
The CHART table contains a needsreviewcode column which indicates one or multiple reasons why a chart is in the Charts Requiring Review queue. Although it does store multiple values, the value in this column is not a true bitflag. Translation of the value can be accomplished by the following:
Example 1: needsreviewcode = 12 indicates the chart has a new admit type.
Example 2: needsreviewcode = 854794 indicates that the chart has no attending physician, no admit type and no facility.
Review Codes | Value |
---|---|
Name | 0 |
No MRN | 1 |
No ChartID | 2 |
Different SSN (Chart SSN must match MedRec SSN) | 3 |
Missing SSN | 4 |
No MPI | 5 |
Duplicate ChartID | 6 |
Bad Admit Date | 7 |
Bad Discharge Date | 8 |
Bad Birth Date | 9 |
No Attending Physician | 10 |
No Admit Type | 11 |
New (unconfigured) Admit Type | 12 |
No Facility | 13 |
New (unconfigured) Facility | 14 |
The CHART table contains a decisioning column, which indicates the chart’s progression through Coding and/or Analysis based on the Admit Type configuration at the time the chart was created. The value of the decisioning column is a bitflag that can contain multiple values. Proper bitwise syntax should be used when querying this column. The following table lists the possible values for decisioning:
Decisioning | Value |
---|---|
Not Yet Determined |
0 |
No Routing (Neither Coding nor Analysis required) | 1 |
Coding After Discharge | 2 |
Analysis After Discharge | 4 |
Coding On Admission |
8 |
Analysis On Admission |
16 |
The CHART table contains a mrcontrolsys column, which indicates the application responsible for processing of the chart. The following table lists the possible values for the mrcontrolsys column.
Controling System | Value |
---|---|
No processing |
0 |
Medical Records Management Solution |
205 |
Signature Deficiencies for Epic | 303 |
ADMITTYPE
The ADMITTYPE table contains a flags column, which stores information about the Admit Type’s configuration for Coding and/or Analysis. The value of the flags column is a bitflag that can contain multiple values. Proper bitwise syntax should be used when querying this column. The following table lists the possible values for flags:
Admit Type Flags (ADMITTYPE table) | Value |
---|---|
Requires Coding after Discharge |
1 |
Requires Analysis after Discharge |
2 |
Requires Coding after Admit |
4 |
Requires Analysis after Admit |
8 |
Unconfigured (HL7 automatically created the Admit Type) |
4096 |
CHARTANALYSIS
The CHARTANALYSIS table contains a chtstatus column that is used to determine the current status of a chart’s progression through the individual queues of the Medical Records Management process. Multiple rows can exist for a given chart, each with a different and potentially unrelated chtstatus. The following table lists the possible values for the chtstatus column in the CHARTANALYSIS table:
Chart Status | Value |
---|---|
In Coding |
2 |
Post Coding |
6 |
Coding Complete |
8 |
In Analysis |
12 |
Post Analysis |
16 |
Analysis Complete |
18 |
In Completion (Prior to Analysis Complete) |
-22 |
In Completion (After Analysis Complete) |
22 |
Post Completion (Prior to Analysis Complete) |
-24 |
Post Completion (After Analysis Complete) |
24 |
In Reanalysis |
32 |
Reanalysis In Progress |
33 |
Post Reanalysis |
34 |
Preanalysis Complete |
-40 |
Reanalysis Complete |
40 |
Closed |
50 |
QA Coding |
102 |
Post QA Coding |
106 |
QA Coding Completed |
108 |
QA Analysis |
112 |
Post QA Analysis |
116 |
QA Analysis Completed |
118 |
QA Reanalysis |
132 |
Post QA Reanalysis |
134 |
QA Reanalysis Completed |
138 |
DOCDEFICIENCY / CHARTDEFICIENCY
The DOCDEFICIENCY and CHARTDEFICIENCY tables contain a dfcytype column, which indicates the specific type of deficiency. The following table indicates possible values for this column along with the deficiency level (document or chart) indicating which table would contain the value.
Deficiency Type |
Level | Value |
---|---|---|
Missing Signature |
Document | 1 |
Missing Other |
Document | 3 |
Missing Document |
Chart | 4 |
Missing Diagnosis |
Document | 5 |
Missing Dictation |
Chart | 6 |
Incomplete Form / Physician Query |
Document | 7 |
Missing Information |
Document | 8 |
Editable Transcription |
Document | 9 |
Missing Dual Signature |
Document | 10 |
Missing Dual Dictation |
Chart | 12 |
External Missing Signature |
Chart | 13 |
External Unsigned Order |
Chart | 14 |
External Missing Information |
Chart | 15 |
DFCYTXLOG
The DFCYTXLOG table stores a transaction log of activity that occurred on the specified chart. This table contains an action column, which indicates the specific activity being logged as well as extrainfo1, extrainfo2, and extrainfo3 columns, which provide additional detail into the logged activity. The following table lists possible values for the action column along with a definition of the corresponding extrainfo values, if applicable.
Activity | Action | Extrainfo1 | Extrainfo2 | Extrainfo3 |
---|---|---|---|---|
Chart Created |
1 | |||
Chart Entered Coding |
2 | |||
Chart Suspended In Coding |
4 | |||
Chart Unsuspended In Coding |
5 | |||
Chart Coding Completed |
8 | |||
Chart Entered Analysis |
12 | |||
Chart Suspended |
14 | |||
Chart Unsuspended |
15 | |||
Chart Analysis Completed |
18 | |||
Chart Entered Completion |
22 | physnum | ||
Chart Completion Completed |
28 | physnum | ||
Chart Entered Reanalysis |
32 | physnum | ||
Chart Reanalysis Completed |
38 | physnum | ||
Chart Waiting For Closure |
40 | |||
Chart Completed |
50 | |||
Chart Viewed |
60 | |||
Chart Printed |
70 | |||
Chart Reviewed For HL7 |
80 | |||
Chart Modified |
90 | |||
Merge MPI |
91 | |||
Merge MRN |
92 | |||
Merge Chart ID |
93 | oldchtnum | ||
Closed Chart Modified |
94 | |||
Admit Type Changed |
95 | old admittypenum | new admittypenum | |
Document Added To Chart |
100 | |||
Document Removed From Chart |
101 | |||
Chart Deleted |
102 | |||
Chart Delete Failed |
103 | |||
Chart Deleted Manually |
104 | |||
External Mail Sent |
105 | usernum | recipient usernum | |
Internal Mail Sent |
106 | usernum | recipient usernum | |
Admin Unassigned Analyst |
110 | |||
Admin Reassigned Analyst |
111 | |||
Admin Unassigned Reanalyst |
112 | |||
Admin Reassigned Reanalyst |
113 | |||
Admin Unassigned Coder |
114 | |||
Admin Reassigned Coder |
115 | |||
Admin Reassigned Physician |
116 | |||
Chart Tab Printed |
117 |
uitabnum |
||
Chart Template Printed |
118 |
chtprinttmplnum |
||
Physician Query Created |
119 |
physician usernum |
||
Physician Query Edited |
120 |
old physician usernum |
new physician usernum | |
Physician Query Deleted |
121 |
physician usernum |
||
Physician Query Sent |
122 |
physician usernum |
||
Deficiency Created |
123 | physician usernum | secondary signer usernum | |
Deficiency Modified |
124 | |||
Deficiency Deleted |
125 | physician usernum | secondary signer usernum | |
Deficiency Accepted |
126 | |||
Deficiency Rejected |
127 | |||
Deficiency Resubmitted |
128 | |||
Reassigned Primary Signer |
129 | old usernum | new usernum | |
Reassigned Secondary Signer |
130 | old usernum | new usernum | |
Confirmed Deficiency |
131 | |||
Closed Chart Opened |
132 | |||
Analyst Review Note Completed |
133 | codingnotenum | ||
Analyst Review Note Created |
134 | |||
Deficiency Created |
135 | physician usernum | ||
Deficiency Deleted |
136 | physician usernum | ||
Analyst Review Note Assigned |
137 | codingnotenum | ||
Analyst Review Note Unassigned |
138 | codingnotenum | ||
Analyst Review Notes Viewed |
139 | |||
Auto Confirmed Deficiency |
140 | |||
Deficiency Merged |
141 | physician usernum | secondary signer usernum | dfcytype |
Dual Deficiency Merged |
142 | physician usernum | secondary signer usernum | dfcytype |
Document Merged |
143 | old chtnum | ||
Deficiency Marked Stat |
144 | |||
Deficiency Stat Cleared |
145 |