SIL processing

Management Information

Run one full year at a time. We start up in Fall, and then add spring and summer terms as we go.

Term startup

  1. Create a new directory in h:\data\sil with the term year (e.g. su05)
  2. Run h:\sas\sil\getxlistcrns.sas
    1. Modify filename for output file
    2. Modify checkterm
    3. Load output to SQL server using package crs_xlist (Modify connection 1 name.)
  3. Run h:\sas\sil\getsubjects.sas
    1. Update the file manually with any missing data.
    2. (Easiest is to look at last term’s subject file.
  4. Copy current term getcrstape.sas
    1. update input/output files for new term.
    2. Add new term dates
  5. Update getarscrs.sas
    1. add new term to input crnsum file (will come from getcrstape)
    2. if needed, modify session, instr, sil to hit multiple years
  6. Update getSILdata.sas to have new term, remove old term
  7. For class rosters: Update rosterstudents.sas to have new term, remove old term
  8. Update batch file that runs daily to include the new term you are running (actually, once we have done a full year, no need to update this, it will just keep going for fall, spring summer terms )
  9. After first run next morning, check output logs, Instructor Class roster site, and SIL site. New term should be added to the drop downs automatically.
  10. At the end of the current term, after grades are in, you should change the default term in j:\sil\roster.asp and j:\sil\default.asp to be the new term.

Data flow diagrams of the programs