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

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 24.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
meddepartment2 dptnum
meddepartment3 dptname
meddepartment4 dptnamehl7