Download Moodle Information {SSTUDI-2}


This option is used to create comma-delimited data files that will provide information to the "Campus Online" environment.



Prerequisites:

Define SOD ME for subsystem SR on {SMNT-12} "Moodle Administrator Email Address" to indicate to whom the files must be sent via email.

The following combinations of External Conversion Codes must exist on {GOPS-21}:

 

External Body External Code Type
(IKXEXTBODY) Description IKXEXTCTYPE Description
OLC OPNZ Online Campus CYR Academic Structure Year for file 3, 4, 6 ,7, 8.
OLC OPNZ Online Campus SAD Student Address Type.
OLC OPNZ Online Campus SEM     Student Email Comm. Type.
OLC OPNZ Online Campus PEM Personnel Email Comm. Type.
OLC OPNZ Online Campus OT Offering Type for file 3, 7, 8.
OLC OPNZ Online Campus BC Block Code for file 3.
OLC OPNZ Online Campus TUT Tutor Activity for file 6.
OLC OPNZ Online Campus CAN Subject Cancelled Status.
OLC OPNZ Online Campus RES Subject With Result Status.
OLC OPNZ Online Campus DAY Number of Days to Include.
OLC OPNZ Online Campus ERD Early Registrations Days.


The user must define the directories for the different files to be created on {SSTUDI-1}
The following files will be created:

File Description Content
1 Student and Email - OLCSTD Contains student biographical, delivery address  and email information on {SREGB-1}.
2 Staff - OLCPRS Personnel biographical information and email information. {PBOP-1}. Resigned personnel will be excluded.
3 Subject Information - OLCSUB Contain academic structure information and includes Year, subject, block and offering type information on {SACAD-14}.
4 Qualification Information - OLCQAL Academic structure information regarding the qualification set-up on {SACAD-13} and the Qualification Coordinator as defined on {SACAD-9}.
5 Contracts - OLCCON Contract information as per contract definition on {FSAC-10} for which students are enrolled.
6 Personnel Contract Detail - OLCPC Personnel contract detail set-up as tutors per subject on {SDSERP-1b3}. Only active tutor records linked to subject 'S' indicator will be selected.
7 Assessment Detail - OLCASM Contains information regarding the assessment structure as defined on {SSTUD3-7} per subject.  The selection of the records is done from table JDQTMC for the years as defined in "External Conversion" table {GOPS-21}.
8 Composite Structure (Curriculum Module Structure) - OLCCUR Distinct list of subjects that is used on composite level for the curriculum module structure on {SACAD-10}.
9 Student Enrolment Information - OLCENR Student qualification and subject enrolment information as seen on {SSTUDY-21b2 and b3}.
 The selection of enrolled students is done as follows:
  • Where system date is equal to or greater than the qualification block's start date and less or equal to the qualification block end date {GOPS-1} plus seven calendar days. The above logic will ensure that only students whose studies have started are selected. The additional days after the block has ended is to ensure that CATALYST has enough opportunity to ensure that records are correctly processed on the MOODLE side before it being excluded from selection.
  • Included:
  • Cancelled Qualification enrolment.
  • For active enrolled students subject records are included for the output file.
  • Include additional subjects.
  • Include subject records with a result code on {SSTUDY-21}.
  • Include canceled subjects.
  • For the selected subject record include a person number (tutor) if a record exists in {SDSERI-1} -Student service centres / activity) for the matching enrolment record for the activity specified for the external conversion table (IKX) combination:
  • External Body = 'OLC', and External Code Type = 'TUT'  for the internal Code as linked to the student on {SDSERI-1}.
  • The status column is a non-database field and the data will be derived according to the following rules:
  • If no status exists for the record it will indicate it is an active enrolled record.
  • If a subject registration record is canceled the value as specified on {GOPS-21} for the combination where External Body = 'OLC' , External Code Type = 'CAN' to be inserted for the canceled records.
  • If a subject registration record has got a result code inserted the value as specified on {GOPS-21} for the combination where External Body= 'OLC'  and External Code Type ='RES' value to be inserted for records with a result code.
10 Student Assessment - OLCSAS Assessments received and is recorded within the holding bin as entered on {TASKS1-16b2},  for the number of days to be used to include assessment records, prior to the system date for the  ,combination, where External Body= 'OLC'  and External Code Type ='DAY' value. If no value is defined, the system date will be used. All electronic received records, with Media Type = 'E' will be excluded.

The check is done on both the Holding bin {TASK1-16} and the Bundle records {TASK1-2}  for assessment records created within the number of days defined.
  • If the records exist only in the Holding bin
    • then the reporting is done on the holding bin using the holding bin create date
  • if the records exist only in the Bundles
    • then the reporting is done on the bundle using the bundle create date
  • if the records exist both in the Holding bin and the Bundles
    • then the reporting is done on the holding bin using the holding bin create date
11 Early Registrations - OLCERG To select enrolment records where the start date of the block registration has not started as yet for the amount of days specified in {GOPS-21} for the combination where External Body= 'OLC'  and External Code Type ='ERD' value.
12 Simplified Enrolment - OLCSSE To select a combination of file 9 and 11

Example:

image of output file names




Processing
Rules		  
 
  1. Data must exist on the different tables as defined in the above:

For this upload the following 2 errors could possibly occur and can be printed under a heading referring to the Upload Error Report
    • Error 1: the student number in the file doesn't match any record within the system. The student number will be printed with an indication that no matching TS student number was found.
    • Error 2: the address type to upload the e-mail address either doesn't exist or is not valid. If this error occurs no record will be  uploaded. The massage "Invalid address type or address type not found in external conversion table {GOPS-21}"  will be printed.
Communication Indicator {FSAC-10}:  

  1. If the contract linked to the enrolment of the student has a value of 'M' or 'N' in the Communications options field on the contract definition {FSAC-10}, the enrolment record will not be selected.
  2. If the contract linked to the enrolment has a value of 'O' or 'B' for the new communication field on the contract definition, and meets all other criteria specified, the student will be selected.


History of Changes

Date System Version By Whom Job Description
14-Jun-2007 v01.0.0.0 Melanie Zeelie t140979 New manual format.
17-Jul-2007 v01.0.0.0 Charlene van der Schyff t140979 Corrections to this manual includes: inserting new tables in the correct standard.
31-Oct-2007 v01.0.0.0 Melanie Zeelie t140747 Add information
13-Nov-2007 v01.0.0.0 Melanie Zeelie t137077 Add information regarding case 11
13-Dec-2007 v01.0.0.0 Melanie Zeelie t140979 Add information regarding case 2
16-Oct-2008 v01.0.0.0 Charlene van der Schyff t151938 Edit language obtained from proof read language Juliet Gillies.
07-Dec-2009 v01.0.0.1 Brilliant Tleane t163680 Add new information on file 10
28-Jun-2010
 v01.0.0.2 Hermien Hartman t160226 The option is download and not uploaded so USR and RIC were removed as info is not applicable.
05-Sep-2011 v02.0.0.1 Magda van der Westhuizen t165835 Add Communication Indicator {FSAC-10}.
14-Nov-2017 v03.0.0.0 Melanie Zeelie f225102 Add SOD ME/SR for email purposes
4-Jun-2018 v04.1.0.0 Melanie Zeelie f228989 Add SOD ME/SR for email purposes and new file option