Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HRecOrders4OccGen This is a worktable that holds recurring Non-medication orders which need to have occurrences generated by the scheduled job of occurrence generation.
Column Name Column Datatype Column Null Option Column Comment
OrderOIDintNOT NULL Internal Order Identifier. ObjectID of Order(HOrder table)
VisitOIDintNULL Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table)
PatientOIDintNOT NULL Internal Patient Identifier. ObjectID of Patient(HPatient table)
RecOrderTypetinyintNOT NULLWhat type of recurring order is this
Allowable Values:
1 - Open Ended Recurring Order
2 - Duration based or explicit stop date Recurring order.
GenOccCountintNOT NULL Number of occurrences already generated for the order
LastOccStDtTimesmalldatetimeNULL Planned DateTime of the Last generated Occurrence
NextGenOccStDtTimesmalldatetimeNOT NULL Planned DateTime for the next occurrence to be generated
RevisedDateTimesmalldatetimeNULL DateTime when this entry got modified.
StatustinyintNOT NULLStatus till when the record will qualify for occurrence generation
Allowable Values:
0 - Active
1 - Inactive

Return to Table-Index

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