Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSecurityManTestRec Stores zero-to-one relationship between HSecurityManTestRec and Patient. HSecurityManTestRec.Patient_oid = HPatient.Objectoid
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL The object ID of the object. This field is always a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL The HFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique identification of an object across the application.
RecordIdintNULL 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. Note: 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 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.
CreateDatesmalldatetimeNULL Date and time when the test record was created.
LastTestDatesmalldatetimeNULL Date and time when the last test was performed.
LastResulttinyintNULL Result of the last test that was performed.
IsActivebitNULL When set to True, indicates that the instance of the test is active. Allowable Values: 0,1, or NULL Key of allowable values: 0 - False, 1 - True.
LastChangeddatetimeNULL The most recent date and time when the test record was modified.
AccessDatesmalldatetimeNULL Date and time when the test record became accessible.
GroupNamevarchar(255)NULL Name of the group.
User_oidintNOT NULL Value stored as a result of a one-to-one relationship between HSecurityManTestRec and HSUser.
Patient_oidintNULL Value stored as a result of a zero-to-one relationship between HSecurityManTestRec and HPatient.
SecurityObject_oidintNOT NULL Value stored as a result of a one-to-one relationship between HSecurityManTestRec and HSecurityObject.
ExpResulttinyintNULL Type of expected result.
SecObjInstintNULL HFC(Healthcare Foundation Class) ID of the security object.
TestActiontinyintNULL Action of the test performed on the security object.
Passwordvarchar(100)NULL The password.
TestStatusvarchar(100)NULL The status of the test.

Return to Table-Index

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