DOCDEFICIENCY - 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

The DOCDEFICIENCY table stores a row for each unique document-level deficiency associated with a chart. Document-level deficiencies include Missing Signatures, Missing Information, Editable Transcriptions, and other deficiency types. Once a chart finishes Reanalysis, document-level deficiencies are burned into the documents and then migrated from the DOCDEFICIENCY table to the COMPLETEDDOCDFCY table. The DOCDEFICIENCY table is located in DBSpace1.

DOCDEFICIENCY Table Values
Column Name Data Type Description
dfcynum bigint

The internal unique identifier of the deficiency.

dfcytype bigint The deficiency type. (See Appendix for enumeration values.)
dfcystatus bigint

The status of the deficiency within the Completion process. 1 = Pending, 2 = Completed, 3 = Verified by Reanalyst, 4 = Burn to Document, 5 = Rejected, 6 = Completed by Secondary, pending Primary.

dfcymessage text Field for the Analyst/Reanalyst to communicate with the physician regarding the deficiency.
chtnum bigint

The internal unique identifier of the chart; a foreign key to the CHART table.

itemnum bigint

The internal unique identifier of the document on which the deficiency has been created; a foreign key to the ITEMDATA table.

pagenum bigint The document page number where the deficiency was placed.
notenum bigint The internal unique identifier of the OnBase note that represents the document level deficiency; a foreign key to the NOTETABLE table.
analystnum bigint

The internal unique identifier of the user that created/placed the deficiency; a foreign key to the USERACCOUNT table.

dateadded datetime The date and time that the deficiency was created.
physassignednum bigint The internal unique identifier of the physician who was assigned the deficiency; a foreign key to the PHYSICIANINFO and USERACCOUNT tables.
physcompletednum bigint

The internal unique identifier of the physician who completed the deficiency; a foreign key to the PHYSICIANINFO and USERACCOUNT tables.

physdecisiontape datetime

The date and time that the deficiency was completed by the associated physcompletednum user.

reanalystnum bigint The internal unique identifier of the user who was assigned the deficiency in Reanalysis; a foreign key to the USERACCOUNT table.
datereanalyzed datetime The date and time that the deficiency was reviewed in Reanalysis.
rejectreason char(250)

The reason that the deficiency was rejected by a physician.

flags bigint

Stores status values related to the document level deficiency; 0x0000001 = HL7 message sent for Editable Transcriptions; 0x00000002 = Deficiency will not be burned into document; 0x00000004 = Deficiency is a Physician Query.

dirtykey bigint Used by the Epic Analysis server to update deficiencies that have been modified.
reassignednum bigint

The internal unique identifier of the assigned secondary signer in a dual-signature implementation; a foreign key to the USERACCOUNT and PHYSICIANINFO tables.

rescompletednum bigint

The internal unique identifier of the secondary signer who completed the deficiency in a dual-signature implementation; a foreign key to the USERACCOUNT and PHYSICIANINFO tables.

resdecisiondate datetime The date and time that the deficiency was decided on by the secondary signer referenced in the rescompletednum column.
delinqlevel bigint Highest delinquency level reached for the specified deficiency as calculated by the MRMS Delinquency process and Aging & Levels configuration; a foreign key to the DELINQUENCYLEVEL table.
hoursstillsuspen bigint

Number of hours before (+) or after (-) suspension.

reviewstatus bigint

Status to mark a deficiency as reviewed or not reviewed.

reviewusernum bigint

The internal unique identifier of the last user to mark the deficiency as reviewed; a foreign key to the USERACCOUNT table.

reviewdate datetime

The date and time when the deficiency was last reviewed.

The indexes for the DOCDEFICIENCY table are located in DBSpace1.

DOCDEFICIENCY Table Indexes
Index Name Included Columns
docdeficiency1 dfcynum
docdeficiency3 itemnum, physassignednum
docdeficiency4 notenum
docdeficiency5 chtnum, dfcystatus, physassignednum, dfcytype
docdeficiency6 itemnum, resassignednum
docdeficiency7 chtnum, dfcystatus, resassignednum, dfcytype
docdeficiency8 dfcystatus
docdeficiency9 physassignednum, dfcytype
docdeficiency10 itemnum, dfcystatus, dfcytype