Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HProcedureHistory Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | RecordId of the Patient Procedure History |
Description | varchar(1) | 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 HProcedureHistory row |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
PatientObjectID | int | NULL | Patient's unique identifier as Objectid in HPatient table. |
VisitObjectID | int | NULL | Patient's visit unique identifier as ObjectID in HPatientVisit Table. |
CPTCodeID | int | NULL | CPT code associated with the patient's procedure. |
ProcedureName | varchar(255) | NULL | The name of the procedure that is performed on a patient. Client can value it as CPT code description. |
FieldChanged | varchar(40) | NULL | Database fields that are modified in the procedure. |
OldValue | varchar(255) | NULL | Value prior to the modification of the procedure. |
NewValue | varchar(255) | NULL | New value after modification of the procedure. |
ChangedBy | varchar(184) | NULL | User name who modified the procedure. |
DateChanged | smalldatetime | NULL | Date and time when the procedure is modified. |
Reason | varchar(255) | NULL | Reason(s) for modifying the procedure. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|