Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
patient_oid | int | NOT NULL | Object Id reference to HPatient table |
patientmerged | bit | NOT NULL | This indicates if the patient is merged(Values are 0 - Not merged, 1 - Merged) |
lastquerydtime | datetime | NOT NULL | When was the last query for this patient sent to HDX. Retention will be 45 days |
querycount | smallint | NOT NULL | How many times med history query sent for this patient |
externalid | varchar(32) | NULL | Id to look up the history for a patient |
LastName | varchar(60) | NULL | Patient last name |
FirstName | varchar(30) | NULL | Patient first name |
StreetAddress | varchar(255) | NULL | Patient street address |
City | varchar(64) | NULL | Patient city |
AreaofCountry | varchar(50) | NULL | Patient state |
PostalCode | varchar(10) | NULL | Patient ZIP code |
PhoneNo | varchar(30) | NULL | Patient phone number |
BirthTime | datetime | NULL | Patient birth date and time |
Sex | tinyint | NULL | Patient gender(0-Male, 1-Female,3-Unknown) |
MedHistoryConsent | varchar(64) | NULL | Patient consent to whether he/she agrees or not if a physician can review their Medication History(Values are - Yes, No, Undetermined.) |
daysinthepast | smallint | NOT NULL | How far back is the med history. If the preference is increased this will force a new query |
lasterrordtime | datetime, | | When was last error occurred while fetching medication history |
lasterrormsg | varchar(255), | | Last error message |
lasterrorcnt | int | | Last error count, that can help figure out if we are having problems |