Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Allergy
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| AllergyCode | CHARACTER(8) | MANDATORY | User entered allergy code. | |
| Type | CHARACTER(2) | MANDATORY | User enter allergy type. This field is validated by the 'AllergyType' lookup type. | |
| Description | CHARACTER(60) | MANDATORY | User entered description of the allergy. | |
| DrugCode | CHARACTER(6) | OPTIONAL | FK | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| RecordStatus | CHARACTER(1) | Record_Status_Active | MANDATORY | User selected record status for the allergy code. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. |
| DURClass | CHAR(8) | OPTIONAL | DUR class for the allergy code. | |
| MedcinID | INTEGER | 0 | OPTIONAL | Unique Identifier supplied by Medcin |
| UNII | CHAR(10) | OPTIONAL | Defines UNII code for Allergy. Possible Values include: (U)nique , (I)ngredient , (I)dentifier | |
| NDFRTCode | CHAR(16) | OPTIONAL | National drug file reference terminology code. | |
| KDCCode | CHAR(10) | OPTIONAL | FK to KDCCode. Used to identify which ingredient record this allergy corresponds to. | |
| AllergenClass | CHAR(5) | OPTIONAL | Codeset defined by Wolters-Kluwer. Used by Drug Class allergies. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting Allergy record... |
|---|---|---|
| PersonAllergy | PersonAllergy.AllergyCode = Allergy.AllergyCode | RESTRICT if PersonAllergy exists |