Load Exam Timetable  {SEDLES-1}

At the start of each examination cycle the Instructional program and Instructional offering information will be made available by the Department of Education.  Currently, only the exam timetable information is extracted for upload as part of the Electronic Data Link to the Examination System (EDLES)  


User Selection Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments
   Data Set Indicator:
  • H  = N4-N6 Business Studies
  • T  = Technical Studies
  • Q = NC Vocational
Please Enter Your Selection:






A1
Select a Data Set Indicator to Upload the TimeTable into.
Enter Examination Year N4 Enter the Examination Year to Upload
  Enter Exam Month N2 Enter the Exam Month to remove.
  Enter Exam Code or ALL N3 Enter the Exam Code to remove.
  Do you want to Run Program in (T)rial / (U)pdate: A1 
  • T=Trial mode, The data is validated but not updated.
  • U=Update, The data is validated and updated.


The layout of the record types that are processed:
Record type 01: Header Record
Instructional programme number N10 Value "0000000000"
Examination Date N6 CCYYMM
Sort Field 2 N10 Value "0000000000"
Record Type N2 Value “01”
Filename A12 NXXXX.TXT E.g. T0004.TXT for Technical Studies where
N=Study Group;
XXXX = Year & Month (column 4)
Owner Province Name A40
Owner Province Number N2
Date Created N8 Format CCYYMMDD.
Filler A160
Record type 08: Paper Information
Instructional programme Number N10
Examination Date N6
Instructional Offering Number N10 SAPSE code as entered on {SACADO-10} External code is used to get the Subject code
Record Type N2 Value “08”
Paper Info Paper Date N8/1:5
Paper Time A5/1:5 Format "HH:MM". 
Paper Duration A5/1:5 Format "NN.NN". This works in decimal i.e. 2.5 for 3 hours 30 minutes.  Paper duration is multiplied by 60.
Paper Type A10/1:5  Character Value/Meaning
1 A=Written, B=Oral, C=Practical, D=Year mark (Technical), E=Year marks (General)
2 A=Internal, B=Internal - external moderate, C=External
3 Y/N=Appear on time table and admission letter
4 Y/N=Transfer marks to re-exam
5 Y/N=Print packing stickers
6 Y/N=Print mark sheets
7 Y/N=Paper on packing check list
8-10 Not used
Paper Linking Percentage N3.2 Percentage of paper towards the Instructional Offering
Paper Numbers Linked N2/1:5 Paper numbers that are linked
Paper Link Sub Min N2 The average percentage of the linked Instructional Offerings to pass
the linked group
FILLER A82

