Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object ID of the patient's allergy reconcile session |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class ID of the object(HFCID = 3414). 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(local) this row was created |
ReconcileSeqNo | int | NOT NULL | Reconciliation Sequence number(Unique for an environment). Used for determining the most recent reconciliation for a Patient / Visit combination. |
CreatedUserName | varchar(188) | NOT NULL | Name of the user who reconciled the allergy information(HSUser table) |
ReconcileDateTime | datetime | NOT NULL | Date and time(local) when the allergy reconciliation occurred |
PatientVisitOID | int | NOT NULL | Object ID of the Patient Visit(HPatientVisit) associated with the patient whose allergies were reconciled |
PatientOID | int | NOT NULL | Object ID of the Patient(HPatient) for whom the allergy information was reconciled |
LastCngDtime | datetime | NOT NULL | Last date and time the information was updated(UTC) |