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 assessment |
CreationTime | smalldatetime | NULL | Date and time when the assessment was created. |
AssessmentID | int | NOT NULL | ID of the assessment. |
FormTypeID | int | NULL | ID of the form type as defined in the Documentation Builder module. |
FormUsageID | int | NULL | ID of the form usage as defined in the Documentation Builder module. |
Form_oid | int | NULL | ID of the form associated with the assessment. |
FormUsageDisplayName | varchar(100) | NULL | Name of the form associated with the assessment. |
FormDateTime | smalldatetime | NULL | Date and time used to instantiate the form from the Documentation Builder module. |
CategoryStatus | int | NOT NULL | Category to which the assesssment belongs. |
SequenceNumber | int | NOT NULL | Sequence number of each chapter in a chaptered assessment. |
FormUsage | varchar(50) | NULL | Form usage that was assigned to the assessment as defined in the Documentation Builder Module. |
IsLatest | tinyint | NULL | When set to 1 then it is the latest version. |
Assessment_oid | int | NOT NULL | ID of the object(HAssessment). |
Version | smallint | NOT NULL | Version of the observation. The version is incremented by one every time the observation is modified. When a new assessment is charted, the initial version of the observation is 1 if the observation is valued, and 0 if the observation is not valued. |
Mandatory | tinyint | NULL | When set to 1 the assessment has mandatory elements. |
FormVersion | smallint | NULL | Version of the form used. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|