Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object ID of a patient's allergy reconcile detail instance |
InstanceHFCID | smallint | NOT 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. |
RecordId | int | NULL | Not used. |
Description | varchar(1) | NULL | Not used. |
IsVersioned | bit | NULL | Not used. |
CreatedUserId | int | NULL | Object ID of the User who reconciled the allergy information(HSUser table) |
CreationTime | smalldatetime | NULL | Date and time this row was created(local) |
ReconcileOId | int | NOT NULL | Object ID of the Patient Allergy Reconciliation session(HPtAllergyReconcile). Allergies from the same reconciliation session will have the same RecondileOId. |
AllergyName | varchar(255) | NOT NULL | Name of the Allergy to be reconciled. |
AllergySeverity | varchar(255) | NULL | Severity of the allergy to be reconciled |
AllergyReaction | varchar(255) | NOT NULL | Reaction of the allergy to be reconciled |
AlgStatusCode | varchar(1) | NOT NULL | Status of the Allergy to be Reconciled(Derived from the information in the CCD) |
| | | Allowable Values: |
| | | C - Active/Confirmed |
| | | I - Inactive |
AlgType | varchar(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 |
|
ReconcileCodeType | varchar(32) | NULL | Not valued |
ReconcileCode | varchar(32) | NULL | Not valued |
LinkObjectid | int | NULL | Object ID of the Allergy in HPtAllergy when this Allergy was added to the Patient's list of allergies during this reconciliation session. |
DocumentRootID | varchar(256) | NULL | Root ID of the CCD document |
DocumentIDExtension | varchar(128) | NULL | Document ID extension of the CCD document. |
DocumentIDAssigningAuthority | varchar(256) | NULL | Assigning Authority / Organization that created the CCD document. |
DocumentCreationTime | varchar(32) | NULL | Date time(local) the CCD document was created. |
AllergyOnsetDate | varchar(32) | NULL | Date time(local) of the onset of the allergy. Only valued when onset is an actual date. |
LastCngDtime | datetime | NOT NULL | Last date and time the information was updated(UTC) |