Graduates per Ceremony for Certificates Details Report {STGRDOR-8}


This report is used to produce an XML file which can be given to users for printing of certificates for students linked on {SSTUD7-12} Qualification Results.

The report assumes that


User Selection Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments

(B)ulk or (I)ndividual A1

If (B)ulk


     Enter Start Student Number N9

     Enter End Student Number N9


If (I)ndividual


     Enter Student Number N9
   Enter the Start Event Number N9  
  Enter the End Event Number N9  

Must Deceased Student be Included Y/N? A1

In which format must the data be generated?
1          DD-MON-YYYY
2           YYYY-MM-DD
A1

Insert Document Code Y/N? A1

Display Names and Surnames in One Column Y/N A1
  Enter the File Name for the Output File A80 The file name will default from {STGRDOP-12} Graduation Path / File Names but can be changed.


Sort Order Per Comments
  Event Number, Qualification, Surname, Name


System Select  
  If 'Insert Document Code Y/N?" is 'Y' when the report is run, a record will be written to {SLLL1-1} for the document according to the SOD LL/GR as set on {SMNT-12}. This will prevent a student from being included in the output file on subsequent runs.

If the student must be displayed on the list again, enter a 'R'eprint on {SLLL1-1} for the document code.

Example
of the XML output:

Image of {STGRDOR-8} XML


Example: Excel

image of excel for stgrdor-8


Processing
Rules
 
  If the 'Display Names and Surnames in One Column Y/N' = 'Y', then the names and surname will be displayed in ONE column.
The date format will depend on:
In which format must the data be generated?
1          DD-MON-YYYY
2          YYYY-MM-DD

The output includes the Major Subject Specialisations {SCODE-13} if the field 'Print on Certificate: Majors' in the Qualification Definition {SACADO-1} Qualification is (Y)es and the student was registered for subject(s) where the Subject {SACADO-10} is marked as a major in the Curriculum {SACADO-17} and has a "Major Subject Specialisation".

The program prints the Teaching Competency of the Subject {SACADO-10} if the field  'Print Teaching Competencies on Certificate' in the Qualification Definition {SACADO-1} is (Y)es.

If the field 'Conversational Competency Description' of the Subject {SACADO-10} is entered and the student is registered for the Subject, the program will print the conversational competency description.

Manual Endorsements can be added onto {STGRDOP-21} and will only print if the Type on {SCODE-13} is 'V'

List of fields in xml/xsl object :

EVENT
EVENTDESC
QUAL   
QUALDESC   
QUALFULLDESC   
QUALALTFULLDESC   
TITLE   
NAMESANDSURNAME   
STNO   
BIRTHDATE   
IDNO   
PREFLANG   
DECEASED   
DECEASEDDATE   
YEAR   
RESULT   
RESULTDESC   
CERTNUMBER   
CERTYPE   
TYPEDESC   
EFFECTIVEDATE
MAJCERT1
MAJCERT2
MAJCERT3
VOCATIONALSPEC1
VOCATIONALSPEC2
TEACHCOMP1
TEACHCOMP2
TEACHCOMP3
CONVCOMP1
CONVCOMP2
CONVCOMP3

History of Changes

Date System Version By Whom Job Description
14-Jul-2010 v01.0.0.0 Precious Diale
t158438 New manual format.
16-Aug-2011 v02.0.0.0 Melanie Zeelie t176217 Correct links
11-Nov-2013 v03.0.0.1 Melanie Zeelie T192298 Add information  regarding detail needed and the output available in excel
19-Jan-2016 v03.0.0.2 Melanie Zeelie T211639 Correct images path to display correctly
17-Mar-2016 v04.0.0.0 Precious Diale T217712 Change the manual to include the major subject specialisation, teaching competency and conversational competency information.
14-May-2021 v04.1.0.0 Esther Louw
T246906
Add Manual Endorsements, see also T246976