COMPLETEDDOCDFCY - Database Reporting Guide - English - Foundation 22.1 - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The COMPLETEDDOCDFCY table stores a historical reference of completed document-level deficiencies after the chart has fully completed Reanalysis. Entries in this table are migrated from the DOCDEFICIENCY table upon processing after Reanalysis is fully complete. The COMPLETEDDOCDFCY table is located in DBSpace1.

COMPLETEDDOCDFCY 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.)
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.

itemtypenum bigint The internal unique identifier of the deficient document’s document type; a foreign key to the DOCTYPE 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 who 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.

physdecisiondate 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.

resassignednum 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.

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.

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 COMPLETEDDOCDFCY table are located in DBSpace1.

COMPLETEDDOCDFCY Table Indexes
Index Name Included Columns
completeddocdfcy2 physassignednum
completeddocdfcy3 chtnum, dfcytype
completeddocdfcy4 itemnum, dfcytype