Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
RtgArtifactRoutingRequest Contains a list of requests to route patient documentation to another provider by either a fax, or direct message.
Column Name Column Datatype Column Null Option Column Comment
RoutingRequestOidBIGINTNOT NULL Unique object Id for the table RtgArtifactRoutingRequest.
PatientOidINTNOT NULL Patient object Id that the request is being generated for.
PatientVisitOidINTNOT NULL Patient Visit that the request is being generated for.
ContextOidBIGINTNULL The secondary object Id of the patient.(TbVisitOID)
ContextTypeVARCHAR(8)NULL What is the type of contextOid(EDvisit)
RoutingRequestTypeVARCHAR(8), Where is the request coming from Orders(ord) for referral, provider doc(pdoc) for visit end.
RoutingRequestTypeOidBIGINTNOT NULL OrderID or documentID that this request was generated by
RoutingRequestDTimeDATETIMENOT NULL Date time that the master request was created
RecipientCountINTNOT NULL The number of recipients that will be receiving this routing request.
RecipientSuccessCntINTNULL Number of recipients that the artifact was delivered to successfully
RecipientFailureCntINTNULL Number of recipients that the artifact was NOT delivered to successfully
RequestedByStaffIdINTNOT NULL The person who initiated the original request for artifact to be routed.
HasFailureBITNULL Does the overall request have any failure destinations(0,1,Null) Null until a failure is received, or all destinations are sent successfully(Null or 0 - No 1- yes)
RequestStatusVARCHAR(16)NULL Overall Status of the request,(Pending, Transmitted, Complete)
IsDeletedBITNOT NULL Has the request been deleted.(0 - No, 1 - Yes)
LastStatusUpdateDtimeDATETIMENULL Last updated date time that a status about the request was received.
LastCngDTimeDATETIMENOT NULL Indicates the current Universal Time Coordinate that this record was changed.

Return to Table-Index

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