No, unfortunately just paying it will not remove it from your CR.  It can stay the entire time permitted by law which is 7 - 7.5 years past the DOFD.

Also, paid and unpaid collections and CO are looked at the same by FICO.

Does this have a CA attached to it?

What is the DOFD and the SOL?