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:49]
ginac
sasixp:eoy_report_queries [2016/05/16 10:37]
jlester removed
Line 9: Line 9:
   - 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.
   - All schools must run all queries to make sure nothing is in the fields that don’t apply.   - All schools must run all queries to make sure nothing is in the fields that don’t apply.
- 
- 
- 
  
 === Check for Blank State Testing Identifier (M) === === Check for Blank State Testing Identifier (M) ===
Line 215: 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.