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:50]
ginac
sasixp:eoy_report_queries [2016/05/16 10:37]
jlester removed
Line 10: Line 10:
   - 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) ===+
  
 DISPLAY ASTU PermNum LastName FirstName StateID DISPLAY ASTU PermNum LastName FirstName StateID
  
-=== *Check Unique Local Student Identifier (M) ===+=== Check Unique Local Student Identifier (M) ===
    
 DISPLAY ASTU PermNum LastName FirstName  DISPLAY ASTU PermNum LastName FirstName 
  
-=== *Check Responsible Division/Tuition Paid Code ===+=== Check Responsible Division/Tuition Paid Code ===
    
 DISPLAY ASTU PermNum LastName FirstName UserCd2 UserCd3 DISPLAY ASTU PermNum LastName FirstName UserCd2 UserCd3
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.