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