Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
LetterOID | int | NOT NULL | Foreign key to HLetterInstance. |
DocumentRecipientID | varchar(60) | NOT NULL | ID of the document recipient. |
SendDate | smalldatetime | NOT NULL | Time when the letter was sent. |
SendFormat | varchar(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_Level | Varchar(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. |
CopiesCount | SmallInt | Not Null | Total count of clinical letter copies sent. Default value is set to 1. |