The COMPLETEDCHTDFCY table stores a historical reference of completed chart-level deficiencies after the chart has fully completed Reanalysis. Entries in this table are migrated from the CHARTDEFICIENCY table upon processing after Reanalysis is fully complete. The COMPLETEDCHTDFCY table is located in DBSpace1.
Column Name | Data Type | Description |
---|---|---|
dfcynum | bigint |
The internal unique identifier for the deficiency. |
dfcytype | bigint |
The deficiency categorization for chart-level deficiencies. (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 a chart object; a foreign key to the CHART table. |
analystnum | bigint |
The internal unique identifier of the user account (typically an Analyst) that created the deficiency; a foreign key to the USERACCOUNT table. |
dateadded | datetime |
The date and time the deficiency was added to the chart. |
physassignednum | bigint |
The internal unique identifier of the physician who was assigned the deficiency; a foreign key to the USERACCOUNT and PHYSICIANINFO tables. |
physcompletednum | bigint |
The internal unique identifier of the physician who completed the deficiency; a foreign key to the USERACCOUNT and PHYSICIANINFO tables. |
completeddate | datetime |
The date and time the deficiency was decided on by the physician referenced in the physcompletednum column. |
reanalystnum | bigint |
The internal unique identifier of the user account that verified this deficiency in Reanalysis; a foreign key to the USERACCOUNT table. |
datereanalyzed | datetime |
The date and time the deficiency was verified in Reanalysis. |
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. |
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. |
flags | bigint |
Additional information related to the chart-level deficiency. A bitflag value 0x0000 = None, 0x0001 = Analysis Server Generated. |
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. |
itemtypenum | bigint | Document type number of the missing document; a foreign key to the DOCTYPE table. |
The indexes for the COMPLETEDCHTDFCY table are located in DBSpace1.
Index Name | Included Columns |
---|---|
completedchtdfcy1 | chtnum |
completedchtdfcy2 | physassignednum |