Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HChiefComplaintHistory Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | Not Used |
Description | varchar(255) | NULL | Not Used |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HChiefComplaintHistory row. |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
PatientObjectID | int | NULL | Patient ObjectID as in Hpatient table |
VisitObjectID | int | NULL | Visit ObjectID as in HPatientVisit Table |
UnitContactedName | varchar(75) | NULL | Unit Contacted Name for the visit. Must exist in HHealthCareUnit Table. |
VisitStartDateTime | datetime | NULL | Visit start date and time. |
VisitEndDateTime | datetime | NULL | Visit End Date and time. |
VisitType | varchar(30) | NULL | Visit Type. Must exist as a code in HPatientClass table. |
OldValue | varchar(255) | NULL | Previous Chief Complaint value for the visit. |
NewValue | varchar(255) | NULL | New Chief Complaint value for the visit. |
ChangedBy | varchar(184) | NULL | UserId of the user who changed Chief Complaint value for the visit |
ChangedDateTime | datetime | NULL | Last system UTC date /time when row was updated. |
|