Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOccurrenceOrder This table has details about Occurrences of a Non-Medication Order.
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. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1502. 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.
OrderOccurrenceStatusvarchar(64)NOT NULL Text value of the current status of the Occurrence
OrderOccurrenceStatusCodetinyintNOT NULL Code for the current status of the Occurrence
Allowable Values
0 - Active
1 - Suspend
2 - Cancel
3 - Discontinue
4 - Complete
5 - In Progress
6 - Invalid
7 - Not Complete
StartDateTimesmalldatetimeNOT NULL Original or Planned date time for this occurrence
ActualDateTimesmalldatetimeNULL Actual date time the occurrence was performed or actioned.
StatusEnteredDatetimesmalldatetimeNULL Date time of the most recent update to the status of this occurrence
ChartedByvarchar(30)NULL Username of the person who charted this occurrence. Contains the most recent value for the most recent charting
ChartingCommentvarchar(255)NULL Free Text comment entered by the user who updated the Occurrence
IsChargedbitNULL A charge has been created for this Occurrence
SampleStatusvarchar(40)NULL SampleStatus String of the sample(HCollectedSample) associated with this occurrence. De-normalized from the HCollectedSample table
SampleStatusCodetinyintNULL SampleStatus Code of the sample(HCollectedSample) associated with this occurrence. De-normalized from the HCollectedSample table
Allowable Values
10 - Pending Specimen to be collected
11 - Pending Specimen to be printed
12 - Specimen Collected
13 - Specimen Not Collected
OccurrenceOrderIDbigintNOT NULL This is system generated unique ID(other than objectID) for the occurrence which is communicated to external systems and can be used in printed reports. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
GroupIDvarchar(24)NULL ID of the group associated to this occurrence. Used for Lab order under sample grouping workflows
IsResultSignedbitNOT NULL When a Result is associated to this Occurrence, indicates when the result has been signed.
Allowable values:
0/Null - No
1 - Yes
ServiceDetail_oidintNOT NULL The Object ID of the Service Detail this Occurrence is for(HServiceDetail)
Order_oidintNOT NULL The object ID of the Order this Occurrence belongs to(HOrder)
SampleForOrdOcc_oidintNULL Object ID of the Sample(when an Occurrence has a specimen associated with it)(HCollectedSample)
ReasonForDiscontinuevarchar(120)NULL When the Occurrence has been discontinued(by a user, job, workflow, etc), the Reason the Occurrence was discontinued
WorklistItem_oidintNULL Link between WorklistItem objectid from the New ResultAssement worklist category to the Occurrence. When the assessment is charted from the worklist category , it uses this link to update the status of the occurrence.
ActualEndDateTimesmalldatetimeNULL Actual Date time the activity or service for this Occurrence was completed
OccModifierAbbrvarchar(4)NOT NULL The Modifier for the Occurrences Status . Links to ModifierAbbreviation column from HOccStatusModifier table.
OccModifierCodesmallintNOT NULL The ModifierCode for the Occurrence Status . Links to ModifierCode column from HOccStatusModifier table.
IsResultedsmallintNOT NULL Is there a Result associated with this Occurrence.
Allowable values:
0/Null - No
1 - Yes
OccurrenceReason_oidintNULL The Object ID of the coded reason for this Occurrence.
OccurrenceHistoryGroupIdbigintNULL Always the object id of the Occurrence when first created. When occurrences are updated it creates a new history row with previous state marking it as IsExpired=1 in the same table with new objectid , but keeping the OccurrenceHistoryGroupID the same. This field is used to get the history of updates performed on a given occurrence. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
OriginalOccurrenceIDbigintNULL Objectid of another row in HOccurrenceOrder(usually Expired rows) which represents the previous state of the occurrence. Null for newly created occurrence. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
IsExpiredbitNULL is a history row. Row with value 1 should never be fetched in normal occurrence processing. Used to keep the history. Allowable values: 0/Null - Not a history row, 1 - Is a history row
ProvidedByvarchar(188)NULL Staff Name of the Staff that actually fulfilled(provided or performed the service) this Occurrence
ProvidedBy_OIDintNULL The Object ID of the Staff that actually fulfilled this Occurrence. NULL when ProvidedBy is free text.(HStaff)
ProviderUnitAbbrvarchar(10)NULL The Abbreviation for the Service Provider(HHealthCareUnit)
ProviderUnit_OIDintNULL The Object ID of the Service Provider(HHealthcareUnit)
SessionIDintNULL Identifier of the User Session this Occurrence was created/updated in(HOccStateTransRec)
SupervisedBy_StaffOIDintNULL The Object ID of the Staff that actually supervised the activity or services associated with fulfilling this Occurrence. Zero when SupervisedByStaff is free text.(HStaff)
SupervisedByStaffvarchar(188)NULL Staff Name of the Staff that actually supervised the activity or services associated with fulfilling this Occurrence(HStaff)
ChartedbyUserOIDintNULL The Object ID of the User who entered the information for this Occurrence(HSUser)
WorkGroupIDVarchar(10)Null For Non Med, Non Specimen, Non Recurring orders, when a GroupID has been configured for a Service Provider Unit, this is the Identifier assigned for orders placed in the same session for the same Provider Unit, Start date time, Service Type, Service SubType Priority Modifier and Patient Visit.(orders are sent outbound in a single message).
HasAttentionFlagtinyintNULL Indicator if the user has marked this occurrence as requiring attention. Allowable values: 0/Null - No, 1 - Yes
AttentionCommentvarchar(255)NULL User entered comments indicating why this order requires special attention.
ClonedOrder_oidintNULL Order this Occurrence(and associated order) should be grouped with when displaying activity for the patient.
AssignedUser_oidintNULL The Object ID of the User assigned by the Staff Assignment(HSUser)
AssignedStaff_oidintNULL The Object ID of the Staff assigned by the Staff Assignment(HStaff)
AssignedUserNameVARCHAR(12)NULL The name of the User assigned by the Staff Assignment(HSUser)
AssignedStaffNameVARCHAR(184)NULL The name of the Staff assigned by the Staff Assignment(HName)
ManualChrgCompleteCHAR(1)NULL 'Y' if the manual charges are captured, NULL otherwise
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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