Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object ID of the Reaction to a component of an allergy |
InstanceHFCID | smallint | NOT 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 |
RecordId | int | NULL | Not used. |
Description | varchar(1) | NULL | Not used. |
IsVersioned | bit | NOT NULL | Whether the table data is versioned or not |
| | | Allowable values: |
| | | 0 - No version data captured |
| | | 1 - version changes available |
CreatedUserId | int | NULL | Object ID of the User who created or updated the Allergy information(HSUser table) |
CreationTime | smalldatetime | NULL | Date and time(local) the Allergy Reaction information was originally recorded |
RctName | varchar(32) | NOT NULL | Name of the Reaction associated to the component / allergy combination. |
RctCode | varchar(20) | NULL | Not valued in this table. |
RctSeverity | varchar(50) | NULL | Severity of the reaction. |
| | | User defined data dictionary values. |
RctSeverityCode | varchar(2) | NULL | Code representing the severity of the reaction |
| | | User defined data dictionary values |
| | | Allowable values: |
| | | MI - Mild |
| | | MO - Moderate |
| | | SV - Severe |
| | | U - Unknown |
|
CmpStatusCode | varchar(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 |
CmpComment | varchar(250) | NULL | Pharmacy entered comment when Allergy Component is valued(that is when the Allergy in HPtAllergy is of Type 99CDN, 99DRG, 99ING, 99USR) |
AllergyOID | int | NOT NULL | Object ID of the allergy the reaction is associated with(HPtAllergy table) |
RctClassificationCode | varchar(2) | NULL | Pharmcy Classification |
| | | Allowable Values: |
| | | AD - Adverse Drug Reaction |
| | | AL - Allergy |
| | | CT - Contraindication |
| | | IN - Intolerance |
| | | SE - Side Effect |
RctClassification | varchar(50) | NULL | Not valued. |
RctManagement | varchar(60) | NULL | Pharmacy entered comment for managing the reaction |
IsLatest | tinyint | NOT 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) |
IsRemoved | tinyint | NOT NULL | Allergy reaction was removed |
| | | Allowable values: |
| | | 0 - No |
| | | 1 - Yes |
CmpName | varchar(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. |
CmpCode | varchar(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) |
CmpType | varchar(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) |
LastCngDtime | datetime | NULL | Date time the information was last updated(UTC) |