Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
ObjectID | int | NOT NULL | Object ID of the Allergy information. Primary key for this table. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class ID of the object(HFCID = 3410). 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 Indicator information was originally recorded |
PatientOID | int | NOT NULL | Object ID of the Patient(HPatient) for whom the Allergy Indicator information has been recorded |
PatientVisitOID | int | NOT NULL | Object ID of the Patient Visit(HPatientVisit) associated with the patient for whom the Allergy Indicator information has been recorded. Used to track which visit allergy information has been created or updated. Move /Merge processing uses this column during move/merge processing. |
NoLatex | smallint | NOT NULL | Indicator for Patient's allergy to Latex |
| | | Allowable Values: |
| | | 0 - Patient is allergic to Latex |
| | | 1 - Patient not allergic to Latex |
| | | 2 - Not Assessed OR Unable to Assess |
NoContrast | smallint | NOT NULL | Indicator for Patient's allergy to Contrast |
| | | Allowable Values: |
| | | 0 - Patient is allergic to Contrast |
| | | 1 - Patient not allergic to Contrast |
| | | 2 - Not Assessed OR Unable to Assess |
EnteredByOID | int | NOT NULL | Object ID of the User(HSUser) who entered or updated the Indicator information |
EnteredDT | smalldatetime | NOT NULL | Date and time(local) when the Indicator information was entered or updated |
IsLatest | tinyint | NOT NULL | Allergy Indicator information is Active or Historical |
| | | Allowable values: |
| | | 1 - Active(Most recent information) |
| | | 0 - Historical(Modification to the information has been made, not the most recent information) |
ReasonForNotAssessed | varchar(60) | NULL | User enter reason for not assessing the Indicators |
LastCngDtime | datetime | NULL | Date time of last update(UTC). |