Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The primary key for the table. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | This column is not used. |
Description | varchar(1) | NULL | This column is not used. |
IsVersioned | bit | NOT NULL | When set to True(1), indicates that the object was modified. |
CreatedUserId | int | NULL | Object ID of the user who created the object. |
CreationTime | smalldatetime | NULL | Date and time when the object was created. |
ReasonRevised | varchar(255) | NULL | The reason the assessment was revised. |
UserTitle | varchar(20) | NULL | Title of the user. |
UserAbbrName | varchar(92) | NULL | Abbreviation name of the user. |
User_oid | int | NULL | ID of the user. |
Assessment_oid | int | NOT NULL | ID for the HAssessment table. |
VersionPtr | smallint | NULL | Current version of the assessment before a revert operation. |
ToVersionPtr | smallint | NULL | Specifies to which version the assessment was reverted to. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|