Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HDataDictionaryItem This table stores the details about any Dictionary Item used by the system. If system needs to define a list of items (system defined / user configured) for any business requirement then this shall be used. Records in this table appears in the Catalog browser of Administrative Desktop as one of the Catalog Item named Data Dictionary Items.
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 1402. 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 Describes the dictionary item in brief as provided by the user/system from the application during data entry
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.
Namevarchar(200)NULL User Defined Name for the current DataDictionaryItem that is Displayed on the UI screens.
Abbreviationvarchar(64)NULL Unique Abbreviation for the current DataDictionaryItem.
ActivebitNULL Whether the record is active or Inactive
Allowable Values
1 - Active
0 - Inactive
InternationalCodevarchar(64)NULL Internationalised code for the Data Dictionary Item
ItemValue1varchar(80)NULL Freetext field for storing ItemType specific information represented by corresponding HDictionaryItemType.ItemLabel1
ItemValue2varchar(80)NULL Freetext field for storing ItemType specific information represented by corresponding HDictionaryItemType.ItemLabel2
ItemTypeCodevarchar(64)NULL Code of the ItemType to which this Data Dictionary Item belongs to. Links to the Code field in HDictionaryItemType table.
SortSequenceintNULL Sequence of Sorting which can be used to display the records of similar item types in UI. Field is nullable , can be used to give a specific sequence if the list is to be sorted
DefaultItembitNULL For a given ItemType , a record can be marked as default. Business process which queries for a particular dictionary item using itemtype can get multiple rows. If they need to process using default , system/user can configure a default which will be used by business process.
ItemCodesmallintNULL Module defined Code if its needed for the current DictionaryItem. Its Nullable. As the name of the DDI is internationalized , Business process can define a code and do the processing on the code
ItemType_oidintNOT NULLObjectID of HDictionaryItemType which links the Dictionary Item to the Item Type's record.

Return to Table-Index

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