Adding an auto recipient to a department and document type

Use the attached sql script to add an automatic recipient to a department and document type. If the trigger has already been added and you want to modify it expand the Activity table and expand triggers. Right click on the autorecipient trigger and click modify. If the trigger does not exist, create a New Query and copy and paste the attached query. You will need to update the site code and change the department and document type ID's. For multiple document types you can use the below code: For a single document type use the below code: Valid Department should always be set to 1 Recipient ID is the Doctor Code Recipient: Main Recipient = 1 | Copy To Recipient = 0