6/28/08 for 08EW6
All Lists Updated
Daily by 6am
Master Select List
The color legend below describes how collect Master Select List information.
|
Table Color Legend: |
| Tan colored rows contain SAVEDLISTS description. |
| White rows contain code used to create the SAVEDLISTS. |
| Gold colored rows contain SAVEDLISTS names. |
|
* Select list of Students registered at least 1X in last year. |
SELECT STUDENT.TERMS WITH STTR.TERM = '07FADAY''08SPDAY' '08TW4''07TW4B''07TW1' '08TW2''08TW3' '08EW6''08EW5''08EW4''08EW3''07EW2''07EW1' '07SW1' '08SW2' '08SW3' |
| SAVE.LIST N19.ALL.CURRENT.STTR |
| GET.LIST N19.ALL.CURRENT.STTR SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT |
| SAVE.LIST N19.DCR.LAST.YR.REG |
| * Select list of all Students registered in next future terms. |
| SELECT STUDENT.TERMS WITH STTR.TERM = '08FADAY' '08TW1''08TW4B' '08EW1' '08SW1' >SAVE.LIST N19.DCR.ALL.FUTURE.STTR GET.LIST N19.DCR.ALL.FUTURE.STTR >SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT |
| SAVE.LIST N19.DCR.FUTURE.TERM.REG |
| * Select list for Currently registered day students. |
|
SELECT COURSE.SECTIONS WITH SEC.TERM = '08SPDAY' |
| SAVE.LIST N19.DCR.CURRENT.DAY.STU |
| * Select list for SAS Dept reporting -current FT MAN day students. |
| GET.LIST N19.DCR.CURRENT.DAY.STU >SELECT STUDENTS WITH STU.CURRENT.TYPE = 'CU' 'UD' >SELECT STUDENTS WITH STU.CURRENT.HOME.LOCATION = 'MAN' >SELECT STUDENTS WITH STU.RESIDENCY.STATUS = '' 'NDD' 'NDSD' 'NDUD' 'INRES' |
| SAVE.LIST N19.DCR.CURRENT.SAS.DAY |
| * Select list for SAS Dept current FT MAN day NEW students. |
| GET.LIST N19.DCR.CURRENT.SAS.DAY >SELECT STUDENTS WITH STU.START.TERM = '08SPDAY' SELECT.ONLY |
| SAVE.LIST N19.DCR.CURRENT.SAS.DAY.NEW |
| * Select list of accepted domestic day applicants with paid deposits |
| SELECT APPLICATIONS WITH APPL.START.TERM = '08FADAY' WITH APPL.DATE NE '' WITH APPL.STUDENT.TYPE = 'CU' 'UD' WITH APPL.ADMIT.STATUS = 'FR''FS''FT''TR''RE' 'FH' 'TI' 'RT' 'TH' WITH APPL.STATUS = 'AP' WITH APPL.CURRENT.STATUS NE 'WP' WITH APPL.CURRENT.STATUS NE 'PP' >SAVE.LIST N19.DCR.PAID.ACCEPTED.DAY.APPLICATIONS GET.LIST N19.DCR.PAID.ACCEPTED.DAY.APPLICATIONS >SELECT APPLICATIONS SAVING UNIQUE APPL.APPLICANT SELECT.ONLY |
| SAVE.LIST N19.DCR.PAID.ACCEPTED.DAY.APPLICANTS |
| * Select list for prior term registered day students. |
| GET.LIST N19.DCR.ALL.CURRENT.STTR >SELECT STUDENT.TERMS WITH @ID LIKE '...07FADAY...' >SELECT STUDENT.TERMS WITH STTR.ACTIVE.CRED GT '0' SAVING STTR.STUDENT >SELECT STUDENTS WITH STU.CURRENT.TYPE NE 'CE' |
| SAVE.LIST N19.DCR.PRIOR.DAY.STU |
| * Select list of residents in day program. |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '08SPDAY' '08EW6' WITH RMAS.CURRENT.STATUS = 'A' SAVING RMAS.PERSON.ID |
| SAVE.LIST N19.DCR.CURRENT.DAY.RESIDENT |
| * Select list of residents in GSB or CED programs. |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '08TW4' '08SW3' WITH RMAS.CURRENT.STATUS = 'A' SAVING RMAS.PERSON.ID |
| SAVE.LIST N19.DCR.CURRENT.GSB.RESIDENT |
| * Merge two residents lists to get total residents. |
| GET.LIST N19.DCR.CURRENT.DAY.RESIDENT TO 1 GET.LIST N19.DCR.CURRENT.GSB.RESIDENT TO 2 MERGE.LIST 1 UNION 2 |
| SAVE.LIST N19.DCR.ALL.CURRENT.RESIDENT |
| * Select list for current day school commuter students. |
| GET.LIST N19.DCR.CURRENT.DAY.STU TO 1 GET.LIST N19.DCR.CURRENT.DAY.RESIDENT TO 2 MERGE.LIST 1 DIFF 2 |
| SAVE.LIST N19.DCR.CURRENT.DAY.COMMUTER |
| * Select list of current registered graduate students. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08TW4' '08SW3' >SELECT COURSE.SECTIONS SAVING UNIQUE SEC.STUDENTS >SELECT STUDENT.COURSE.SEC SAVING SCS.STUDENT.ACAD.CRED >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'W' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'D' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'X' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'C' >SELECT STUDENT.ACAD.CRED WITH STC.ACAD.LEVEL NE 'UG' >SELECT STUDENT.ACAD.CRED SAVING UNIQUE STC.PERSON.ID >SELECT STUDENTS WITH STU.CURRENT.TYPE NE 'CE' |
| SAVE.LIST N19.DCR.CURRENT.GSB.ALL |
| * Select list of prior term registered graduate students. |
| GET.LIST N19.DCR.ALL.CURRENT.STTR >SELECT STUDENT.TERMS WITH STTR.ACAD.LEVEL NE 'UG' WITH @ID LIKE '...08TW3...' '...08SW2...' >SELECT STUDENT.TERMS WITH STTR.ACTIVE.CRED GT '0' SAVING UNIQUE STTR.STUDENT |
| SAVE.LIST N19.DCR.PRIOR.GSB |
| * Select all currently registered GSB Manchester students. |
| GET.LIST N19.DCR.CURRENT.GSB.ALL >SELECT STUDENTS WITH STU.CURRENT.HOME.LOCATION = 'MAN' |
| SAVE.LIST N19.DCR.CURRENT.GSB.MAN |
| * Above list soon to be known as: N19.DCR.CURRENT.GR.MAN |
| * Also created in the same manner: |
| N19.DCR.CURRENT.GR.BRU N19.DCR.CURRENT.GR.DED N19.DCR.CURRENT.GR.LAC N19.DCR.CURRENT.GR.NAS N19.DCR.CURRENT.GR.POR N19.DCR.CURRENT.GR.SAL |
| * Select list of currently registered CE students. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08EW6' >SELECT COURSE.SECTIONS SAVING UNIQUE SEC.STUDENTS >SELECT STUDENT.COURSE.SEC SAVING SCS.STUDENT.ACAD.CRED >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'W' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'D' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'X' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'C' >SELECT STUDENT.ACAD.CRED SAVING UNIQUE STC.PERSON.ID >SELECT STUDENTS WITH STU.CURRENT.TYPE = 'CE' |
| SAVE.LIST N19.DCR.CURRENT.CE.STU |
| Select all currently registered CE students for DED. |
| GET.LIST N19.DCR.CURRENT.CE.STU >SELECT STUDENTS WITH STU.CURRENT.HOME.LOCATION = 'DED' |
| SAVE.LIST N19.DCR.CURRENT.CE.DED |
| * Also created in the same manner: |
| N19.DCR.CURRENT.CE.BRU N19.DCR.CURRENT.CE.LAC N19.DCR.CURRENT.CE.MAN N19.DCR.CURRENT.CE.NAS N19.DCR.CURRENT.CE.POR N19.DCR.CURRENT.CE.SAL |
| * Select all prior term registered CE students. |
| GET.LIST N19.DCR.ALL.CURRENT.STTR >SELECT STUDENT.TERMS WITH STTR.CURRENT.TYPE = 'CE' >SELECT STUDENT.TERMS WITH STTR.TERM = '08EW5' >SELECT STUDENT.TERMS WITH STTR.ACTIVE.CRED GT '0' SAVING UNIQUE STTR.STUDENT |
| SAVE.LIST N19.DCR.PRIOR.CE.STU |
| * Select all currently registered Manchester CE students. |
| GET.LIST N19.DCR.CURRENT.CE.STU >SELECT STUDENTS WITH STU.CURRENT.HOME.LOCATION = 'MAN' |
| SAVE.LIST N19.DCR.CURRENT.MAN.CE.STU |
| * Select list of all registered students. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08SPDAY' '08TW4''08EW6''08SW3' >SELECT COURSE.SECTIONS SAVING UNIQUE SEC.STUDENTS >SELECT STUDENT.COURSE.SEC SAVING SCS.STUDENT.ACAD.CRED >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'W' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'D' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'X' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'C' >SELECT STUDENT.ACAD.CRED SAVING UNIQUE STC.PERSON.ID |
| SAVE.LIST N19.DCR.ALL.REG.STUDENTS |
| * Select list of all students registered in Manchester Sections. |
|
SELECT COURSE.SECTIONS WITH SEC.TERM = '08SPDAY' '08TW4' '08EW6' '08SW3' |
| SAVE.LIST N19.DCR.CUR.REG.IN.MAN.CRS |
| * Select list of current and future registered students for Higher One. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08SPDAY' '08TW4''08EW6''08SW3' '08FADAY' '08TW4B''08TW1' '08EW1''08SW1' >SELECT COURSE.SECTIONS WITH SEC.SUBJECT NE 'SNHU' >SELECT COURSE.SECTIONS SAVING UNIQUE SEC.STUDENTS >SELECT STUDENT.COURSE.SEC SAVING SCS.STUDENT.ACAD.CRED >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'W' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'D' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'X' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'C' >SELECT STUDENT.ACAD.CRED SAVING UNIQUE STC.PERSON.ID |
| SAVE.LIST N19.DCR.ALL.STU.HIGHER1.CARD |
| * Select all CE students that are enrolled in Day school class. |
| GET.LIST N19.DCR.ALL.CURRENT.STTR >SELECT STUDENT.TERMS WITH STTR.TERM = '08SPDAY' WITH STTR.CURRENT.TYPE = 'CE' SAVING UNIQUE STTR.STUDENT |
| SAVE.LIST N19.DCR.CURRENT.CE.IN.DAY |
| * Selects list of UD students that are enrolled in CE 8Wk classes. |
| GET.LIST N19.DCR.ALL.CURRENT.STTR >SELECT STUDENT.TERMS WITH STTR.TERM = '08EW6' >SELECT STUDENT.TERMS WITH STTR.STU.CURRENT.TYPE = 'UD' >SELECT STUDENT.TERMS WITH STTR.ACTIVE.CRED GT '0' SAVING UNIQUE STTR.STUDENT >SAVE.LIST N19.DCR.CURRENT.REG.IN.CE.TERM GET.LIST N19.DCR.CURRENT.REG.IN.CE.TERM >SELECT STUDENTS WITH STU.CURRENT.TYPE = 'UD' SAVING STUDENTS.ID |
| SAVE.LIST N19.DCR.CURRENT.UD.IN.CE |
| * Selects list of Future CE students. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08EW1' SAVING UNIQUE SEC.STUDENTS >SELECT STUDENT.COURSE.SEC SAVING SCS.STUDENT.ACAD.CRED SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'W' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'D' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'X' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'C' SELECT.ONLY >SELECT STUDENT.ACAD.CRED SAVING UNIQUE STC.PERSON.ID SELECT.ONLY >SELECT STUDENTS WITH STU.CURRENT.TYPE = 'CE' |
| SAVE.LIST N19.DCR.FUTURE.CE.STU |
| * Selects list of Future Day students. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08FADAY' >SELECT COURSE.SECTIONS SAVING UNIQUE SEC.STUDENTS SELECT.ONLY >SELECT STUDENT.COURSE.SEC SAVING SCS.STUDENT.ACAD.CRED' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'W' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'D' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'X' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'C' SELECT.ONLY >SELECT STUDENT.ACAD.CRED SAVING UNIQUE STC.PERSON.ID SELECT.ONLY |
| SAVE.LIST N19.DCR.FUTURE.DAY.STU |
| * SAS Dept reporting of Future Day students. |
| GET.LIST N19.DCR.FUTURE.DAY.STU >SELECT STUDENTS WITH STU.CURRENT.TYPE = 'CU''UD' >SELECT STUDENTS WITH STU.CURRENT.HOME.LOCATION = 'MAN' >SELECT STUDENTS WITH STU.RESIDENCY.STATUS = '' 'NDD' 'NDSD' 'NDUD' 'INRES' |
| SAVE.LIST N19.DCR.FUTURE.SAS.DAY |
| * Selects list of NEW Future Day students. |
| GET.LIST N19.DCR.FUTURE.SAS.DAY >SELECT STUDENTS WITH STU.START.TERM = '08FADAY' |
| SAVE.LIST N19.DCR.FUTURE.SAS.NEW |
| * Selects list of Future Day Residents. |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '08FADAY' WITH RMAS.CURRENT.STATUS = 'A' SAVING RMAS.PERSON.ID |
| SAVE.LIST N19.DCR.FUTURE.DAY.RESIDENT |
| * Selects list of NEW Future day residents. |
| GET.LIST N19.DCR.FUTURE.DAY.RESIDENT >SELECT STUDENTS WITH STU.START.TERM = '08FADAY' SELECT.ONLY |
| SAVE.LIST N19.DCR.FUTURE.NEW.RESIDENT |
| * Selects list of Future Commuters - two different lists. |
| GET.LIST N19.DCR.FUTURE.SAS.DAY TO 1 GET.LIST N19.DCR.FUTURE.DAY.RESIDENT TO 2 MERGE.LIST 1 DIFF 2 |
| SAVE.LIST N19.DCR.FUTURE.SAS.DAY.COMMUTER |
| GET.LIST N19.DCR.FUTURE.SAS.NEW TO 1 GET.LIST N19.DCR.FUTURE.NEW.RESIDENT TO 2 MERGE.LIST 1 DIFF 2 |
| SAVE.LIST N19.DCR.FUTURE.SAS.NEW.COMMUTER |
| * Selects list of Future GR students. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08TW1' '08TW4B' '08SW1' >SELECT COURSE.SECTIONS SAVING UNIQUE SEC.STUDENTS SELECT.ONLY >SELECT STUDENT.COURSE.SEC SAVING SCS.STUDENT.ACAD.CRED' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'W' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'D' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'X' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'C' SELECT.ONLY >SELECT STUDENT.ACAD.CRED WITH STC.ACAD.LEVEL NE 'UG' >SELECT STUDENT.ACAD.CRED SAVING UNIQUE STC.PERSON.ID SELECT.ONLY >SELECT STUDENTS WITH STU.CURRENT.TYPE NE 'CE' SELECT.ONLY |
| SAVE.LIST N19.DCR.FUTURE.GR.STU |
| * All CE Faculty, for UG, then GR level, regardless of faculty status. |
| SELECT COURSE.SECTIONS WITH SEC.STUDENTS WITH SEC.TERM = '08EW6' WITH SEC.LOCATION = 'DED''BRU''LAC' 'MAN''NAS''POR''SAL' SAVING UNIQUE SEC.FIRST.FACULTY |
| SAVE.LIST N19.DCR.ALL.CE.UG.FACULTY |
| SELECT COURSE.SECTIONS WITH SEC.STUDENTS WITH SEC.TERM = '08TW4' '08SW3' WITH SEC.LOCATION = 'BRU' 'DED''LAC''MAN''NAS''POR''SAL' SAVING UNIQUE SEC.FIRST.FACULTY |
| SAVE.LIST N19.DCR.ALL.CE.GR.FACULTY |
| * Select list for Students currently registered at Brunswick center courses. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08EW6' '08TW3' '08SW3' |
| >SAVE.LIST N19.DCR.CURRENT.CE.SECTIONS |
| GET.LIST N19.DCR.CURRENT.CE.SECTIONS >SELECT COURSE.SECTIONS WITH SEC.LOCATION = 'BRU' SAVING UNIQUE SEC.STUDENTS >SELECT STUDENT.COURSE.SEC SAVING SCS.STUDENT.ACAD.CRED >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'W' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'D' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'X' >SELECT STUDENT.ACAD.CRED WITH STC.CURRENT.STATUS NE 'C' >SELECT STUDENT.ACAD.CRED SAVING UNIQUE STC.PERSON.ID |
| SAVE.LIST N19.DCR.CUR.REG.IN.BRU.CRS |
| * Also created in the same manner: |
| N19.DCR.CUR.REG.IN.DED.CRS N19.DCR.CUR.REG.IN.LAC.CRS N19.DCR.CUR.REG.IN.NAS.C RS N19.DCR.CUR.REG.IN.POR.CRS N19.DCR.CUR.REG.IN.SAL.CRS |
| *Selects list of Deceased students. |
| SELECT STUDENT.RESTRICTIONS WITH STR.RESTRICTION = 'DC'SAVING UNIQUE STR.STUDENT |
| SAVE.LIST N19.DCR.DECEASED |
| *Selects list of the No Mail List. |
| SELECT PERSON WITH MAIL.RULES = 'NC''NM' |
| SAVE.LIST N19.DCR.NO.MAIL |
| *Select lists of Faculty and Staff. |
| N19.DCR.DAY.ADJUNCT.FACULTY N19.DCR.CE.ADJUNCT.FACULTY N19.DCR.GRAD.ADJUNCT.FA CULTY N19.DCR.ALL.ADJUNCT.FACULTY N19.DCR.FULLTIME.FACULTY N19.DCR.ALL.FACULTY N19.DCR.PRO FESSIONAL.STAFF N19.DCR.OPERATIONAL.STAFF N19.DCR.MONTHLY.PT.STAFF N19.DCR.GT20HOUR.PT.STAFF N19.DCR .LT20HOUR.PT.STAFF N19.DCR.CASUAL.PT.STAFF N19.DCR.TEMPORARY.PT.STAFF N19.DCR.VERMONT.FACULTY N19.DCR.A LL.STAFF N19.DCR.ALL.FACULTY.AND.STAFF |
| *And CE lists selected on current terms: |
| N19.DCR.ALL.CE.UG.FACULTY N19.DCR.ALL.CE.GR.FACULTY |
| *List of Entire SNHU Community, which is a combination of these lists: N19.DCR.LAST.YR.REG, N19.DCR.FUTURE.TERM.REG, N19.DCR.PAID.ACCEPTED.DAY.APPLICANTS, N19.DCR.ALL.FACULTY.AND.STAFF: |
| N19.DCR.ENTIRE.SNHU.COMMUNITY |