update email template logic for active assignments only