Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HCommonDefinition This table stores the details of a Common Definition which can be linked to multiple Services thereby allowing grouping of these services under a common definition. Writing Rules on the common definition then allows same rules to apply on multiple services.
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 Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1532. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not Valued in this table. Column exists as part of persistence framework implementation.
Descriptionvarchar(64)NULL Valued same as the CommonDefName. Can be changed to more describe the definition.
IsVersionedbitNOT NULL When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design.
CreatedUserIdintNULL Object ID of the logged in user who created this record.
This field is linked to HSUser table to get details about the user. For more information see description of HSUser table
CreationTimesmalldatetimeNULL Date and time when the record is created.
CommonDefNamevarchar(64)NOT NULLUnique name for the Common Definition
Abbreviationvarchar(16)NOT NULLAbbreviation for the Common Definition
StartDateTimesmalldatetimeNULL Start Date Time since when the Common Definition is active
EndDateTimesmalldatetimeNULL End Date till when the Common Definition is active
ObsoleteDateTimesmalldatetimeNULL Date/Time when the Common definition is made obsolete
ValidityStatusvarchar(16)NULL Validity Status of the Common definition
Allowable Values
Active,InActive,Incomplete,Obsolete
ValidityStatusCodesmallintNULL Validity Status Code of the Common Definition
Allowable Values
0 - Active
1 - InActive
2 - Incomplete
3 - Obsolete

Return to Table-Index

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