Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrderFunction This tables stores order function name and code values.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Unique Identifier of this Object.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object. HFCID of this object is 1428. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not used.
Descriptionvarchar(64)NULL Not used.
IsDeletedtinyintNOT NULL Specifies whether the record is soft deleted.
Allowable values:
0 - Active
1 - Marked as Deleted
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 Not used.
CreationTimesmalldatetimeNULL Not used.
FunctionNamevarchar(32)NULL Name of the Order Function.
CodetinyintNULL Internal Code of the Order Function.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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