MEDDEPARTMENT - 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 MEDDEPARTMENT table stores information about configured Medical Departments. The MEDDEPARTMENT table is located in DBSpace8.

MEDDEPARTMENT Table Values
Column Name Data Type Description
dptnum bigint

The internal unique identifier of the department.

dptname chat(60) The display name of the department.
dptnamehl7 char(30)

The HL7 name configured for this department.

The indexes for the MEDDEPARTMENT table are located in DBSpace8.

MEDDEPARTMENT Table Indexes
Index Name Included Columns
meddepartment1 dptnum