User Tools

Site Tools


sasixp:eoy_report_queries

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
sasixp:eoy_report_queries [2007/07/26 15:48]
ginac
sasixp:eoy_report_queries [2016/05/16 10:37]
jlester removed
Line 5: Line 5:
 The following queries will help review SASI data due on the End of Year report for accuracy.  Be sure to always select “Show Inactive Records” when performing these queries as inactive students are to be included in this report.  Those that have an (M) next to them can be check by doing a matrix as well.  The following queries will help review SASI data due on the End of Year report for accuracy.  Be sure to always select “Show Inactive Records” when performing these queries as inactive students are to be included in this report.  Those that have an (M) next to them can be check by doing a matrix as well. 
  
-NOTES +Notes:
   - In queries that contain " " there is a space between each quotation mark.   - In queries that contain " " there is a space between each quotation mark.
   - For queries that begin with XXXX ASTU, where XXXX indicates different file names, link ASTU to XXXX by dragging Stulink from the XXXX column to the field above the second column.   - For queries that begin with XXXX ASTU, where XXXX indicates different file names, link ASTU to XXXX by dragging Stulink from the XXXX column to the field above the second column.
Line 212: Line 212:
  
 === Check Truancy Conferences === === Check Truancy Conferences ===
-DISPLAY ACNF  ASTU ACNR LastName  FirstName  ReportDate  Descript IF  DescCode = ATT+DISPLAY ACNF  ASTU ACNR LastName  FirstName  ReportDate  Descript IF  DescCode = ATT AND ReportDate > 081606
  
 Link ASTU by dragging StuLink from the ACNF column to the field above the second column, then link ACNR by dragging DescCode from the ACNF column to the field above the third column. Link ASTU by dragging StuLink from the ACNF column to the field above the second column, then link ACNR by dragging DescCode from the ACNF column to the field above the third column.