Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrderSourceModifier There are three primary ordering sources (Verbal,Written & Per Protocol) which are used when placing an order. This table stores user defined modifiers for these sources eg e-Mail(Written),Phone(Verbal) etc
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 1454. 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 Description of the order source as entered by the user.
IsDeletedsmallintNOT 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.
IsVersionedsmallintNOT 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 HOrderSourceModifier_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.
OrderSourceModifierNamevarchar(64)NOT NULL Name of the order source modifier
OrderSourceModifierAbbrvarchar(16)NOT NULL Abbreviation of the order source modifier
OrderSourceAbbrchar(4)NOT NULL Abbreviation of the primary order source
Allowable Values:
VERB - Verbal
WRTN - Written
PRTL - Per Protocol
StartDateTimesmalldatetimeNULL DateTime since when the ordersource modifier definition is active
EndDateTimesmalldatetimeNULL DeteTime when the modifier record becomes inactive
ObsoleteDateTimesmalldatetimeNULL DateTime when the modifier record was obsoleted
ValidityStatusvarchar(16)NOT NULL Validity Status of the record
ValidityStatusCodesmallintNOT NULL Code for the Validity Status of the record
Allowable Values:
0 - Active
1 - InActive
2 - Incomplete
3 - Obsolete

Return to Table-Index

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