Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtAllergyReaction Reaction a Patient has to a component of an allergy
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID of the Reaction to a component of an allergy
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class ID of the object(HFCID = 3408). 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 Allergy Reaction information was originally recorded
RctNamevarchar(32)NOT NULL Name of the Reaction associated to the component / allergy combination.
RctCodevarchar(20)NULL Not valued in this table.
RctSeverityvarchar(50)NULL Severity of the reaction.
User defined data dictionary values.
RctSeverityCodevarchar(2)NULL Code representing the severity of the reaction
User defined data dictionary values
Allowable values:
MI - Mild
MO - Moderate
SV - Severe
U - Unknown
CmpStatusCodevarchar(1)NULL Status of the Component within the allergy
Allowable Values:
E - Erroneous
C - Active/Confirmed
I - Inactive
N - Not selected, this is if you have a multi-ingredient drug where one of the ingredients is identified to not cause a reaction
CmpCommentvarchar(250)NULL Pharmacy entered comment when Allergy Component is valued(that is when the Allergy in HPtAllergy is of Type 99CDN, 99DRG, 99ING, 99USR)
AllergyOIDintNOT NULL Object ID of the allergy the reaction is associated with(HPtAllergy table)
RctClassificationCodevarchar(2)NULL Pharmcy Classification
Allowable Values:
AD - Adverse Drug Reaction
AL - Allergy
CT - Contraindication
IN - Intolerance
SE - Side Effect
RctClassificationvarchar(50)NULL Not valued.
RctManagementvarchar(60)NULL Pharmacy entered comment for managing the reaction
IsLatesttinyintNOT NULL Allergy Reaction information is Active or Historical
Allowable values:
0 - Historical(Modification to the information has been made, not the most recent information)
1 - Active(Most recent information)
IsRemovedtinyintNOT NULL Allergy reaction was removed
Allowable values:
0 - No
1 - Yes
CmpNamevarchar(120)NULL Name of the component within the allergy to which the reaction applies. Only valued when allergy in HPtAllergy is of Type 99CDN, 99DRG, 99ING, 99USR.
CmpCodevarchar(32)NULL Code of the component within the allergy to which the reaction applies. Only valued when allergy in HPtAllergy is of Type 99CDN, 99DRG, 99ING, 99USR.
Value of AlgType in table HPtAllergy determines the possible values of this column. When AlgType:
99CDN(User defined drug product) - US only, 5 digit numeric code(DRUG_CODE column of Pharmacy table PDM)
99DRG(Drug Product)
US - First Data Bank's(FDB) Med Name ID(mnid column of the MedKnowledge Framework(MKF) table fdb_drugname)
EU - ID Berlin's Drug Product Code
99ING(Ingredient)
US - First Data Bank's(FDB) ingredient code(hicseqno from Med Knowledge Framework(MKF) table fdb_ingredient)
EU - ID Berlin's Drug Ingredient Code
99USR(User defined Ingredient) - US only, 3 digit numeric code in range 900-999(ALLERGY_CODE columnn of Pharmacy table PHMDA)
CmpTypevarchar(8)NULL Type of the component within the allergy to which the reaction applies. Only valued when allergy in HPtAllergy is of Type 99CDN, 99DRG, 99ING, 99USR.
Allowable Values:
99ING - Ingredient(Example: Acetaminophen)
99USR - User defined ingredient. Can only be created on Pharmacy(Pharmacy table PHMDA)
LastCngDtimedatetimeNULL Date time the information was last updated(UTC)

Return to Table-Index

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