CHARTLESSDOCS - Database Reporting Guide - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - external - OnBase/Database-Reporting-Guide/Foundation-24.1/Database-Reporting-Guide/Database-Tables/CHARTLESSDOCS - 2024-07-01

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 24.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
chartlessdocs4 itemnum