Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
MedrecPatInfo This table contains Medication History Prefetch criteria sent to retrieve Medication History from SureScripts
Column Name Column Datatype Column Null Option Column Comment
patient_oidintNOT NULL Object Id reference to HPatient table
patientmergedbitNOT NULL This indicates if the patient is merged(Values are 0 - Not merged, 1 - Merged)
lastquerydtimedatetimeNOT NULL When was the last query for this patient sent to HDX. Retention will be 45 days
querycountsmallintNOT NULL How many times med history query sent for this patient
externalidvarchar(32)NULL Id to look up the history for a patient
LastNamevarchar(60)NULL Patient last name
FirstNamevarchar(30)NULL Patient first name
StreetAddressvarchar(255)NULL Patient street address
Cityvarchar(64)NULL Patient city
AreaofCountryvarchar(50)NULL Patient state
PostalCodevarchar(10)NULL Patient ZIP code
PhoneNovarchar(30)NULL Patient phone number
BirthTimedatetimeNULL Patient birth date and time
SextinyintNULL Patient gender(0-Male, 1-Female,3-Unknown)
MedHistoryConsentvarchar(64)NULL Patient consent to whether he/she agrees or not if a physician can review their Medication History(Values are - Yes, No, Undetermined.)
daysinthepastsmallintNOT NULL How far back is the med history. If the preference is increased this will force a new query
lasterrordtimedatetime, When was last error occurred while fetching medication history
lasterrormsgvarchar(255), Last error message
lasterrorcntint Last error count, that can help figure out if we are having problems

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates