Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | bigint | 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 1536. 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(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsVersioned | bit | NOT NULL | Whether the table data is Versioned or not. |
| | | Allowable Values: |
| | | 0 - No version data captured. |
| | | 1 - Version changes available in _Ver table. |
| | | Once this field is set to 1, you cannot reset it to 0. If value is 1 , the current row represents the latest state , and all version data will be present in another table with the name HClinicalInformationEx_Ver. |
| | | 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. |
InternalValue | varchar(500) | NULL | Internal value of data if any. |
ExternalValue | varchar(2000) | NULL | External value of data. |
UOMCode | varchar(16) | NULL | If data has unit of measure ,this field will have code associated with the unit of measure. |
FieldID | varchar(255) | NULL | Unique Identifier of the form element where the data is shown or captured. It's the SvcFldID(Service field id) of the element in Adaptable form. |
DataSourceName | varchar(255) | NULL | Name of the Datasource from which this element/field is exposed. |
LinkContext | varchar(255) | NULL | Field in DataOwner recordset , which allows modules to hold a context under which the data was retrieved/stored. |
Editable | tinyint | NULL | Specifies whether the data was edited on Order Detail Form. There are many modifiable IMA(Inter-Module Adaptability) elements on Order Detail Form. When user modifies it , we mark this value with 1. This helps in doing stale data checking in ordering flow. The value is reset back to 0 on successful sign of the order |
Order_oid | int | NOT NULL | Object ID of HOrder. |
DataType | varchar(64) | NULL | Specifies what was the datatype(eg TextBox,ComboBox,RangeBox etc) of the element on the form. |
Range | nvarchar(255) | NULL | The range of the data which this element can accept. Usually valued for Numeric controls |
avl | nvarchar(255) | NULL | The allowable value list for this element. Will only be present for the elements which can have allowable options. eg ComboBox, Multicheck etc |
Uom_avl | nvarchar(255) | NULL | The allowable value list of Unit of measures. Not all elements will have this valued |
DocumentVerID | int | NULL | Not Valued. |
InternalValueIntial | nvarchar(500) | NULL | During order entry ,this stores the Initial internal value received from other module call. This helps in doing stale data check when user has changed the value on Order form. After signing of the order InternalValueIntial is made equal to InternalValue |
ExternalValueIntial | nvarchar(2000) | NULL | During order entry ,this stores the Initial external value received from other module call. This helps in doing stale data check when user has changed the value on Order form. After signing of the order ExternalValueIntial is made equal to ExternalValue |
UOMCodeIntial | nvarchar(16) | NULL | During order entry ,this stores the Initial UOMCode value received from other module call. This helps in doing stale data check when user has changed the value on Order form. After signing of the order UOMCodeIntial is made equal to UOMCode |
KeyValue | varchar(16) | NULL | Not Valued or used. This was a field to allow modules to help store a key value about the data which can be exchanged during business transactions. |
ServiceAbbreviation | varchar(64) | NULL | The Display name of the element which is represented by the FieldID. This can be used for reporting purpose as it will have a meaningful name as compared to FieldID |
ExtraParams | varchar(255) | NULL | Stores the metadata given by other module in this field and returns it back in the update API calls. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|