Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSTaskTemplate Defines tasks available within Soarian Clinicals application with additional details (For example: Description, Code).
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectID of HSTaskTemplate table generated by Architecture.This field is always a primary key for the associated table.
InstanceHFCIDsmallintNOT 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.
RecordIdintNULL 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
Descriptionvarchar(1)NULL User-defined information provided by the modules in the application. The length of this field varies with tables.
IsDeletedtinyintNOT 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.
IsVersionedbitNOT 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.
CreatedUserIdintNULL The object ID of the user who created the object. This field is linked to HSUser table to get details about the user.
CreationTimesmalldatetimeNULL Date and time when the object was created
TaskNamevarchar(255)NULL Name of the task.
TaskDesvarchar(255)NULL Description of the task.
TaskCodevarchar(100)NULL Code associated with the task.
EmergencyAccessAllowedbitNULL 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.
LastChangeddatetimeNULL The most recent date and time when the record last got changed
TaskActivationtinyintNULL 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.
AuthenticationbitNULL 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
BeginTimesmalldatetimeNULL Start of activation time for the Task
EndTimesmalldatetimeNULL End of activation time for the Task
IsTaskReadOnlybitNULL Indicates if the Task is ReadOnly. Allowable values - null, 0, 1. Key of allowable values: 0 - False, 1 - True

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates