Hi Alan,
I'm not sure what you mean about 2 fields for passed/failed - SCORM 1.2 has a var called "lesson_status" which can have any of the following values "passed,completed,failed,incomplete,browsed" - these values are set by your SCORM package and the report just displays whichever value has been set.
On entry to a SCORM package there are some radio buttons which allow the user to set whether to enter the SCORM in "browse" mode or "normal" mode - this is part of the SCORM standard however Moodle gives you the option to remove the "browse" button on the entry page. It's up to your SCORM package how to act in browse and normal modes.
The report should be showing the SCORM packages "lesson_status" value in the Sco Status field - what are the 2 values you are expecting to see?
I'm not sure why the SCORM reportbuilder source doesn't allow you to include course completion data but this may be something the Totara team could add in future?