Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
RoutingRequestOid | BIGINT | NOT NULL | Unique object Id for the table RtgArtifactRoutingRequest. |
PatientOid | INT | NOT NULL | Patient object Id that the request is being generated for. |
PatientVisitOid | INT | NOT NULL | Patient Visit that the request is being generated for. |
ContextOid | BIGINT | NULL | The secondary object Id of the patient.(TbVisitOID) |
ContextType | VARCHAR(8) | NULL | What is the type of contextOid(EDvisit) |
RoutingRequestType | VARCHAR(8), | | Where is the request coming from Orders(ord) for referral, provider doc(pdoc) for visit end. |
RoutingRequestTypeOid | BIGINT | NOT NULL | OrderID or documentID that this request was generated by |
RoutingRequestDTime | DATETIME | NOT NULL | Date time that the master request was created |
RecipientCount | INT | NOT NULL | The number of recipients that will be receiving this routing request. |
RecipientSuccessCnt | INT | NULL | Number of recipients that the artifact was delivered to successfully |
RecipientFailureCnt | INT | NULL | Number of recipients that the artifact was NOT delivered to successfully |
RequestedByStaffId | INT | NOT NULL | The person who initiated the original request for artifact to be routed. |
HasFailure | BIT | NULL | 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) |
RequestStatus | VARCHAR(16) | NULL | Overall Status of the request,(Pending, Transmitted, Complete) |
IsDeleted | BIT | NOT NULL | Has the request been deleted.(0 - No, 1 - Yes) |
LastStatusUpdateDtime | DATETIME | NULL | Last updated date time that a status about the request was received. |
LastCngDTime | DATETIME | NOT NULL | Indicates the current Universal Time Coordinate that this record was changed. |