Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HDPAttributes 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 HDPAttributes row. |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
Procedure_oid | int | NULL | Procedure Objectid related to objectid in hprocedure table. |
Category | varchar(64) | NULL | Category of diagnosis and procedure. |
Attribute | varchar(255) | NULL | Attribute associated with the category. |
AttributeType | tinyint | NULL | Type of attribute. Allowable Values: 0 - DPAttribute 1 - SpecializedAttribute or NULL |
Diagnosis_oid | int | NULL | Dignosis Objectid related to objectid in HDiagnosis table |
IsDeleted | tinyint | NOT NULL | Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted) |
DiagnosisType | tinyint | NULL | Diagnosis type or "Type" from the HDiagnosis Table(Registration, Admitting, Working, Discharge, Billing). |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|