Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSendLetter This table stores the information for all the clinical letters which are cosigned.
Column Name Column Datatype Column Null Option Column Comment
LetterOIDintNOT NULL Foreign key to HLetterInstance.
DocumentRecipientIDvarchar(60)NOT NULL ID of the document recipient.
SendDatesmalldatetimeNOT NULL Time when the letter was sent.
SendFormatvarchar(4)NOT NULL Format of the letter to be sent. Allowable values:
ES - Electronically sending.
PR - Cosigned by physician.
BO - If the letter is sent both ways mentioned above.
ACK_LevelVarchar(20)Not Null The status of the letter when sending. Allowable values:
INPROG - Indicates letter sending is in progress.
ACK - Sending is successful.
ERR - If the letter sending failed.
CopiesCountSmallIntNot Null Total count of clinical letter copies sent. Default value is set to 1.

Return to Table-Index

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