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

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The CODINGFLOWXQUEUE table is a cross-reference table that associates a Coding Life Cycle (CODINGFLOW) with a Coding Queue (CODINGQUEUE). The CODINGFLOWXQUEUE table is located in DBSpace8.

CODINGFLOWXQUEUE Table Values
Column Name Data Type Description
codingflownum bigint

The internal unique identifier of the Coding Life Cycle; a foreign key to the CODINGFLOW table.

codingqueuenum bigint The internal unique identifier of the Coding Queue; a foreign key to the CODINGQUEUE table.
seqnum bigint The sequence or order number for the associated queue within the associated life cycle; 0 = initial queue, 1 = the next queue in a structured life cycle, 2-N = the subsequent queue(s) in a structured life cycle.
transittype bigint

Used to indicate whether the queue is the last queue in the sequence for a structured life cycle; 0 = Not last in sequence, 1 = Last in sequence.

The indexes for the CODINGFLOWXQUEUE table are located in DBSpace8.

CODINGFLOWXQUEUE Table Indexes
Index Name Included Columns
codingflowxqueue1 codingqueuenum
codingflowxqueue2 codingflownum