Medical Records Enumeration Values - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 23.1
License

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 Table Values
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.

CHART Table Review Codes
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 Values (CHART Table)
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 Values (CHART Table)
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 Values
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 (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 Values (DOCDEFICIENCY/CHARTDEFICENCY Table)

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 (DFCYTXLOG Table) Values
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