In all likelihood, this will remain on your credit for the next 6 years or whatever the time is. The only thing that can change now is for Rogers to report to the credit bureaus the debt was settled which will show up on the notes for the rogers account on your credit report.
You can always ask Rogers if they are able to remove it or call Equifax or Transunion about this matter. But as I said, once an account goes into collections, it is most likely written off and rated as a 9, it will stay there for that period of 6 or 7 years. But as I said, consult about this with Rogers first and also the credit bureaus.