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.
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.
Index Name | Included Columns |
---|---|
chartcodehist1 | chtnum |
chartcodehist2 | codingflownum, codingqueuenum |
chartcodehist3 | usernum |