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

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The CHARTCODEHIST table stores rows related to a chart’s completed processing in one or multiple queues related to Coding, whether MRMS- or Workflow-based. One-to-many rows may exist for a given chart as each step of coding processing completes. Additionally, active rows may be found in the CHARTCODEFLOW table. The CHARTCODEHIST table is located in DBSpace10.

CHARTCODEFLOW Table Values
Column Name Data Type Description
chtnum bigint The internal unique identifier of a chart object; a foreign key to the CHART table.
codingflownum bigint

The coding flow (life cycle) number of the coding flow (life cycle) associated with the row. 100 = System Life Cycle, 101+ = User Created Life Cycle and foreign key to the CODINGFLOW table.

codingqueuenum bigint

The coding queue number of the coding queue associated with the row. 100 = System Queue, 101+ = User Created Queue and foreign key to the CODINGQUEUE table.

transituser bigint

The internal unique identifier of the user who transitioned the chart out of the life cycle and queue associated with this historical row; a foreign key to the USERACCOUNT table.

usernum bigint

The internal unique identifier of the user who was assigned to the chart in the life cycle and queue associated with this historical row; a foreign key to the USERACCOUNT table.

entrydate datetime The date and time the chart associated with the row entered the life cycle and queue associated with this historical row.
finishdate datetime The date and time the chart associated with the row exited the life cycle and queue associated with this historical row.
lcnum bigint The Workflow life cycle number associated with the row, when Workflow-wrapped MRMS is in use; a foreign key to the LIFECYCLE table.
statenum bigint The Workflow queue number associated with the row, when Workflow-wrapped MRMS is in use; a foreign key to the LCSTATE table.

The indexes for the CHARTCODEHIST table are located in DBSpace10.

CHARTCODEHIST Table Indexes
Index Name Included Columns
chartcodehist1 chtnum
chartcodehist2 codingflownum, codingqueuenum
chartcodehist3 usernum