Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectID of HSTaskTemplate table generated by Architecture.This field is always a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object generated by Architecture. The value specified in the ObjectID field and in this field enables unique identification of an object across the application. |
RecordId | int | NULL | RecordId of HSTaskTemplate table generated by Architecture.Modules in the application can use this field to group all objects having something in common and then assign the same RecordId to all the objects |
Description | varchar(1) | NULL | User-defined information provided by the modules in the application. The length of this field varies with tables. |
IsDeleted | tinyint | NOT NULL | When set to 1, indicates that the object was deleted. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True. |
IsVersioned | bit | NOT NULL | When set to True, indicates that the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True. |
CreatedUserId | int | NULL | The object ID of the user who created the object. This field is linked to HSUser table to get details about the user. |
CreationTime | smalldatetime | NULL | Date and time when the object was created |
TaskName | varchar(255) | NULL | Name of the task. |
TaskDes | varchar(255) | NULL | Description of the task. |
TaskCode | varchar(100) | NULL | Code associated with the task. |
EmergencyAccessAllowed | bit | NULL | When set to True, indicates that the task can be accessed using emergency access. Allowable Values: 0,1, or NULL. Key of allowable values: 0 - False, 1 - True. |
LastChanged | datetime | NULL | The most recent date and time when the record last got changed |
TaskActivation | tinyint | NULL | Indicates the activation type of the task. Allowable Values: 0, 1, 2, or NULL Key of allowable values: 0 - TaskAct_UserLogin, 1 - TaskAct_ClientRequest, 2 - TaskAct_System. |
Authentication | bit | NULL | When set to True, indicates that a reauthentication is required to start the task. Allowable Values: 0,1, or NULL Key of allowable values: 0 - False, 1 - True |
BeginTime | smalldatetime | NULL | Start of activation time for the Task |
EndTime | smalldatetime | NULL | End of activation time for the Task |
IsTaskReadOnly | bit | NULL | Indicates if the Task is ReadOnly. Allowable values - null, 0, 1. Key of allowable values: 0 - False, 1 - True |
|
|