Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtAllergyIndicator Allergy Indicators recorded for a Patient
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID of the Allergy information. Primary key for this table.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class ID of the object(HFCID = 3410). 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 Whether the table data is versioned or not
Allowable values:
0 - No version data captured
1 - version changes available
CreatedUserIdintNULL Object ID of the User who created or updated the Allergy information(HSUser table)
CreationTimesmalldatetimeNULL Date and time(local) the Indicator information was originally recorded
PatientOIDintNOT NULL Object ID of the Patient(HPatient) for whom the Allergy Indicator information has been recorded
PatientVisitOIDintNOT NULL Object ID of the Patient Visit(HPatientVisit) associated with the patient for whom the Allergy Indicator information has been recorded. Used to track which visit allergy information has been created or updated. Move /Merge processing uses this column during move/merge processing.
NoLatexsmallintNOT NULL Indicator for Patient's allergy to Latex
Allowable Values:
0 - Patient is allergic to Latex
1 - Patient not allergic to Latex
2 - Not Assessed OR Unable to Assess
NoContrastsmallintNOT NULL Indicator for Patient's allergy to Contrast
Allowable Values:
0 - Patient is allergic to Contrast
1 - Patient not allergic to Contrast
2 - Not Assessed OR Unable to Assess
EnteredByOIDintNOT NULL Object ID of the User(HSUser) who entered or updated the Indicator information
EnteredDTsmalldatetimeNOT NULL Date and time(local) when the Indicator information was entered or updated
IsLatesttinyintNOT NULL Allergy Indicator information is Active or Historical
Allowable values:
1 - Active(Most recent information)
0 - Historical(Modification to the information has been made, not the most recent information)
ReasonForNotAssessedvarchar(60)NULL User enter reason for not assessing the Indicators
LastCngDtimedatetimeNULL Date time of last update(UTC).

Return to Table-Index

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