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
Next revision Both sides next revision
sasixp:eoy_report_queries [2007/07/26 15:48]
ginac
sasixp:eoy_report_queries [2007/07/26 15:50]
ginac
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.
   - 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