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. |
| ptdeceaseddate | datetime | Date when the patient deceased |
| ptracenum | bigint | The patient's race |
| hl7root | char(120) | Stores the assigning authority |
The indexes for the MSTRPTINDEX table are located in DBSpace1.
| Index Name | Included Columns |
|---|---|
| mstrtpindex3 | mpinum, mpinumber |
| mstrtpindex4 | ptlastname, ptfirstname |
| mstrtpindex6 | mpinum |
| mstrtpindex7 | mpinumber, hl7root |