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

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The CHTCORRECTION table contains corrections required for the associated chart. Corrections generally include adding a new document or rescanning a page. The CHTCORRECTION table is located in DBSpace1.

CHTCORRECTION Table Values
Column Name Data Type Description
chtcorrectionnum bigint

The internal unique identifier of the chart correction row.

chtnum bigint The internal unique identifier of a chart object; a foreign key to the CHART table.
itemnum bigint

The internal unique identifier of the document requiring correction; a foreign key to the ITEMDATA table.

itemtypenum bigint The document type number of the document requiring correction or of the missing document; a foreign key to the DOCTYPE table.
datecreated datetime

The date and time that the correction request row was created.

usercreated

bigint

The internal unique identifier of the user who created the chart correction request; a foreign key to the USERACCOUNT table.

datecompleted datetime

The date and time that the chart correction request was closed or completed; (1964-01-01 00:00:00 if not yet closed or completed).

userassigned

bigint

The internal unique identifier of the user that is assigned to the chart correction request; a foreign key to the USERACCOUNT table.

status

bigint

The current status of the chart correction request; 1 = open, 2 = completed, 3 = rejected.

requesttype bigint The type of chart correction request; 1 = add document, 2 = add page, 3 = scan page, 4 = transcription, 5 = add deficiency.

flags

bigint Not currently implemented.

primaryphysnum

bigint

The internal unique identifier for the primary physician/signer associated with the correction task; a

foreign key to the USERACCOUNT and PHYSICIANINFO tables.

secondaryphysnum bigint The internal unique identifier for the secondary signer associated with the correction task, if configured for dual signing; a foreign key to the USERACCOUNT and PHYSICIANINFO tables.

The indexes for the CHTCORRECTION table are located in DBSpace1.

CHTCORRECTION Table Indexes
Index name Included Columns
chtcorrection1 chtcorrectionnum
chtcorrection2 chtnum
chtcorrection3 status