The following record types received from the departent are not currently processed.
Record type 02: Instructional Programme
Instructional programme Number N10 Where:
Character 1 => Value 0 National Number, 1 Internal Number.
Character 2 to 9 is the NATED internal number.
Character 10 => Value 1
Alternative Instructional Program Number N10
Examination Date N6 Format CCYYMM
Sort Field N10 Value "0000000000"
Record type N2 Value "02"
Previous Instructional; Programme Number N10
Minimum Instructional Offerings N2 Minimum Instructional Offerings that may be entered.
Maximum Instructional Offering N2 Maximum Instructional Offerings that may be entered.
Supplementary Number N2 Number of passes needed to qualify for supplementary
examination. 99 mean no supplementary examination.
Compulsory Number N2 Number of compulsory Instructional Offerings.
Sub minimum number N2 Minimum number needed to pass the course.
Condone Number N2 Number that may be condoned.
Course Sub-minimum N2 Minimum percentage to pass.
Condone Percentage N2 Maximum condone percentage.
Entry Fee A6 Format "NNN.NN"
Qualification A50 Qualification needed to enter.
Date phased in N6 Format CCYYMM Course phased in.
Date phased out N6 Format CCYYMM Course phased out.
ID Prerequisite A1 Value "J" or “Y” if ID number required for certification.
Course Name (English) A50
Course name (Afrikaans) A50
Filler A17
Record type 03: Instructional Programme
Instructional programme Number N10
Examination Date N6 Format CCYYMM.
Sort Field N10 Value "0000000000".
Record Type N2 Value "03".
Pre-required Courses N10/1:5 Number of courses needed before entering this course. Candidate may enter, but will not be certified.
Instructional Offering Group/Field of Study: Some Instructional Offerings are grouped.
The occurrence of this field depicts the group/field of study.
Minimum Groups N2/1:10 Minimum number of groups.
Maximum groups N2/1:10 Maximum number of groups.
Supplementary number groups N2/1:10 Minimum groups passes needed to qualify for supplementary.
Compulsory Number Groups N2/1:10 This is the number of compulsory Instructional Offerings in this group.
Number Condoned Instructional Offerings N2/1:10 This is the maximum number of Instructional Offerings in this group that may be condoned to a pass.
Sub-minimum Number Group N2/1:10 This is the minimum number of Instructional Offerings needed to pass this group.
Sub-minimum Group N2/1:10 This is the minimum percentage needed to pass this Instructional Offering group/field of study.
Condone Group N2/1:10 This is the total number of marks that this group may be condoned with.
FILLER A12
Record type 04: Instructional Offering
Instructional programme Number N10
Examination Date N6 Format CCYYMM.
Instructional Offering Number N10 The NATED or internally generated number.
Record Type N2 Value "04".
Previous Instructional Offering Number N10 Used to link to previous courses or Instructional Offerings.
Active/In-active Indicator A1 Value "J", “Y” or spaces means the Instructional Offering
is active, "N" Instructional Offering is inactive and may not be
entered for.
Origin N1 For std. 10 only.
1st Conversion N10 For std. 10 only.
2nd Conversion N10 For std. 10 only.
DET or DEC Instructional Offering Number N10
Suspend Indicator A1 "N" Not suspended, "J" or “Y” suspended.
Group ID N2 Number of the group that this Instructional Offering is a member of.
Group ID rest A2
Entry Indicator A1 Value "J" or “Y” may enter; "N" may not enter.
Compulsory Indicator N1 Compulsory = 1, Not compulsory = 2, Choice= 3.
Number of Marks N2 Number of marks making up this Instructional Offering.
Application Number N2 Maximum number of applications to pass thisInstructional Offering.
99 no restriction.
Application Years N2 Maximum number of years to pass this Instructional Offering.
99 No restriction.
Sub-minimum A6 Format "NNN.NN" minimum percentage to pass  this Instructional Offering.
Sub-minimum Number N2 The minimum number of marks or papers needed  to pass.
Condone Sub-minimum A6 Format "NNN.NN".
Condone Supplementary A6 Format "NNN.NN".
Supplementary Percentage A6 Format "NNN.NN".
Application fee A7 Format "NNNN.NN".
Re-Mark/Re-Check fee A7 Format "NNNN.NN".
Marking fee A7 Format "NNNN.NN"
Grade N2 1-High, 2-Standard, 3-Low, 4-High FL, 5-Standard FL, 6-Low FL, 7-High SL, 8-Standard SL, 9-Low SL, 10-High TL, 11-Standard TL and 12-Low TL. (FL-First Language, SL Second Language, TL-Third Language)
Medium of Tuition N1 1-English, 2-Afrikaans, 0-Both
Paper Option A1 Value "N"-automatic entered for all papers, "J" or  “Y” -select papers to enter for.
Instructional Offering Description (English) A50
Instructional Offering Description (Afrikaans) A50
FILLER A16
Record type 05: Instructional Offering
Instructional programme Number N10
Examination Date N6 Format CCYYMM.
Instructional Offering Number N10
Record Type N2 Value "05".
Invalid Instructional Offerings N10/1:20 Instructional Offering numbers that may not be offered with this Instructional Offering.
FILLER A22
Record type 06: Paper Information
Instructional programme Number N10
Examination Date N6 Format CCYYMM.
Instructional Offering Number N10
Record Type N2 Value "06".
English Description A30/1:5
FILLER A72
Record type 07: Paper Information
Instructional programme Number N10
Examination Date N6
Instructional Offering Number N10
Record Type N2 Value "07".
Afrikaans Description A30/1:5
FILLER A72
Record type 99: Control Record
Instructional programme Number N10 Value "9999999999".
Examination Date N6 Format CCYYMM.
Sort Field N10 Value "9999999999".
Record Type N2 Value "99".
Filename A12 NXXXX.TXT
Owner Province Name A40
Owner Province Number N2
Date Created N8 Format CCYYMMDD.
Number of records on file N6 this number excludes the header and trailer record.
Filler A154


Example
: This is an example of an Upload in SEDLES-1 report.

Sedles - 1



See Also:


History of Changes

Date System Version By Whom Job Description
01-Jun-2007 v01.0.0.0 Charlene van der Schyff t137175 New manual format.
16-Oct-2008 v01.0.0.0 Charlene van der Schyff t151938 Edit language obtained from proof read language Juliet Gillies.
22-Aug-2018 v03.0.0.0 Charlene van der Schyff t226864 Update manual with image and batch parameters
27-Aug-2019 v04.1.0.0 Magda van der Westhuizen t238951 Change version to INT4.1.
05-Jan-2023 v04.1.0.1 Esther Nel t244987 Provide Additional information