« May 2008 | Main | July 2008 »

June 20, 2008

Another Research Table (SWIURCH) change

I added a new column called ESL to the research table to help identify students that are in the ESL program. The values are 'Y" if they are ESL students (only taking ESL courses), 'N' if they are not.

Posted by soukupm at 10:19 AM | Comments (0)

June 13, 2008

Research Table (SWIURCH) change

I added two new columns to the research table script: citz (citizen code) and ofax_hrs (dual enrollment non-western credit hours ).

Posted by soukupm at 3:15 PM | Comments (0)

June 4, 2008

New Job Submission: SZRNADV

I created a new job submission this week called SZRNADV that lists current advisees that have a null ADVR code (advisor code) in SGRADVR. The advising office will use this report to fix students that are missing these ADVR codes.

Input: term_code (for enrollment)
Output: student vnum,student last name,student first name, major, advisor vnum,advisor last name,advisor first name

Posted by soukupm at 11:18 AM | Comments (0)