8/30/08 for 08EW1 & 08FADAY
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 = '08FADAY''08SPDAY' '08TW4''08TW4B''07TW1' '08TW2''08TW3' '08EW6''08EW5''08EW4''08EW3''07EW2''08EW1' '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 = '09SPDAY' '08TW1' '08EW2' '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 = '08FADAY' |
| 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 = '08FADAY' 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 = '09SPDAY' 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 '...08SPDAY...' >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 = '08FADAY' '08EW1' 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' '08TW4B''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''08TW4B' '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 = '08EW1' >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 = '08EW6' >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 = '08FADAY' '08TW4''08TW4B' '08EW1''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 = '08FADAY' '08TW4''08TW4B' '08EW1' '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 = '08FADAY' '08TW4''08TW4B' '08EW1''08SW3' '09SPDAY' '08TW1' '08EW2''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 = '08FADAY' 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 = '08EW1' >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 = '08EW2' 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 = '09SPDAY' >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 = '09SPDAY' |
| SAVE.LIST N19.DCR.FUTURE.SAS.NEW |
| * Selects list of Future Day Residents. |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '09SPDAY' 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 = '09SPDAY' 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 |
| * Select list of Future students registered in MAN sections. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '09SPDAY' '08EW2' '08TW1' '08SW1' SELECT COURSE.SECTIONS WITH SEC.LOCATION = 'MAN' 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.FUT.REG.IN.MAN.CRS |
| * Selects list of Future GR students. |
| SELECT COURSE.SECTIONS WITH SEC.TERM = '08TW1' '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 = '08EW1' 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''08TW4B' '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 = '08EW1' '08TW4' '08TW4B' '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 |
| * iPARQ Select current EASTCL and EASTHW side residents. |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '08FADAY' '08EW1' '08TW4' '08SW3' WITH RMAS.CURRENT.STATUS = 'A' WITH RMAS.BLDG = 'CN' 'LN' >SELECT ROOM.ASSIGNMENT SAVING UNIQUE RMAS.PERSON.ID SELECT.ONLY |
| SAVE.LIST N19.DCR.CURRENT.EASTCL.RESIDENTS |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '08FADAY' '08EW1' '08TW4' '08SW3' WITH RMAS.CURRENT.STATUS = 'A' WITH RMAS.BLDG = 'HN' 'WR' >SELECT ROOM.ASSIGNMENT SAVING UNIQUE RMAS.PERSON.ID SELECT.ONLY |
| SAVE.LIST N19.DCR.CURRENT.EASTHW.RESIDENTS |
| * iPARQ Select Future EASTCL & EASTHW side residents. |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '09SPDAY' '08EW2' '08TW1' '08SW1' WITH RMAS.CURRENT.STATUS = 'A' WITH RMAS.BLDG = 'CN' 'LN' >SELECT ROOM.ASSIGNMENT SAVING UNIQUE RMAS.PERSON.ID SELECT.ONLY |
| SAVE.LIST N19.DCR.FUTURE.EASTCL.RESIDENTS |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '09SPDAY' '08EW2' '08TW1' '08SW1' WITH RMAS.CURRENT.STATUS = 'A' WITH RMAS.BLDG = 'HN' 'WR' >SELECT ROOM.ASSIGNMENT SAVING UNIQUE RMAS.PERSON.ID SELECT.ONLY |
| SAVE.LIST N19.DCR.FUTURE.EASTHW.RESIDENTS |
| * iPARQ Merge Current & Future east side resident lists.. |
| GET.LIST N19.DCR.CURRENT.EASTCL.RESIDENTS TO 1 GET.LIST N19.DCR.FUTURE.EASTCL.RESIDENTS TO 2 MERGE.LIST 1 UNION 2 TO 3 SAVE.LIST N19.DCR.ALL.EASTCL.RESIDENTS FROM 3 GET.LIST N19.DCR.CURRENT.EASTHW.RESIDENTS TO 1 GET.LIST N19.DCR.FUTURE.EASTHW.RESIDENTS TO 2 MERGE.LIST 1 UNION 2 TO 3 SAVE.LIST N19.DCR.ALL.EASTHW.RESIDENTS FROM 3 GET.LIST N19.DCR.ALL.EASTCL.RESIDENTS TO 1 GET.LIST N19.DCR.ALL.EASTHW.RESIDENTS TO 2 MERGE.LIST 1 UNION 2 TO 3 |
| SAVE.LIST N19.DCR.ALL.EAST.RESIDENTS FROM 3 |
| * iPARQ Select list of current West side residents. |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '08FADAY' '08EW1' '08TW4' '08SW3' WITH RMAS.CURRENT.STATUS = 'A' WITH RMAS.BLDG NE 'CN' WITH RMAS.BLDG NE 'LN' WITH RMAS.BLDG NE 'HN' WITH RMAS.BLDG NE 'WR' >SELECT ROOM.ASSIGNMENT SAVING UNIQUE RMAS.PERSON.ID SELECT.ONLY |
| SAVE.LIST N19.DCR.CURRENT.WEST.RESIDENTS |
| * iPARQ Select list of Future West side residents. |
| SELECT ROOM.ASSIGNMENT WITH RMAS.TERM = '09SPDAY' '08EW2' '08TW1' '08SW1' WITH RMAS.CURRENT.STATUS = 'A' WITH RMAS.BLDG NE 'CN' WITH RMAS.BLDG NE 'LN' WITH RMAS.BLDG NE 'HN' WITH RMAS.BLDG NE 'WR' >SELECT ROOM.ASSIGNMENT SAVING UNIQUE RMAS.PERSON.ID SELECT.ONLY |
| SAVE.LIST N19.DCR.FUTURE.WEST.RESIDENTS |
| * iPARQ Merge Current and Future West side resident lists.. |
| GET.LIST N19.DCR.CURRENT.EAST.RESIDENTS TO 1 GET.LIST N19.DCR.FUTURE.EAST.RESIDENTS TO 2 MERGE.LIST 1 UNION 2 TO 3 |
| SAVE.LIST N19.DCR.ALL.WEST.RESIDENTS FROM 3 |
| *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 |