Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
RtgArtifactRoutingDestination Contains the list of destinations and last received status of sending the artifact to the destination that a routing request has generated.
Column Name Column Datatype Column Null Option Column Comment
RoutingRequestDestinationOidBIGINTNOT NULL Unique object Id and primary key for the table RtgArtifactRoutingDestination.
RoutingRequestOidBIGINTNOT NULL Foreign key to routing request table
RecipientStaffOidINTNULL Staff ID of the recipient for this artifact.
RecipientRequestTypeVARCHAR(16)NOT NULL Allowable values are: followup, courtesycopy or referral. needed for MU3.
OrganizationOidINTNULL Organization object ID where the artifact is to be routed to
ArtifactTypeINTNOT NULL Non Zero - OPR(Operational Report) report or 0 - Clx(Clinical Letter)
ArtifactNameVARCHAR(85)NOT NULL Name of the artifact that is being generated Matched to OMSReportName length.
ArtifactTriggerEventVARCHAR(32)NULL Event that will trigger this artifact to be generated and routed.
ArtifactTriggerDelayTimeSMALLINTNOT NULL how long past the trigger event should we wait
SendingSystemIDVARCHAR(64)NOT NULL How is this request being sent. OMS(fax), AIS(Direct message)
RoutingAddressVARCHAR(256)NOT NULL Fax number or direct address Mapped to DM size
SendingSystemArtifactIDBIGINTNULL ID returned by the system that will generate and route the artifact to be able to maintain status.
ArtifactRequestCreatedBITNULL Has the routing module made the call to either Clinical Letter or HSF/OMS to create the artifact( Null, 0 - No, 1 - Yes).
ArtifactRequestDTimeDATETIMENULL Date time that artifact request was generated(Wall clock)
IsRequestSuccessfulBITNULL Is the individual routing destination request successful.(0 successful, 1 failed)
LastStatusCdINTNULL Last updated status code received from a sending system
LastStatusDescriptionVARCHAR(255)NULL Readable version of status code returned by the sending system.
LastStatusDTimeDATETIMENULL Date time last status code was received
IsDeletedBITNOT NULL SoftDelete flag done for BI(Business Intelligence)(0 - No, 1 - Yes).
IsReceivedAfterTransmissionBITNOT NULL has provider documentation module marked document erroneous or modified the document after the artifact has already been sent(0 - No, 1 - Yes).
LastCngDTimeDATETIMENOT NULL Indicates the current Universal Time Coordinate or Greenwich Mean Time
ReplyToAddressVARCHAR(256)NULL Reply To Address from Preference id 13532 name RTG_PREF_SCS_Email_Address

Return to Table-Index

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