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.
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.
Index name | Included Columns |
---|---|
chtcorrection1 | chtcorrectionnum |
chtcorrection2 | chtnum |
chtcorrection3 | status |