Freshman Report

This FOCEXEC displays a list of students broken out by high school who are recent graduates and who have completed their first term of college. This "freshman report" as it is called is a legal requirement in South Carolina. I can imagine the wide range of emotions that this report gets from the high school educators (cheers, shock from disbelief, pink slips,...). :-) I included this one since it is a bit complex (and hopefully helpful). Finally, check out this case study for information on the technique used in the DECODE statement.