Generate e-asTTle Upload File {SREGMS-11} 


This program may be used to generate the file for upload to the e-asTTle System.


 
User Selection Prompt Text
* an item between square brackets [ ] is the default answer 		Type
&
Length		 Comments
1  Academic Year YYYY   
2 First Offering Type to Include or ALL A3
3 Next Offering Type to Include A3 The program allows 10 offering types to be entered
4 Start Study Period A1
5 End Study Period A1
6 Include Expired/Cancelled Registrations A1 Default N
Refer to rules regarding qualification registrations.
7 First Stats 1.2 Rowcode to Include or ALL N10
8 Next Stats 1.2 Rowcode to Include N10 The program allows 15 rowcodes to be entered.
 

Sort Order Per Comments
  For Class section:
  • Study period description, offering type combination descending.

For Student section:
  • Student number, study period descending

For Student Class section:
  • Study period description, offering type combination descending, student number, NSN number.


System Select  
Students Included
Students Excluded Deceased students
Qualification Registrations
  • Only Primary qualifications are used.
  • When student is registered for more than one registration with different study periods, the program will select the record with the highest study period to include in Student section
  • Parameter 'Include Expired/Cancelled registrations'=N will exclude registrations:
    • that are cancelled 
    • where the end registration date is before the rundate 
Main Subjects A Main subject:
  • On {SDREGA-1} the student is registered for this subject and:
    • the subject do not have an 'Involved Subject'
    • the subject is an 'Involved Subject' of another subject the student is registered for.
  • In {SACAD-10}:
    • the subject do have 'Module Subject'(s),
    • the subject is not a 'Module Subject' for any other subject.
The subject will be excluded when Parameter 'Include Expired/Cancelled registrations'=N and (main) subject is:
  • cancelled
  • the end registration date was reached before the rundate

Example of report output:

Example of the report output from {SREGMS-11}



Processing
Rules		  

The Own Institution Code {GCS-1} will be used as School Master ID

Special rules related to different sections in the file:
  • School Section
    • The School Master ID is the Institution Code {GCS-1}
  • Class Section
    • For the purpose of e-asTTle, a class is a group of students with the same Academic Year, Study Period and Offering Type. This section will have one record for each Study Period / Offering Type combination in the student data for the year entered
    • The Export Class ID is a numeric value assigned by the program
  • Student Section
    • If the Home Language of the Student 
      • Corresponds to the System Operational Definition {SMNT-12} "HE - Language Code for English" for Subsystem "BI", English_at_home  will be 1
      • Was not entered, English_at_home  will be left blank
      • Otherwise, English_at_home  will be 2
    • For Ethnicity, the Ethnic Group Code of the Student is translated with External Conversion Codes {GOPS-21} where the External Body is "AST - e-asTTle" and the External Code Type is "ETH - Ethnic"

NSN number validation:
  • Number must not be NULL
  • Number must be 10 characters long (leftpad with 0 if needed)
NSN status must be 'A'

Example of upload file - importfile.ast:

SECTION,Header
importfile.ast,2012-05-17 13:49:08.748,10

SECTION,Import_Type
Class

SECTION,School,ROWS,1
999

SECTION,Class,ROWS,2
1,STUDY PERIOD 201,Y
2,STUDY PERIOD 101,Y

SECTION,Student,ROWS,8
212000037,2212000037,Engage,Firstname,1,M,,1
212000045,2120000450,Clasen,Conrad,1,M,,1
212000047,2120000470,De Koker,Dawid,1,M,,1
212000049,2212000049,Esselen,Firstname,1,M,,1
212000050,2212000050,Ferreira,Firstname,1,M,,1
212000306,2120003060,BEUKES,Irma,1,F,1,26
213000075,2130000750,de Waal,Anton,1,M,,1
990001159,9900011590,Loots,Willem,2,M,,7

SECTION,Student_Class,ROWS,8
990001159,9900011590,1
212000037,2212000037,2
212000045,2120000450,2
212000047,2120000470,2
212000049,2212000049,2
212000050,2212000050,2
212000306,2120003060,2
213000075,2130000750,2

SECTION,Footer
importfile.ast


History of Changes

Date System Version By Whom Job Description
31-Jan-2011 v02.0.0.0 Frans Pelser
 t171630 New on-line help document
27-Jul-2011 v02.0.0.1 Magda vd Schyff F173007 Add NSN validation and Stats rowcode input parameters
02-May-2012 v02.0.0.2 Magda vd Schyff F181631 ALL is a valid value for rowcode. Add record counts on report. Add exclude parameter.