Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HDiagnosisHistory 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 HDiagnosisHistory row |
CreationTime | smalldatetime | NULL | The date and time when the object is created. |
PatientObjectID | int | NULL | Object ID of the patient whose diagnosis is modified. |
VisitObjectID | int | NULL | Object ID of the patient visit associated with the patient whose diagnosis is modified. |
ICDCodeID | int | NULL | ICD code associated with the diagnosis of the patient's ailment. |
DiagnosisName | varchar(255) | NULL | The name of the diagnosis that is modified. |
FieldChanged | varchar(40) | NULL | Database fields that are modified in the diagnosis. |
OldValue | varchar(255) | NULL | Value prior to the modification of the diagnosis. |
NewValue | varchar(255) | NULL | New value after modification of the diagnosis. |
Changedby | varchar(24) | NULL | User ID who modified the diagnosis. |
DateChanged | smalldatetime | NULL | Date and time when the diagnosis is modified. |
Reason | varchar(255) | NULL | Reason(s) for modifying the diagnosis. |
DiagType | smallint | NULL | Indicates if Diagnosis is a Lifetime Cancer Diagnosis(Patient Level) or Visit Level Diagnosis("Financial") |
LastCngDtime | datetime | NULL | UTC time when name was last changed. |
|