Touchworks 26.1
[dbo].[Attachment_ActionHistory]
Print/Fax actions performed on attachments related to a referral order
| Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
|---|---|---|---|---|---|---|---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | Key to the Attachment_ActionHistory table | |
 ![Foreign Keys FK_Attachment_ActionHistory_ActivityHeaderID: [dbo].[Order_Activity_Header].ActivityHeaderID](../../../../Images/fk.png "Foreign Keys FK_Attachment_ActionHistory_ActivityHeaderID: [dbo].[Order_Activity_Header].ActivityHeaderID") | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Referral Order. Link to Order_Activity_Header.ID | ||
| AttachmentID | [dbo].[uniqueid] | 9 | NOT NULL | Attachment. Document/Result/Order header identifier | |||
| AttachmentType | char(3) | 3 | NOT NULL | Type of attachment REF/RS/MSG/DOC/SOC etc. | |||
| ActionType | char(1) | 1 | NOT NULL | P - Print, F- Fax, R - eReferral | |||
| ActionPerformedDTTM | datetime | 8 | NOT NULL | When action actually performed | |||
| FromUser | varchar(255) | 255 | NOT NULL | Which user performed faxing/printing, may vary in faxing | |||
| ToUser | varchar(255) | 255 | NULL allowed | Which user received information while faxing also capable of holding free text. | |||
| Details | varchar(500) | 500 | NULL allowed | Detsils. Fax# (or) Print server (or) Direct Address etc. | |||
| UserID | [dbo].[uniqueid] | 9 | NOT NULL | Logged in user who performed the action. Link to IDX_User.ID | ||
| SiteDE | [dbo].[dict_id] | 5 | NOT NULL | Site of logged in user. Link to Site_DE.ID. | ||
| CreatedDTTM | datetime | 8 | NOT NULL | (getdate()) | Data and time when the data was inserted / added. | ||
| DeliveryStatus | varchar(20) | 20 | NULL allowed | Final Status of the Processed Job | |||
| JobID | [dbo].[uniqueid] | 9 | NULL allowed | Job ID of Print / Fax Jobs Created in Print Queue |