Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtAllergyReassess Records of when allergy information for a patient have been Assessed/Reassessed. An initial assessment as well as subsequent assessments create rows in this table.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID of the Allergy Assess/Reassess information
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class ID of the object(HFCID = 3411). Note: The value specified in the ObjectID field and in this field enables unique identification of an object across the application.
RecordIdintNULL Not used.
Descriptionvarchar(1)NULL Not used.
IsVersionedbitNOT NULL Not used.
CreatedUserIdintNULL Object ID of the User Assessing/Reassessing the allergy information(HSUser table)
CreationTimesmalldatetimeNULL Date and time this row was created(local)
PatientVisitOIDintNOT NULL Object ID of the Patient Visit(HPatientVisit) associated with the patient for whom the allergy information has been recorded
When valued as -1 Allergy must be reassessed
ReassessStatusCodeintNOT NULL Status of the allergy assessment/reassessment
Allowable Values:
-1 - Allergy must be reassessed
1 - No Change to documented Patient Allergies(Reassess was required)
2 - Update - Allergies will be or have been updated(Reassess was required)
3 - Postpone - Postpone allergy reassessment for 5 minutes
4 - Verify - Allergies have been reassessed(though reassess was not required)
ReassessedByOIDintNOT NULL Object ID of the User Assessing/Reassessing the allergy information(HSUser table)
When valued as -1 Allergy must be reassessed
ReassessDTsmalldatetimeNOT NULL Date and time of the assess/reassess(local)
PatientOIDintNOT NULL Object ID of the Patient(HPatient) for whom the allergy information is recorded
PatientLocationOIDintNOT NULL Object ID of the Health Care Unit for the Patient's Location(HHealthCareUnit)
When valued as -1 Allergy must be reassessed
PatientLocationDescriptionvarchar(30)NULL Not Valued.
ReassessedByvarchar(188)NULL Name of the User Assessing/Reassessing the allergy information(HSUser table - Last Name, First Name)
LastCngDtimedatetimeNULL Last date and time the information was updated(UTC)

Return to Table-Index

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