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 |