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

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The CHARTLESSDOCS table contains entries for documents that OnBase was unable to associate with a specific chart on archive. The CHARTLESSDOCS table is located in DBSpace1.

CHARTLESSDOCS Table Values
Column Name Data Type Description
itemnum bigint The internal unique identifier of the document; a foreign key to ITEMDATA.
mpinum bigint The internal unique identifier of the patient’s Master Patient Index number, if identified on archive; a foreign key to MSTRPTINDEX.
mrnum bigint

The internal unique identifier of the patient’s Medical Record number, if identified on archive; a foreign key to MEDREC.

The indexes for the CHARTLESSDOCS table are located in DBSpace1.

CHARTLESSDOCS Table Indexes
Index Name Included Columns
chartlessdocs1 mpinum, mrnum
chartlessdocs2 mrnum, mpinum
chartlessdocs3 itemnum