Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
RoutingRequestDestinationOid | BIGINT | NOT NULL | Unique object Id and primary key for the table RtgArtifactRoutingDestination. |
RoutingRequestOid | BIGINT | NOT NULL | Foreign key to routing request table |
RecipientStaffOid | INT | NULL | Staff ID of the recipient for this artifact. |
RecipientRequestType | VARCHAR(16) | NOT NULL | Allowable values are: followup, courtesycopy or referral. needed for MU3. |
OrganizationOid | INT | NULL | Organization object ID where the artifact is to be routed to |
ArtifactType | INT | NOT NULL | Non Zero - OPR(Operational Report) report or 0 - Clx(Clinical Letter) |
ArtifactName | VARCHAR(85) | NOT NULL | Name of the artifact that is being generated Matched to OMSReportName length. |
ArtifactTriggerEvent | VARCHAR(32) | NULL | Event that will trigger this artifact to be generated and routed. |
ArtifactTriggerDelayTime | SMALLINT | NOT NULL | how long past the trigger event should we wait |
SendingSystemID | VARCHAR(64) | NOT NULL | How is this request being sent. OMS(fax), AIS(Direct message) |
RoutingAddress | VARCHAR(256) | NOT NULL | Fax number or direct address Mapped to DM size |
SendingSystemArtifactID | BIGINT | NULL | ID returned by the system that will generate and route the artifact to be able to maintain status. |
ArtifactRequestCreated | BIT | NULL | Has the routing module made the call to either Clinical Letter or HSF/OMS to create the artifact( Null, 0 - No, 1 - Yes). |
ArtifactRequestDTime | DATETIME | NULL | Date time that artifact request was generated(Wall clock) |
IsRequestSuccessful | BIT | NULL | Is the individual routing destination request successful.(0 successful, 1 failed) |
LastStatusCd | INT | NULL | Last updated status code received from a sending system |
LastStatusDescription | VARCHAR(255) | NULL | Readable version of status code returned by the sending system. |
LastStatusDTime | DATETIME | NULL | Date time last status code was received |
IsDeleted | BIT | NOT NULL | SoftDelete flag done for BI(Business Intelligence)(0 - No, 1 - Yes). |
IsReceivedAfterTransmission | BIT | NOT NULL | has provider documentation module marked document erroneous or modified the document after the artifact has already been sent(0 - No, 1 - Yes). |
LastCngDTime | DATETIME | NOT NULL | Indicates the current Universal Time Coordinate or Greenwich Mean Time |
ReplyToAddress | VARCHAR(256) | NULL | Reply To Address from Preference id 13532 name RTG_PREF_SCS_Email_Address |