The MSTRPTINDEX table is the master index of all patients across the system. The MSTRPTINDEX table is located in DBSpace1.
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.
Index Name | Included Columns |
---|---|
mstrptindex1 | mpinumber, ptssn |
mstrtpindex3 | mpinum, mpinumber |