 |
 |
 |
 |
 |
| |
Aeries Query page.
This page is a resource for users to share their
queries with one another. Please forward your
favorite query statements to Eagle at support@aeries.com Thank you! NOTE:
Use your mouse to highlight the Query statement
(called STRING),
Right click with the mouse and select COPY, go
into your Aeries Query, use your mouse and
position the cursor into the statement area, right
click the mouse and select PASTE, then chose the
Query RUN command and see
the results. As
always, you can then run REPORT or LABELS to get a
nice output.
|
 |
| | | Name: | Class List for (Elementary Schools) |
 |
| | | Description: | Class list for Elementary Schools |
 |
| | | String: | LIST STU TCH STU.NM STU.GR STU.SX STU.PG STU.TL STU.FW STU.MW TCH.TE BY TCH.TE |
 |
| | | Notes: | |
 |
 |
| | | Name: | Print Labels for Contacts |
 |
| | | Description: | To print labels for Contacts identified with an 'A' in the mail tag to receive All Mailings
|
 |
| | | String: | LIST STU CON CON.NM \ 'RE:' STU.NM \ CON.AD \ CON.CY CON.ST CON.ZC IF CON.MT = A |
 |
| | | Notes: | Run this statement, when list appears use the X on the output to close, then click on LABELS to create the label format. |
 |
 |
| | | Name: | Parent / Student name differences |
 |
| | | Description: | Will yield a list of students and parents who have different names. |
 |
| | | String: | LIST STU PG LN IF PG ; LN |
 |
| | | Notes: | |
 |
 |
| | | Name: | Print Birthdays |
 |
| | | Description: | To print birthdays for a particular month, by teacher (Elementary Schools) |
 |
