Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtAllergyReconcileDetail Allergy Reconciliation Details - Row created for every Allergy that was available to be reconciled. US only.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID of a patient's allergy reconcile detail instance
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class ID of the object(HFCID = 3415). 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.
IsVersionedbitNULL Not used.
CreatedUserIdintNULL Object ID of the User who reconciled the allergy information(HSUser table)
CreationTimesmalldatetimeNULL Date and time this row was created(local)
ReconcileOIdintNOT NULL Object ID of the Patient Allergy Reconciliation session(HPtAllergyReconcile). Allergies from the same reconciliation session will have the same RecondileOId.
AllergyNamevarchar(255)NOT NULL Name of the Allergy to be reconciled.
AllergySeverityvarchar(255)NULL Severity of the allergy to be reconciled
AllergyReactionvarchar(255)NOT NULL Reaction of the allergy to be reconciled
AlgStatusCodevarchar(1)NOT NULL Status of the Allergy to be Reconciled(Derived from the information in the CCD)
Allowable Values:
C - Active/Confirmed
I - Inactive
AlgTypevarchar(8)NULL Allergy Type of the Allergy to be reconciled(Value derived from the information in the CCD)
Allowable Values:
99CDN - User defined drug product. Can only be created on Pharmacy(Pharmacy table PDM) Treated as free text allergy on Soarian
99DRG - Used when allergy is a drug product(Example: Percocet, Tylenol, etc.). Ingredients associated with a product will be documented in HPtAllergyReaction
99FTX - Free text allergy
99GRP - Group(Example: Cephalosporins)
99ING - Ingredient(Example: Acetaminophen)
99LCD - Longitudinal Care Record(LCR) coded allergies. Only sent from LCR. Treated as free text allergy on Soarian
99NON - Coded Non-Drug Allergy
99USR - User defined ingredient. Can only be created on Pharmacy(Pharmacy table PHMDA) Treated as free text allergy on Soarian
ReconcileCodeTypevarchar(32)NULL Not valued
ReconcileCodevarchar(32)NULL Not valued
LinkObjectidintNULL Object ID of the Allergy in HPtAllergy when this Allergy was added to the Patient's list of allergies during this reconciliation session.
DocumentRootIDvarchar(256)NULL Root ID of the CCD document
DocumentIDExtensionvarchar(128)NULL Document ID extension of the CCD document.
DocumentIDAssigningAuthorityvarchar(256)NULL Assigning Authority / Organization that created the CCD document.
DocumentCreationTimevarchar(32)NULL Date time(local) the CCD document was created.
AllergyOnsetDatevarchar(32)NULL Date time(local) of the onset of the allergy. Only valued when onset is an actual date.
LastCngDtimedatetimeNOT NULL Last date and time the information was updated(UTC)

Return to Table-Index

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