Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HExtendedOrder This table stores extended information of a Order which can be customized at the Client using the Extensibility feature. Clients use fields from this table to capture specific details about the order which they can use to send to integrating applications or for reporting.
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 1503. 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(1)NULL Not Valued in this table. Column exists as part of persistence framework implementation.
IsVersionedbitNOT 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 HExtendedOrder_Ver.
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.
UserDefinedDateTime1smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime2smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime3smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime4smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime5smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime6smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime7smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime8smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime9smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime10smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime11smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime12smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime13smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime14smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime15smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime16smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime17smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime18smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime19smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedDateTime20smalldatetimeNULL Field to store extended data of type date\time.
UserDefinedNumeric1intNULL Field to store extended data of type Numeric.
UserDefinedNumeric2intNULL Field to store extended data of type Numeric.
UserDefinedNumeric3intNULL Field to store extended data of type Numeric.
UserDefinedNumeric4intNULL Field to store extended data of type Numeric.
UserDefinedNumeric5intNULL Field to store extended data of type Numeric.
UserDefinedNumeric6intNULL Field to store extended data of type Numeric.
UserDefinedNumeric7intNULL Field to store extended data of type Numeric.
UserDefinedNumeric8intNULL Field to store extended data of type Numeric.
UserDefinedNumeric9intNULL Field to store extended data of type Numeric.
UserDefinedNumeric10intNULL Field to store extended data of type Numeric.
UserDefinedNumeric11intNULL Field to store extended data of type Numeric.
UserDefinedNumeric12intNULL Field to store extended data of type Numeric.
UserDefinedNumeric13intNULL Field to store extended data of type Numeric.
UserDefinedNumeric14intNULL Field to store extended data of type Numeric.
UserDefinedNumeric15intNULL Field to store extended data of type Numeric.
UserDefinedNumeric16intNULL Field to store extended data of type Numeric.
UserDefinedNumeric17intNULL Field to store extended data of type Numeric.
UserDefinedNumeric18intNULL Field to store extended data of type Numeric.
UserDefinedNumeric19intNULL Field to store extended data of type Numeric.
UserDefinedNumeric20intNULL Field to store extended data of type Numeric.
UserDefinedNumeric21intNULL Field to store extended data of type Numeric.
UserDefinedNumeric22intNULL Field to store extended data of type Numeric.
UserDefinedNumeric23intNULL Field to store extended data of type Numeric.
UserDefinedNumeric24intNULL Field to store extended data of type Numeric.
UserDefinedNumeric25intNULL Field to store extended data of type Numeric.
UserDefinedNumeric26intNULL Field to store extended data of type Numeric.
UserDefinedNumeric27intNULL Field to store extended data of type Numeric.
UserDefinedNumeric28intNULL Field to store extended data of type Numeric.
UserDefinedNumeric29intNULL Field to store extended data of type Numeric.
UserDefinedNumeric30intNULL Field to store extended data of type Numeric.
UserDefinedNumeric31intNULL Field to store extended data of type Numeric.
UserDefinedNumeric32intNULL Field to store extended data of type Numeric.
UserDefinedNumeric33intNULL Field to store extended data of type Numeric.
UserDefinedNumeric34intNULL Field to store extended data of type Numeric.
UserDefinedNumeric35intNULL Field to store extended data of type Numeric.
UserDefinedNumeric36intNULL Field to store extended data of type Numeric.
UserDefinedNumeric37intNULL Field to store extended data of type Numeric.
UserDefinedNumeric38intNULL Field to store extended data of type Numeric.
UserDefinedNumeric39intNULL Field to store extended data of type Numeric.
UserDefinedNumeric40intNULL Field to store extended data of type Numeric.
UserDefinedNumeric41intNULL Field to store extended data of type Numeric.
UserDefinedNumeric42intNULL Field to store extended data of type Numeric.
UserDefinedNumeric43intNULL Field to store extended data of type Numeric.
UserDefinedNumeric44intNULL Field to store extended data of type Numeric.
UserDefinedNumeric45intNULL Field to store extended data of type Numeric.
UserDefinedNumeric46intNULL Field to store extended data of type Numeric.
UserDefinedNumeric47intNULL Field to store extended data of type Numeric.
UserDefinedNumeric48intNULL Field to store extended data of type Numeric.
UserDefinedNumeric49intNULL Field to store extended data of type Numeric.
UserDefinedNumeric50intNULL Field to store extended data of type Numeric.
UserDefinedDecimal1varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal2varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal3varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal4varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal5varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal6varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal7varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal8varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal9varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal10varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal11varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal12varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal13varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal14varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal15varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal16varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal17varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal18varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal19varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedDecimal20varchar(15)NULL Field to store extended data of type Decimal.
UserDefinedString1varchar(255)NULL Field to store extended data of type String.
UserDefinedString2varchar(255)NULL Field to store extended data of type String.
UserDefinedString3varchar(255)NULL Field to store extended data of type String.
UserDefinedString4varchar(255)NULL Field to store extended data of type String.
UserDefinedString5varchar(255)NULL Field to store extended data of type String.
UserDefinedString6varchar(255)NULL Field to store extended data of type String.
UserDefinedString7varchar(255)NULL Field to store extended data of type String.
UserDefinedString8varchar(255)NULL Field to store extended data of type String.
UserDefinedString9varchar(255)NULL Field to store extended data of type String.
UserDefinedString10varchar(255)NULL Field to store extended data of type String.
UserDefinedString11varchar(255)NULL Field to store extended data of type String.
UserDefinedString12varchar(255)NULL Field to store extended data of type String.
UserDefinedString13varchar(255)NULL Field to store extended data of type String.
UserDefinedString14varchar(255)NULL Field to store extended data of type String.
UserDefinedString15varchar(255)NULL Field to store extended data of type String.
UserDefinedString16varchar(255)NULL Field to store extended data of type String.
UserDefinedString17varchar(255)NULL Field to store extended data of type String.
UserDefinedString18varchar(255)NULL Field to store extended data of type String.
UserDefinedString19varchar(255)NULL Field to store extended data of type String.
UserDefinedString20varchar(255)NULL Field to store extended data of type String.
UserDefinedString21varchar(255)NULL Field to store extended data of type String.
UserDefinedString22varchar(255)NULL Field to store extended data of type String.
UserDefinedString23varchar(255)NULL Field to store extended data of type String.
UserDefinedString24varchar(255)NULL Field to store extended data of type String.
UserDefinedString25varchar(255)NULL Field to store extended data of type String.
UserDefinedString26varchar(255)NULL Field to store extended data of type String.
UserDefinedString27varchar(255)NULL Field to store extended data of type String.
UserDefinedString28varchar(90)NULL Field to store extended data of type String.
UserDefinedString29varchar(90)NULL Field to store extended data of type String.
UserDefinedString30varchar(90)NULL Field to store extended data of type String.
UserDefinedString31varchar(90)NULL Field to store extended data of type String.
UserDefinedString32varchar(90)NULL Field to store extended data of type String.
UserDefinedString33varchar(90)NULL Field to store extended data of type String.
UserDefinedString34varchar(90)NULL Field to store extended data of type String.
UserDefinedString35varchar(90)NULL Field to store extended data of type String.
UserDefinedString36varchar(90)NULL Field to store extended data of type String.
UserDefinedString37varchar(90)NULL Field to store extended data of type String.
UserDefinedString38varchar(255)NULL Field to store extended data of type String.
UserDefinedString39varchar(255)NULL Field to store extended data of type String.
UserDefinedString40varchar(255)NULL Field to store extended data of type String.
UserDefinedString41varchar(255)NULL Field to store extended data of type String.
UserDefinedString42varchar(255)NULL Field to store extended data of type String.
UserDefinedString43varchar(255)NULL Field to store extended data of type String.
UserDefinedString44varchar(255)NULL Field to store extended data of type String.
UserDefinedString45varchar(255)NULL Field to store extended data of type String.
UserDefinedString46varchar(255)NULL Field to store extended data of type String.
UserDefinedString47varchar(255)NULL Field to store extended data of type String.
UserDefinedString48varchar(255)NULL Field to store extended data of type String.
UserDefinedString49varchar(255)NULL Field to store extended data of type String.
UserDefinedString50varchar(255)NULL Field to store extended data of type String.
UserDefinedString51varchar(255)NULL Field to store extended data of type String.
UserDefinedString52varchar(255)NULL Field to store extended data of type String.
UserDefinedString53varchar(255)NULL Field to store extended data of type String.
UserDefinedString54varchar(255)NULL Field to store extended data of type String.
UserDefinedString55varchar(255)NULL Field to store extended data of type String.
UserDefinedString56varchar(255)NULL Field to store extended data of type String.
UserDefinedString57varchar(255)NULL Field to store extended data of type String.
UserDefinedString58varchar(255)NULL Field to store extended data of type String.
UserDefinedString59varchar(255)NULL Field to store extended data of type String.
UserDefinedString60varchar(255)NULL Field to store extended data of type String.
UserDefinedString61varchar(255)NULL Field to store extended data of type String.
UserDefinedString62varchar(255)NULL Field to store extended data of type String.
UserDefinedString63varchar(255)NULL Field to store extended data of type String.
UserDefinedString64varchar(255)NULL Field to store extended data of type String.
UserDefinedString65varchar(255)NULL Field to store extended data of type String.
UserDefinedString66varchar(255)NULL Field to store extended data of type String.
UserDefinedString67varchar(255)NULL Field to store extended data of type String.
UserDefinedString68varchar(255)NULL Field to store extended data of type String.
UserDefinedString69varchar(255)NULL Field to store extended data of type String.
UserDefinedString70varchar(255)NULL Field to store extended data of type String.
UserDefinedString71varchar(255)NULL Field to store extended data of type String.
UserDefinedString72varchar(255)NULL Field to store extended data of type String.
UserDefinedString73varchar(255)NULL Field to store extended data of type String.
UserDefinedString74varchar(255)NULL Field to store extended data of type String.
UserDefinedString75varchar(255)NULL Field to store extended data of type String.
UserDefinedString76varchar(255)NULL Field to store extended data of type String.
UserDefinedString77varchar(255)NULL Field to store extended data of type String.
UserDefinedString78varchar(255)NULL Field to store extended data of type String.
UserDefinedString79varchar(255)NULL Field to store extended data of type String.
UserDefinedString80varchar(255)NULL Field to store extended data of type String.
UserDefinedString81varchar(255)NULL Field to store extended data of type String.
UserDefinedString82varchar(255)NULL Field to store extended data of type String.
UserDefinedString83varchar(255)NULL Field to store extended data of type String.
UserDefinedString84varchar(255)NULL Field to store extended data of type String.
UserDefinedString85varchar(255)NULL Field to store extended data of type String.
UserDefinedString86varchar(255)NULL Field to store extended data of type String.
UserDefinedString87varchar(255)NULL Field to store extended data of type String.
UserDefinedString88varchar(255)NULL Field to store extended data of type String.
UserDefinedString89varchar(255)NULL Field to store extended data of type String.
UserDefinedString90varchar(255)NULL Field to store extended data of type String.
UserDefinedString91varchar(255)NULL Field to store extended data of type String.
UserDefinedString92varchar(255)NULL Field to store extended data of type String.
UserDefinedString93varchar(255)NULL Field to store extended data of type String.
UserDefinedString94varchar(255)NULL Field to store extended data of type String.
UserDefinedString95varchar(255)NULL Field to store extended data of type String.
UserDefinedString96varchar(255)NULL Field to store extended data of type String.
UserDefinedString97varchar(255)NULL Field to store extended data of type String.
UserDefinedString98varchar(255)NULL Field to store extended data of type String.
UserDefinedString99varchar(255)NULL Field to store extended data of type String.
UserDefinedString100varchar(255)NULL Field to store extended data of type String.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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