Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HDictionaryItemType This table defines the Dictionary Item Type , which is used to group the Dictionary Items in HDataDictionaryItem table
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 1401. 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(255)NULL Describes the dictionary item Type in brief as provided by the system during data entry. The record in this table is always system defined and is based on the system requirement.
IsDeletedtinyintNOT NULL Specifies whether the record is soft deleted.
Allowable Values
0 - Active
1 - Marked as Deleted.
Note: The presence of this field in tables depends on the configuration at the time of table design.
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.
Codevarchar(64)NULL Module defined Code for a DictionaryItemType Folder.Its used to Group together all the Data Dictionary Items that belong to a specific Type.
Namevarchar(60)NULL Module defined display Name for a DictionaryItemType Folder.Its used for Display on the Administrative Desktop for the specific Data Dictionary Item Folder.
IsDefaultRequiredbitNULL Whether Default Value is Needed for a specific DataDictionaryItemType.
Allowable Values
0 - False
1 - True
IntCodeLabelvarchar(40)NULL International Label for the type of data captured in HDataDictionaryItem.InternationalCode
ItemLabel1varchar(40)NULL Label for the type of data captured in HDataDictionaryItem.ItemValue1
ItemLabel2varchar(40)NULL Label for the type of data captured in HDataDictionaryItem.ItemValue2

Return to Table-Index

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