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.
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.
Index Name | Included Columns |
---|---|
completeddocdfcy2 | physassignednum |
completeddocdfcy3 | chtnum, dfcytype |
completeddocdfcy4 | itemnum, dfcytype |