Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT 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. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(64) | NULL | Describes the dictionary item in brief as provided by the user/system from the application during data entry |
IsDeleted | tinyint | NOT 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. |
IsVersioned | bit | NOT 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. |
CreatedUserId | int | NULL | 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 |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
Name | varchar(200) | NULL | User Defined Name for the current DataDictionaryItem that is Displayed on the UI screens. |
Abbreviation | varchar(64) | NULL | Unique Abbreviation for the current DataDictionaryItem. |
Active | bit | NULL | Whether the record is active or Inactive |
| | | Allowable Values |
| | | 1 - Active |
| | | 0 - Inactive |
InternationalCode | varchar(64) | NULL | Internationalised code for the Data Dictionary Item |
ItemValue1 | varchar(80) | NULL | Freetext field for storing ItemType specific information represented by corresponding HDictionaryItemType.ItemLabel1 |
ItemValue2 | varchar(80) | NULL | Freetext field for storing ItemType specific information represented by corresponding HDictionaryItemType.ItemLabel2 |
ItemTypeCode | varchar(64) | NULL | Code of the ItemType to which this Data Dictionary Item belongs to. Links to the Code field in HDictionaryItemType table. |
SortSequence | int | NULL | 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 |
DefaultItem | bit | NULL | 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. |
ItemCode | smallint | NULL | 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_oid | int | NOT NULL | ObjectID of HDictionaryItemType which links the Dictionary Item to the Item Type's record. |
|