Difference between revisions of "List of Students for Auditors"

From CrossRoad
Jump to: navigation, search
 
Line 1: Line 1:
 
'''Year End Audit Report'''
 
'''Year End Audit Report'''
 +
 
This should all now be in auditlst.bat. Parameter is year yyzz.
 
This should all now be in auditlst.bat. Parameter is year yyzz.
  
Line 7: Line 8:
  
 
<li>Total<br>
 
<li>Total<br>
 +
 
TotalOn AUDYYZZ idcent*1000000+studid audyyzzT CREDCRS,AUDCRS,NONCRED,CURCREDS,WITHDRAWN
 
TotalOn AUDYYZZ idcent*1000000+studid audyyzzT CREDCRS,AUDCRS,NONCRED,CURCREDS,WITHDRAWN
  
 
<li>Modify AUDYYZZT.DBF<br>
 
<li>Modify AUDYYZZT.DBF<br>
 +
 
updstru audyyzzt ENTCODE N 5 0<br>
 
updstru audyyzzt ENTCODE N 5 0<br>
 +
 
Fill in Entcode (audyyzzt.vew) – use HE to alter
 
Fill in Entcode (audyyzzt.vew) – use HE to alter
  

Latest revision as of 20:35, 7 July 2008

Year End Audit Report

This should all now be in auditlst.bat. Parameter is year yyzz.

  • Merge GenStats.dbf files into AUDYYZZ.DBF
    Genstats (if for a relevant term) and GSYYZZT.DBF (YYZZ is academic year without century or slash; T is term) files. DBU is fine.
  • Total
    TotalOn AUDYYZZ idcent*1000000+studid audyyzzT CREDCRS,AUDCRS,NONCRED,CURCREDS,WITHDRAWN
  • Modify AUDYYZZT.DBF
    updstru audyyzzt ENTCODE N 5 0
    Fill in Entcode (audyyzzt.vew) – use HE to alter
  • Copy AUDYYZZT.DBF to AUD990T.DBF
  • Reindex AUD990T.dbf on IDCENT*1000000+STUDID to AUD990T.NTX
  • ReportPro AUDITORS.RPT