Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSTask Defines all the tasks within the Soarian Clinicals application.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object Identifier of this record. This field is a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object. The value specified in the ObjectID field and in this field enables unique identification of an object across the application.
RecordIdintNULL Indicates the record ID. 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. For example, all related information for a patient, such as patient address, patient visits, patient name, etc., can be assigned the same RecordId. The modules can then query on this RecordId to retrieve the related information for that patient.
Descriptionvarchar(1)NULL User-defined information provided by the modules in the application. Not valued in this table.
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 Object Identifier 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.
TaskDesvarchar(255)NULL Description of the task.
VisblebitNULL When set to True, indicates that the task is visible on the screen in the application. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True
TaskGrouptinyintNULL The group to which the task belongs. Allowable Values: 0, 1, 2, 3, or NULL. Key of allowable values: 0 - STG_AdministrativeDesktop, 1 - STG_ClinicalDesktop, 2 - STG_SystemDefault, 3 - STG_UserDefault
BeginTimesmalldatetimeNULL The date and time when the task began.
LastChangeddatetimeNULL Most recent date and time when the task was modified.
EndTimesmalldatetimeNULL Date and time when the task ended.
ParentTask_oidintNULL Object ID for the parent task HSTask.
TaskTemplate_oidintNOT NULL Object ID for the HSTaskTemplate.
PatientUnitMatchtinyintNULL The type of match between a patient and a unit. Allowable Values: 0, 1, 2, or NULL. Key of allowable values: 0 - No match, 1 - Any type match, 2 - Zero match

Return to Table-Index

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