Someone want to clarify something for me?

Is James Clayton in The Recruit NOC or is he a wash out that got used by a dirty CIA agent?

I watched it late last night and I know this question isn’t supposed to hang with you but it is hanging with me… Don’t know why for sure… I knew Al Pacino’s character was the dirty one but I wasn’t quite sure about the ending of the film….