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

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The MSTRPTINDEX table is the master index of all patients across the system. The MSTRPTINDEX table is located in DBSpace1.

MSTRPTINDEX Table Values
Column Name Data Type Description
mpinum bigint

The internal unique identifier of the patient’s Master Patient Index (MPI).

mpinumber char(20)

The Master Patient Index number issued by the hospital organization.

ptfirstname char(20) The patient’s first name.
ptlastname char(30) The patient’s last name.
ptdob datetime The patient’s date of birth.
ptssn char(20) The patient’s social security number.
ptsex bigint

The patient’s gender; 0 = Undefined, 1 = Male, 2 = Female, 3 = Other, 4 = Ambiguous, 5 = Not Applicable.

primecarephysnum bigint

The internal unique identifier of the patient’s primary care physician; a foreign key to the PHYSICIANINFO table.

ptmiddlename char(36) The patient’s middle name.
ptspecialinst text Special instructions related to the patient.

The indexes for the MSTRPTINDEX table are located in DBSpace1.

MSTRPTINDEX Table Indexes
Index Name Included Columns
mstrptindex1 mpinumber, ptssn
mstrtpindex3 mpinum, mpinumber