I am a campus rep for the college program. As others have said, I have seen people with all different abilities on the CP. I have even heard of CPs with dogs. Make sure you mention it at some point during the interview. You will be placed in your specific role and location after the interview. They will tell you role (e.g., attractions, merchandise, etc.) but not your location because the location may change based on operational need. However, they will probably already know where you are going. You won't know your exact location until about the second day, and if you spring a SD on them at the last moment they may be left scrambling if your original location would not be compatible with a SD.
Depending on the type of SD, I'm going to advise not doing attractions. With attractions you are around a lot of moving parts and need to be able to evacuate an attraction should it go down. It's also one of the more physically demanding jobs that we have. I have a feeling that with an SD, merch or character attendant would be your best choices. In the end, you know your and your SD's limits, so make surethat you read each role description carefully so that you don't end up in a role that is unsuitable to your needs.