CHARTXITEMDATA - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 23.1
License

The CHARTXITEMDATA table is a cross reference table that links documents to charts. The CHARTXITEMDATA table is located in DBSpace1.

CHARTXITEMDATA Table Values
Column Name Data Type Description
chtnum bigint

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

itemnum bigint

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

analysisstatus bigint Indicates the document’s status within the Analysis context; 0 = undefined, 1 = normal, 2 = loose document.
currentpage bigint

Not implemented.

itemtypenum bigint The document type of the referenced document; a foreign key to the DOCTYPE table.
hl7externaldocid char(63)

Stores the external report ID for the document.

segnum bigint

Determines how documents are ordered within a tab or document list. This value is set by users manually sorting the document list.

relateditemnum bigint Reference to a related document; a foreign key to the ITEMDATA table.
relatedpagenum bigint Reference to a specific page of a related document (relateditemnum); a foreign key to the ITEMDATAPAGE table.

The indexes for the CHARTXITEMDATA table are located in DBSpace1.

CHARTXITEMDATA Table Indexes
Index Name Included Columns
chartxitemdata1

analysisstatus, chtnum

chartxitemdata2

itemtypenum

chartxitemdata3

chtnum, itemtypenum

chartxitemdata4

itemnum

chartxitemdata5

relateditemnum