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

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

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.

COMPLETEDCHTDFCY Table Values
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.

COMPLETEDCHTDFCY Table Indexes
Index Name Included Columns
completedchtdfcy1 chtnum
completedchtdfcy2 physassignednum