Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object ID of the Allergy Assess/Reassess information |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class ID of the object(HFCID = 3411). 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 | Not used. |
CreatedUserId | int | NULL | Object ID of the User Assessing/Reassessing the allergy information(HSUser table) |
CreationTime | smalldatetime | NULL | Date and time this row was created(local) |
PatientVisitOID | int | NOT NULL | Object ID of the Patient Visit(HPatientVisit) associated with the patient for whom the allergy information has been recorded |
| | | When valued as -1 Allergy must be reassessed |
ReassessStatusCode | int | NOT NULL | Status of the allergy assessment/reassessment |
| | | Allowable Values: |
| | | -1 - Allergy must be reassessed |
| | | 1 - No Change to documented Patient Allergies(Reassess was required) |
| | | 2 - Update - Allergies will be or have been updated(Reassess was required) |
| | | 3 - Postpone - Postpone allergy reassessment for 5 minutes |
| | | 4 - Verify - Allergies have been reassessed(though reassess was not required) |
ReassessedByOID | int | NOT NULL | Object ID of the User Assessing/Reassessing the allergy information(HSUser table) |
| | | When valued as -1 Allergy must be reassessed |
ReassessDT | smalldatetime | NOT NULL | Date and time of the assess/reassess(local) |
PatientOID | int | NOT NULL | Object ID of the Patient(HPatient) for whom the allergy information is recorded |
PatientLocationOID | int | NOT NULL | Object ID of the Health Care Unit for the Patient's Location(HHealthCareUnit) |
| | | When valued as -1 Allergy must be reassessed |
PatientLocationDescription | varchar(30) | NULL | Not Valued. |
ReassessedBy | varchar(188) | NULL | Name of the User Assessing/Reassessing the allergy information(HSUser table - Last Name, First Name) |
LastCngDtime | datetime | NULL | Last date and time the information was updated(UTC) |