Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOccStateTransRec This table has the historical details of the transitions an occurrence of a non-medication order went through in the system.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDbigintNOT 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 1511. 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 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 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.
ToOrderOccStatevarchar(64)NULL State the occurrence is going to during this transition, i.e. Active, inprogress,etc.
ActualDateTimesmalldatetimeNULL Actual date time of the occurrence when it was charted.
StatusEnteredDatetimesmalldatetimeNULL Date and time when the status was entered.
ChartedByvarchar(30)NULL LoginID of the user who performed the occurrence state transition in the application.
ChartingCommentvarchar(255)NULL Comment that was entered by the user who performed the occurrence state transition in the application.
SampleStatusvarchar(40)NULL Sample status if it is related to a lab order, i.e. Specimen Not Collected,etc.
OccurrenceOrder_oidbigintNOT NULL Object ID of HOccurenceOrder. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
OccStatusCodetinyintNULL Code associated with the status of the transition
Allowable Values
0 - Active
1 - Suspend
2 - Cancel
3 - Discontinue
4 - Complete
5 - In Progress
6 - Invalid
7 - Not Complete
OccStatusModifierAbbrvarchar(4)NULL Abbreviation associated with the occurrence status modifier.
SessionIDintNULL Unique ID for a user's ordering session when signed created this transition record.
SessionStartDateTimedatetimeNULL Start date time for a user's ordering session when signed created this transition record.
SessionEndDateTimedatetimeNULL End date time for a user's ordering session when signed created this transition record.
StatusedSourcetinyintNULL System from which the status was updated
Allowable Values
0 - Changes on this occurrence is through Soarian
1 - Changes on this Occurrence is through Connectivity
SampleStatusCodesmallintNULL Code associated with the sample status.
Allowable Values
10 - Pending Specimen to be collected
11 - Pending Specimen to be printed
12 - Specimen Collected
13 - Specimen Not Collected
IsSampleRevisedbitNULL Whether sample has been revised. 0 indicates false, 1 indicates true.
ChartedbyUserOIDintNULL ObjectID of the user that performed the occurrence state transition in the application.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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