• The value is null if the student is not an athlete
• The value is ‘A’ if the student is an athlete.

This data comes from a mySql database that runs on mdsdata and is populated by a job over at NWRDC that pulls from a VSAM file. Donny loads the data into the database and then I wrote a perl script that pulls that data and sets the fsuEduStuAthlete flag. Here is the SQL I use:

select SSN from studentDatabaseMaster.studentDatabaseMaster where FOOT_STATUS IN ('A', 'I') or BASE_STATUS IN ('A', 'I') or BSKT_STATUS IN ('A', 'I') or TRCK_STATUS IN ('A', 'I') or GOLF_STATUS IN ('A', 'I') or TENS_STATUS IN ( 'A', 'I') or SWIM_STATUS IN ('A', 'I') or VOLY_STATUS IN ('A', 'I') or SOCCER_STATUS IN ('A', 'I') or SOFTBALL_STATUS IN ('A', 'I') or ROWING_STATUS IN ('A', 'I') or CROSSCNTY_STATUS IN ('A', 'I')

Thanks,

---JON