| | | String: | LIST STU TCH STU.NM STU.BD TCH.TE BY TCH.TE IF BD : 12/*/* |
 |
| | | Notes: | Close select query, click on Report and page break by teacher. |
 |
 |
| | | Name: | ADS code and dates of suspension |
 |
| | | Description: | List of students suspended with the ADS code and dates of suspension |
 |
| | | String: | LIST STU ADS STU.NM ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DS : |
 |
| | | Notes: | |
 |
 |
| | | Name: | ADS info for a specific disposition date |
 |
| | | Description: | List of students showing all ADS info for a specific disposition date |
 |
| | | String: | LIST STU ADS STU.NM STU.GR ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DD = 11/10/2004 |
 |
| | | Notes: | |
 |
 |
| | | Name: | ADS info for a specific disposition entry & date |
 |
| | | Description: | List of students with ADS info for a specific disposition entry for a specific disposition date
|
 |
| | | String: | LIST STU ADS STU.NM STU.GR ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DD = 11/10/2004 AND ADS.DS : "ASD" |
 |
| | | Notes: | |
 |
 |
| | | Name: | ADS list of students, who received a discipline transaction |
 |
| | | Description: | List of students with ADS info who received a discipline transaction on a specific date
|
 |
| | | String: | LIST STU ADS STU.NM STU.GR ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DT = 6/15/2005 |
 |
| | | Notes: | |
 |
 |
| | | Name: | ADS List identifying students by Student Number only |
 |
| | | Description: | List identifying students by SN only with all ADS info for any student whose disposition was suspension sorted by ADS code
|
 |
| | | String: | LIST STU ADS STU.SN ADS.DT ADS.CD ADS.DS ADS.DY ADS.DD ADS.ED BY ADS.CD IF ADS.DS : SUSP |
 |
| | | Notes: | |
 |
 |
| | | Name: | ADS info for any student whose disposition was suspension sorted by student number |
 |
| | | Description: | List identifying students by SN only with all ADS info for any student whose disposition was suspension sorted by student number
|
 |
| | | String: | LIST STU ADS STU.SN ADS.DT ADS.CD ADS.DS ADS.DY ADS.DD ADS.ED BY STU.SN IF ADS.DS : "SUSP" |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT code change |
 |
| | | Description: | Change to clear ATT code of "I" to a blank for all of the students in a specific class (section 7) for attendance period 1 on a specific date. |
 |
| | | String: | CHANGE STU SEC ATT ATT.A1 TO " " IF SEC.SE = 7 AND ATT.DT = 6/15/2005 AND ATT.A1 = I |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT data if student enter date is before 6/15/2005 ... |
 |
| | | Description: | List of student data and ATT data if their enter date is before 6/15/2005 OR their leave date was before or after 6/15/2005 BUT NOT INCLUDING 6/15/2005 sorted by the ATT tch# and the STU cns/tch# |
 |
| | | String: | LIST STU ATT STU.TG STU.NM STU.GR STU.CU ATT.TN STU.ED STU.LD ATT.DT ATT.CD BY ATT.TN STU.CU IF ATT.DT < 6/15/2005 AND ATT.CD = E OR ATT.CD = L AND ( ATT.DT < 6/15/2005 OR ATT.DT > 6/15/2005 ) |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT absence dates, calendar day#, enter/leave codes |
 |
| | | Description: | List of ATT absence dates, calendar day#, enter/leave codes, absence all day codes for a specific student
|
 |
| | | String: | LIST STU ATT STU.SN STU.TG STU.NM ATT.DT ATT.DY ATT.CD ATT.AL IF ATT.SN = 1234 |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT total 1st period absences |
 |
| | | Description: | Total 1st period absences (not including tardies) for a specific period of time
|
 |
| | | String: | TOTAL ATT IF A1 > " " AND A1 < Z AND A1 # T AND DT > 6/01/2005 AND DT < 6/15/2005 |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT list of absence entries for specific day |
 |
| | | Description: | List of student's absence entries for every period for a specific day with their home telephone number and parent's work numbers
|
 |
| | | String: | LIST STU ATT STU.SN STU.NM STU.GR STU.TL STU.MW STU.FW ATT.A0 ATT.A1 ATT.A2 ATT.A3 ATT.A4 ATT.A5 ATT.A6 ATT.A7 ATT.A8 ATT.A9 IF ATT.DT = 6/15/2005 |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT list with section number, date and code |
 |
| | | Description: | List of students with their section number, attendance date, attendance code (if any) from 1st period for a specific section on a specific date |
 |
| | | String: | LIST STU SEC ATT STU.SN STU.NM SEC.SE ATT.DT ATT.A1 IF SEC.SE = 7 AND ATT.DT = 6/15/2005 |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT total of all day absences between specific dates |
 |
| | | Description: | Total of all day absences between specific dates
|
 |
| | | String: | TOTAL ATT IF AL > " " AND DT > 6/01/2005 AND DT < 6/15/2005 |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT list of students with all day code |
 |
| | | Description: | List of students with their all day absence code if they were absent on a specific date sorted by grade
|
 |
| | | String: | LIST STU ATT STU.NM STU.GR ATT.DT ATT.AL BY STU.GR IF ATT.DT = 6/15/2005 AND ATT.AL > " " |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT absence code list if students were absent within a specific period of time |
 |
| | | Description: | List of students with their ATT absence code if they were absent within a specific period of time
|
 |
| | | String: | LIST STU ATT STU.LN STU.FN ATT.DT ATT.AL IF ATT.AL > "" AND ( ATT.DT > 6/01/2005 AND ATT.DT < 6/15/2005 ) |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT List of 9th grade students who were absent within the first 20 days |
 |
| | | Description: | List of 9th grade students who were absent within the first 20 days of the school calendar with their absence codes and any special program designation sorted by the special program code, attendance day and attendance code |
 |
| | | String: | LIST STU ATT STU.SN STU.NM STU.SP STU.GR ATT.DY ATT.AL BY STU.SP ATT.DY ATT.AL IF ATT.DY < 21 AND ATT.AL > " " AND STU.GR = 9 |
 |
| | | Notes: | |
 |
 |
| | | Name: | STU list of students with a blank line for data entry |
 |
| | | Description: | List of students with a blank line for data entry for each teacher's classes sorted by teacher name and period not including semester classes identified with an "S"
|
 |
| | | String: | LIST STU SEC MST CRS TCH STU.LN STU.FN STU.GR MST.PD MST.SM CRS.CO "_________________________" TCH.TE BY TCH.TE MST.PD IF MST.SM # S |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT possible no show list |
 |
| | | Description: | List to find students who show as entering and leaving on the same day (possible no show list if date is the 1st day of school)
|
 |
| | | String: | LIST STU ATT STU.LN STU.FN STU.TG ATT.DT ATT.CD IF ATT.CD = B |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT enter date and teacher number mismatches |
 |
| | | Description: | List to find teacher number mismatches between student counselor number (STU.CU) and attendance teacher number on the attendance enter date line |
 |
| | | String: | LIST STU ATT STU.SN STU.NM STU.CU ATT.DY ATT.CD ATT.TN IF STU.CU # ATT.TN AND ATT.CD = "E" |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT change teacher number to match enter or leave info. |
 |
| | | Description: | Change the students ATT teacher number to match the STU counselor/teacher number on either the ATT enter, leave or enter and leave date line |
 |
| | | String: | CHANGE STU ATT ATT.TN TO STU.CU IF ATT.CD = E OR ATT.CD = L OR ATT.CD = B |
 |
| | | Notes: | |
 |
 |
| | | Name: | ATT absence code list for specific day |
 |
| | | Description: | List of students with their ATT absence code for each day they were absent within a specific period of time sorted by absence code
|
 |
| | | String: | LIST STU ATT STU.SN STU.GR ATT.AL ATT.DT BY ATT.AL IF ATT.AL > " " AND ATT.DT > 6/01/2005 AND ATT.DT < 6/15/2005 |
 |
| | | Notes: | |
 |
 |
| | | Name: | CAR list with names and numbers of students' course changes |
 |
| | | Description: | List from CAR of student's names and student number whom have course changes after a certain date including CAR period, course number, section number and the CAR date |
 |
| | | String: | LIST STU CAR STU.SN STU.NM CAR.PD CAR.CN CAR.SE CAR.DS CAR.DE IF CAR.DS > 6/01/2005 OR CAR.DE > 6/15/2005 |
 |
| | | Notes: | |
 |
 |
| | | Name: | CAR enrollment data for first 20 days of school |
 |
| | | Description: | List by student number of students enrolled in a specific section with their start date and end date for a specific period of time (in this query for the first 20 days of school)
|
 |
| | | String: | LIST CAR SN CN DS DE D1 D2 SE IF SE = 169 AND D1 < 21 AND ( D2 = 0 OR D2 < 21 ) |
 |
| | | Notes: | |
 |
 |
| | | Name: | CAR totals for specific date range and specific section |
 |
| | | Description: | Total from CAR of students who were enrolled in a specific section for a specific period of time (in this query for the first 20 days of school)
|
 |
| | | String: | TOTAL CAR IF SE = 192 AND D1 < 21 AND D2 = 0 OR SE = 192 AND D1 < 21 AND D2 > 21 |
 |
| | | Notes: | |
 |
 |
| | | Name: | COD list of home language code and descriptions |
 |
| | | Description: | List of all home language descriptions from the code table
|
 |
| | | String: | LIST COD CD DE IF TC = STU AND FC = HL |
 |
| | | Notes: | |
 |
 |
| | | Name: | COL labels for specific colleges |
 |
| | | Description: | Labels for specific colleges addressed to Director of Admissions
|
 |
| | | String: | LIST COL NM \ |
 |
| | | Notes: | |
 |
 |
| | | Name: | CON lables to contacts |
 |
| | | Description: | Labels addressed to contacts re: students who are tagged with an A in the CON mail tag field
|
 |
| | | String: | LIST STU CON CON.NM \ "RE:" STU.NM \ CON.AD \ CON.CY CON.ST CON.ZC IF CON.MT = "A" |
 |
| | | Notes: | Select Run, select the X and then choose labels to put this in the label format. |
 |
 |
| | | Name: | CRS list of CSF codes |
 |
| | | Description: | List of courses with CSF code sorted by CSF code
|
 |
| | | String: | LIST CRS CN CO C1 BY C1 |
 |
| | | Notes: | |
 |
 |
| | | Name: | CRS list of courses by course number |
 |
| | | Description: | List of courses by course number, non academic/academic code, subject area codes, college prep code |
 |
| | | String: | LIST CRS CN CO NA S1 S2 S3 CP BY CN |
 |
| | | Notes: | |
 |
 |
| | | Name: | CRS change to add "A" before all course numbers |
 |
| | | Description: | Change to add "A" before all course numbers
|
 |
| | | String: | CHANGE CRS CN TO (( "A" + CN )) |
 |
| | | Notes: | |
 |
 |
| | | Name: | FRM change FRM.SN to match the STU.SN |
 |
| | | Description: | Change the FRM.SN to match the STU.SN if the free & reduced student # is blank |
 |
| | | String: | CHANGE STU FRM FRM.SN TO STU.SN IF FRM.SN = NULL |
 |
| | | Notes: | |
 |
 |
| | | Name: | GRD list all O's in citizenship from grade table |
 |
| | | Description: | List of students who have all O's in citizenship from the grade table ignoring homeroom which is period Zero |
 |
| | | String: | Query #1: SKIP STU GRD IF GRD.CI = NULL Query #2: SKIP STU GRD IF GRD.CI # O Query #3: LIST STU GRD CRS STU.LN STU.FN STU.GR GRD.PD CRS.CO GRD.CI IF GRD.PD > 0 |
 |
| | | Notes: | |
 |
 |
| | | Name: | GRD total number of comment 1 entries by code |
 |
| | | Description: | Total Number of GRD Comment 1 entries sorted by comment code
|
 |
| | | String: | TOTAL GRD C1 BY C1 |
 |
| | | Notes: | |
 |
 |
| | | Name: | GRD missing marks, Citizenship, Work Habits, Comment 1 |
 |
| | | Description: | List of students who have missing marks in either M2, Citizenship, Work Habits, Comment 1 sorted alpha by teacher
|
 |
| | | String: | LIST STU GRD TCH STU.NM STU.GR TCH.TE GRD.PD GRD.M2 GRD.CI GRD.WH GRD.C1 BY TCH.TE IF GRD.M2 = " " OR GRD.CI = " " OR GRD.WH = " " OR GRD.C1 = " " AND STU.TG = " " |
 |
| | | Notes: | |
 |
 |
| | | Name: | GRD list all grades by specific teacher |
 |
| | | Description: | List of students with all grades given by specific teachers sorted by teacher and course
|
 |
| | | String: | LIST STU GRD CRS TCH STU.SN STU.NM GRD.CN CRS.CO GRD.M1 GRD.M2 GRD.M3 GRD.M4 TCH.TE BY TCH.TE GRD.CN IF GRD.TN = ### OR GRD.TN = ### OR GRD.TN = ### |
 |
| | | Notes: | |
 |
 |
| | | Name: | GRD list M2 grades and course number if M2 is not blank |
 |
| | | Description: | List of all students with their grades from M2 and the course number if M2 is not blank
|
 |
| | | String: | LIST STU GRD STU.SN STU.NM GRD.CN GRD.M2 IF GRD.M2 > " " AND GRD.M2 < "Z" |
 |
| | | Notes: | |
 |
 |
| | | Name: | GRD total marks for specific courses by number |
 |
| | | Description: | Total of each grade mark given for specific courses sorted by crs# and mark
|
 |
| | | String: | TOTAL GRD CN MK BY CN MK IF CN = #### OR CN = #### |
 |
| | | Notes: | |
 |
 |
| | | Name: | GRD list of D, F, or I grades for selected courses |
 |
| | | Description: | List of D, F, or I grades for selected courses from GRD table
|
 |
| | | String: | LIST STU GRD STU.SN STU.NM STU.GR GRD.PD GRD.CN GRD.TN GRD.M1 BY GRD.CN IF ( GRD.CN = #### OR GRD.CN = #### OR GRD.CN = #### OR GRD.CN = #### ) AND ( GRD.M1 : D OR GRD.M1 : F OR GRD.M1 : I ) |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS grade for all courses 1st term 04-05 |
 |
| | | Description: | List of HIS students grades for all courses from the 1st term of the 04-05 year |
 |
| | | String: | LIST STU HIS CRS STU.SN STU.NM STU.GR HIS.CN CRS.CO HIS.TE HIS.YR HIS.MK IF HIS.TE = 1 AND HIS.YR = 04 |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS list student’s grade, mark, term, year if mark is higher than C for both terms |
 |
| | | Description: | List of students with their grade, their mark, the term and year from HIS whom received a mark higher than a C for both 1st and 2nd terms for a specific course number |
 |
| | | String: | 1.CHANGE STU QT TO “ “ 2.CHANGE STU HIS QT TO X IF HIS.CN = #### AND HIS.YR = 04 AND HIS.TE = 1 AND HIS.MK < C 3.CHANGE STU HIS STU.QT TO Z IF STU.QT = X AND HIS.CN = #### AND HIS.YR = 04 AND HIS.TE = 2 AND HIS.MK < C 4. LIST STU HIS STU.NM STU.GR HIS.YR HIS.TE HIS.CN HIS.MK IF STU.QT = Z AND HIS.CN = #### |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS list students with credits attempted, completed, GPA, rank, etc. |
 |
| | | Description: | List of students with their credits attempted, completed, total non-weighted GPA (cumulative from HIS), class rank, 10-12 academic non-weighted GPA (from HIS), UC rank, and class size, sorted by grade and class rank |
 |
| | | String: | LIST STU SN NM SX GR CA CC TPN CR CPN UR CS BY GR CR |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS data in a selected subject area sorted by grade |
 |
| | | Description: | List of students and their HIS data in a selected subject area sorted by grade. Also to identify students deficient in a given subject area
|
 |
| | | String: | LIST STU HIS CRS STU.NM STU.GR HIS.CN CRS.CO CRS.S1 HIS.MK HIS.CR HIS.CC BY STU.GR IF CRS.S1 = "E" |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS change credits completed to match the credits attempted |
 |
| | | Description: | Change the HIS credits completed to match the credits attempted if a student received a specific mark
|
 |
| | | String: | CHANGE HIS CC TO CR IF MK : "A" OR MK : "B" OR MK : "C" OR MK : "D" OR MK : "P" |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS list of student's various GPA's |
 |
| | | Description: | List of student's various GPA's, from HIS and the current marking period, along with class ranking and credit standing sorted by grade and class rank
|
 |
| | | String: | LIST STU SN NM GR TP CR CS GP CP UR CA CC GG GT GK GS BY GR CR |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS list of 9th and 10th graders who have an F in specific course |
 |
| | | Description: | List of current 9th and 10th graders from HIS file who have received an F in specific course numbers
|
 |
| | | String: | LIST STU HIS STU.SN STU.NM HIS.CN HIS.MK IF STU.GR < 11 AND HIS.MK : "F" AND ( HIS.CN = #### AND HIS.CN = #### OR HIS.CN = #### ) |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS list of students by teacher with math grades from spring term |
 |
| | | Description: | List for a current teacher of all of his students math grades from HIS showing grade course was taken, year, term sorted by student name, HIS year, HIS term |
 |
| | | String: | 1.KEEP STU SEC MST TCH IF MST.TN = ### AND MST.SM = "S" 2. LIST STU HIS CRS STU.LN STU.GR HIS.GR HIS.YR HIS.TE CRS.CO HIS.MK BY STU.NM HIS.YR HIS.TE IF HIS.S1 = B |
 |
| | | Notes: | |
 |
 |
| | | Name: | HIS list of student’s math marks and total math scores from STAR |
 |
| | | Description: | List of students math marks from HIS and their total math scores from STAR |
 |
| | | String: | LIST STU TST HIS CRS STU.NM CRS.CO HIS.YR HIS.TE HIS.MK TST.ID TST.TD TST.PT TST.SS BY STU.NM HIS.YR HIS.TE IF CRS.S1 = B AND TST.ID = CAT-6 AND TST.PT = 4 |
 |
| | | Notes: | |
 |
 |
| | | Name: | IMM List of students who need either their 2nd MMR shot or any of their hepatitis shots from IMM |
 |
| | | Description: | List of students who need either their 2nd MMR shot or any of their hepatitis shots from IMM
|
 |
| | | String: | LIST STU IMM STU.LN STU.FN IMM.A2 IMM.I1 IMM.I2 IMM.I3 IF IMM.A2 = NULL OR IMM.I1 = NULL OR IMM.I2 = NULL OR IMM.I3 = NULL |
 |
| | | Notes: | |
 |
 |
| | | Name: | IMM labels to parents |
 |
| | | Description: | Labels to parents of students who need either their 2nd MMR shot or any of their hepatitis shots from IMM
|
 |
| | | String: | LIST STU IMM STU.PG \ |
 |
| | | Notes: | |
 |
 |
| | | Name: | LKR all lockers in the locker file to students no longer in STU file |
 |
| | | Description: | List that shows all lockers in the locker file assigned to student numbers which are no longer in the STU file, sorted by locker number |
 |
| | | String: | LIST LKR STU LKR.LK LKR.SN STU.SN STU.GR STU.LK BY LKR.LK IF STU.SN = NULL |
 |
| | | Notes: | |
 |
 |
| | | Name: | LKR change locker file SN to 0 for students no longer in STU file |
 |
| | | Description: | Change the locker file SN to 0 for those lockers with student numbers no longer in the student file
|
 |
| | | String: | CHANGE LKR STU LKR.SN TO 0 IF STU.SN = NULL |
 |
| | | Notes: | |
 |
 |
| | | Name: | LKR list for unassigned lockers |
 |
| | | Description: | List to show all unassigned lockers and their combinations
|
 |
| | | String: | LIST LKR LK CM SN BY LK IF SN = 0 |
 |
| | | Notes: | |
 |
 |
| | | Name: | LKR change student numbers to match |
 |
| | | Description: | Change to have student number in the locker table match the student number in STU data locker field
|
 |
| | | String: | CHANGE LKR STU LKR.SN TO STU.SN IF STU.LK > " " |
 |
| | | Notes: | |
 |
 |
| | | Name: | MST labels |
 |
| | | Description: | Labels for informational purposes for 1st period, fall semester teachers: custom info on 1st line, student name on 2nd, MST section number, STU grade and MST period on 3rd, TCH name and MST room# on 4th sorted by teacher name |
 |
| | | String: | LIST STU SEC MST TCH "ARENA 06/15/2005" \ STU.NM \ "SEC:" MST.SE "GRADE:" STU.GR "PD:" MST.PD \ "TCH:" TCH.TE "RM" MST.RM BY TCH.TE IF MST.SM = "F" AND MST.PD = 1 |
 |
| | | Notes: | |
 |
 |
| | | Name: | MST list of students not in a specific course |
 |
| | | Description: | List of students who are not in a specific course sorted by grade
|
 |
| | | String: | 1.SKIP STU SEC MST IF MST.CN = #### 2. LIST STU SN LN FN GR BY GR |
 |
| | | Notes: | |
 |
 |
| | | Name: | MST list total boys and girls for each teacher... |
 |
| | | Description: | List to get total number of boys and girls for each teacher who has a 6th period class that is not a fall class
|
 |
| | | String: | LIST MST TCH MST.SE MST.PD MST.TN TCH.TE MST.TB MST.TG MST.SM BY TCH.TE IF MST.SM # F AND MST.PD = 6 |
 |
| | | Notes: | |
 |
 |
| | | Name: | MST List of all section numbers and periods a specific course is offered |
 |
| | | Description: | List of all section numbers and periods a specific course is offered
|
 |
| | | String: | LIST MST CRS MST.SE MST.PD MST.CN CRS.CO IF MST.CN = #### |
 |
| | | Notes: | |
 |
 |
| | | Name: | MST list all students with section number and teacher name of their 1st period class sorted by teacher name |
 |
| | | Description: | List of all students with section number and teacher name of their 1st period class |
 |
| | | String: | LIST STU SEC MST TCH STU.LN STU.FN STU.GR MST.SE TCH.TE BY TCH.TE IF MST.PD = 1 |
 |
| | | Notes: | |
 |
 |
| | | Name: | MST Change the student's counselor/teacher number to match the MST teacher number for period 6 for all grade levels but 6 |
 |
| | | Description: | Change the student's counselor/teacher number to match the MST teacher number for period 6 for all grade levels but 6 |
 |
| | | String: | CHANGE STU SEC MST STU.CU TO MST.TN IF MST.PD = 6 AND GR # 6 |
 |
| | | Notes: | |
 |
 |
| | | Name: | MST List of classes in the MST file with incorrect credit values sorted by course number |
 |
| | | Description: | List of classes in the MST file with incorrect credit values sorted by crs#
|
 |
| | | String: | LIST MST CRS TCH MST.SE MST.PD MST.CN CRS.CO TCH.TE MST.ST MST.TS MST.CR BY MST.CN IF MST.CR # 5 |
 |
| | | Notes: | |
 |
 |
| | | Name: | MST labels for students in a specific class |
 |
| | | |