Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOccStatusModifier Order Occurrence Status Modifiers. Used to provide additional status information for an occurrence.
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 1440. 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 User entered free text description of the Status Modifier.
IsDeletedtinyintNOT NULL Not used.
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 the description of the HSUser table.
CreationTimesmalldatetimeNULL Date and time when the record was created.
Modifiervarchar(64)NOT NULL Full or Long Name of the occurrence status modifier.
ModifierCodeSmallintNOT NULL Internal code of the occurrence status modifier.
OccStatusvarchar(64)NOT NULL External Value for system-defined occurrence status.
Allowable values:
Active
Suspend
Cancel
Discontinue
Complete
In Progress
Invalid
Not Complete
OccStatusCodesmallintNOT NULL Code of the system-defined occurrence status.
Allowable values:
0 - Active
1 - Suspend
2 - Cancel
3 - Discontinue
4 - Complete
5 - In Progress
6 - Invalid
7 - Not Complete
MedOrNonMedtinyintNOT NULL When valued as 1 - Non Medication order status modifier
When valued as 0 - Medication order status modifier
StartDateTimesmalldatetimeNULL Date and time when the record is considered active. When creating a new modifier, the default value is the current date and time.
EndDateTimesmalldatetimeNULL Date and time when the record is no longer active. When creating a new modifier, if the user does not specify a value, this column will be valued with 1900-01-01 00:00:00.
ObsoleteDateTimesmalldatetimeNULL Date and time when the record was obsoleted. When the user has not entered a value for this column, it will be valued with 1900-01-01 00:00:00.
ValidityStatusvarchar(16)NOT NULL Whether the occurrence modifier is Active or Inactive. Allowable values: Active, Inactive
ValidityStatusCodesmallintNOT NULL Internal value indicating the row is Active or Inactive.
Allowable values:
0 - Complete
2 - Incomplete
ModifierAbbreviationvarchar(4)NOT NULL Occurrence status modifier abbreviation.
IsDefaultbitNOT NULL Indicates if this occurrence status modifier is a model status modifier.
Allowable values:
1 - Model occurrence status modifier
0 - Non-model occurrence status modifier
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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