The MEDREC table stores one row for each patient Medical Record, which is typically a unique identifier of a patient within a facility but across multiple visits. The MEDREC table is located in DBSpace1.
Column Name | Data Type | Description |
---|---|---|
mrnum | bigint |
The internal unique identifier of the Medical Record. |
medrecnumber | char(20) | The Medical Record Number issued by the facility or hospital organization. |
facilitynum | bigint | The medical facility associated with this patient’s records; a foreign key to the MEDFACILITY table. |
mpinumber | char(20) | The Master Patient Index number issued by the facility or hospital organization. |
ptfirstname | char(20) | Patient’s first name. |
ptlastname | char(30) | Patient’s last name. |
ptdob | datetime | Patient’s date of birth. |
ptssn | char(20) |
Patient’s social security number. |
ptsex | bigint | Patient’s gender; 0 = Undefined, 1 = Male, 2 = Female, 3 = Other, 4 = Ambiguous, 5 = Not Applicable. |
hl7source | char(50) |
The source of the HL7 message that created the Medical Record. |
mpinum | bigint | The internal unique identifier of the patient’s Master Patient Index number; a foreign key to the MSTRPTINDEX table. |
ptmiddlename | char(36) |
Patient’s middle name. |
birthplace | char(75) | Patient’s birthplace. |
address1 | char(80) | Address field for the patient. |
address2 | char(80) | Address field for the patient. |
address3 | char(80) | Address field for the patient. |
city | char(75) | The city of the patient’s address. |
stateabbr | char(2) | The state of the patient’s address. |
zipcode | char(10) | The zip code of the patient’s address. |
mrcontactname | char(100) | The patient’s emergency contact information. |
homephone | char(30) | The patient’s home phone number. |
workphone | char(30) | The patient’s work phone number. |
The indexes for the MEDREC table are located in DBSpace1.
Index Name | Included Columns |
---|---|
medrec2 | medrecnumber, mpinumber |
medrec3 | mpinumber, medrecnumber |
medrec4 | mpinum, medrecnumber, ptssn |
medrec5 | mrnum, medrecnumber |