The data value may only contain characters that exist in the following range of characters: ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'- Business rules Field must contain a valid Socioeconomic_Status_Code. Field name Disability_Status_Code Field Description Disability Status Code Field number 10 Field start position 75 Field end position 85 Field Length 10 General notes The first character in the field may not be a space. Edu.Dex will strip all leading and trailing spaces from the data value before the content and business rules for the field are tested. Content rules A valid data value must be supplied. This field may not be left blank. The data value may only contain characters that exist in the following range of characters: ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'- Business rules Field must contain a valid Disability_Status_Code. Field name Person_Last_Name Field Description Person Last Name Field number 11 Field start position 85 Field end position 130 Field Length 45 General notes The first character in the field may not be a space. Edu.Dex will strip all leading and trailing spaces from the data value before the content and business rules for the field are tested. Content rules A valid data value must be supplied. This field may not be left blank. The data value may only contain characters that exist in the following range of characters: ABCDEFGHIJKLMNOPQRTSUVWXYZ`' - Business rules Field may not contain invalid strings like ‘unknown’, ‘test’, ‘as above’ etc The range of invalid strings is extended as and when SAQA defines new invalid strings. Field name Person_First_Name Field Description Person First Name Field number 12 Field start position 130 Field end position 156 Field Length 26 General notes The first character in the field may not be a space. Edu.Dex will strip all leading and trailing spaces from the data value before the content and business rules for the field are tested. Content rules A valid data value must be supplied. This field may not be left blank. The data value may only contain characters that exist in the following range of characters:
Business rules Field may not contain invalid strings like ‘unknown’, ‘test’, ‘as above’ etc The range of invalid strings is extended as and when SAQA defines new invalid strings. The field must contain the training provider’s provider code as issued by the primary ETQA of the training provider. Must have a value if Alternate_Id_Type = 537. Field name Provider_Etqa_Id Field Description Provider Etqa Id Field number 10 Field start position 118 Field end position 128 Field Length 10 General notes The first character in the field may not be a space. Edu.Dex will strip all leading and trailing spaces from the data value before the content and business rules for the field are tested. The count of records found in the file that have a Provider ETQA Id other than the recipient ETQA will be recorded in the aggregated report under the General information heading. Content rules A valid data value must be supplied. This field may not be left blank. The data value may only contain characters that exist in the following range of characters: 01234567890. Business rules The field must contain the training provider's ETQA Id. Field name Assessor_Etqa_Id Field Description Assessor Etqa Id Field number 11 Field start position 128 Field end position 138 Field Length 10 General notes The first character in the field may not be a space. Edu.Dex will strip all leading and trailing spaces from the data value before the content and business rules for the field are tested. The count of records found in the file that have a Assessor ETQA Id other than the recipient ETQA will be recorded in the aggregated report under the General information heading. Content rules A valid data value must be supplied. This field may not be left blank. The data value may only contain characters that exist in the following range of characters: 01234567890. Business rules Must be the same as the ETQA_ID of the recipient ETQA. Field name Most_Recent_Enrolment_Date Field Description Most Recent Enrolment Date Field number 12 Field start position 138 Field end position 146 Field Length 8 General notes The first character in the field may not be a space. Edu.Dex will strip all leading and trailing spaces from the data value before the content and business rules for the field are tested. Content rules
Submission requirements: Submitting this file to Edu.Dex is optional. File rules: The length of each record must be exactly 606. The first record in the file must be a header record that contains the following information: Characters 1 to 6: the word HEADER Characters 7 to 10: an ETQA identifier in one of the following formats: The four character mnemonic for your ETQA (CHED) A three character number that represents your ETQA code (621) A four character number that represents your ETQA code (0621) Characters 11 – 30: a description of the file (the description may not be left blank and may not contain numbers) Characters 31 – 40: the number of data records in the file (the number may not be left blank and may not contain non-numeric characters) File fields: Field name Journal_Publication_Code Field Description Journal PublicationCode Field number 1 Field start position 1 Field end position 16 Field Length 15 General notes Edu.Dex will strip all leading and trailing spaces from the data value before the content and business rules for the field are tested. Content rules A valid data value must be supplied. This field may not be left blank. The data value may only contain characters that exist in the following range of characters: ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._- Business rules Field must contain a uniqe value per provider Field may not be NULL Field name Journal_Name Field Description Journal Name Field number 2 Field start position 16 Field end position 271 Field Length 255 General notes The first character in the field may not be a space Edu.Dex will strip all leading and trailing spaces from the data value before the content and business rules for the field are tested. Content rules A valid data value must be supplied. This field may not be left blank. The data value may only contain characters that exist in the following range of characters: ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'- Business rules Field name Accredited Field Description Accredited Field number 3 Field start position 271 Field end position 281 Field Length 10 General notes