Abet Band Id A unique (system-generated) identifier for an ABET band. To be used in conjunction with NQF Level/s: 1 Undefined NQF L2 & above 2 ABET Level 1 } 3 ABET Level 2 }Below Level 1 4 ABET Level 3 } 5 ABET Level 4 NQF Level 1 SAQA Alternative Id Type A unique (system generated) identifier for an alternative id type. 521 SAQA Member Id 527 Passport Number or Foreign ID Number 529 Driver’s Licence 531 Temporary ID number 533 None 535 Unknown 537 Student Number 538 Work Permit Number 539 Employee Number 540 Birth Certificate Number 541 HSRC Register No. 561 ETQA Record Number 565 Refugee Number SAQA Citizen Resident Status Code A code indicating the residence status of an individual. Data suppliers are urged not to use ‘U – Unknown.’ U Unknown SA O Other D Dual (SA plus other) PR Permanent Resident SAQA Country Code A code identifying the country in which a Provider is located This list is too long to reproduce here. Please see the latest version of the Excel lookup tables (on www.saqa.org.za/nlrdinfo.php). SAQA Designation Id A unique (system-generated) identifier for a designation. These are added when designations are registered on the NLRD. 1 Assessor 8 CA(SA) SAQA
Health and Functioning Rating ID Unique (system generated) identifiers for rating the level of functioning on each of the following indicators in turn: Seeing Hearing Communicating Walking Remembering Selfcare 1 No difficulty 2 Some difficulty 3 A lot of difficulty 4 Cannot do at all 6 Cannot yet be determined 60 May be part of multiple difficulties (TBC) 70 May have difficulty (TBC) 80 Former difficulty - none now Statistics SA: 1-6 SAQA: 60-80 Home Language Code An acronym reflecting the major official languages in . Currently it is anticipated that 11 will be captured. Data suppliers are urged not to use ‘U – Unknown.’ Eng English Afr Afrikaans Oth Other SASL South African Sign Language Sep sePedi [also known as Northern Sotho / Sesotho sa Lebowa] Ses seSotho Set seTswana Swa siSwati Tsh tshiVenda U Unknown Xho isiXhosa Xit xiTsonga Zul isiZulu Nde isiNdebele SAQA Honours Classification ID ‘Cum laude’ etc. This field is now also being used for Senior Certificate achievements. Thus, IDs 23 to 38 and 79 to 84 are for Umalusi only. Any other ETQA wishing to use them should please motivate this to the Director: NLRD. (Further values will be defined in conjunction with data suppliers that capture this information.) 1 Unknown 21 Cum Laude 22 Honours 23 Higher Grade 24 Standard Grade 25 Lower Grade 26 Ordinary Grade 27 N3 Level 28 Historical SC 29 M5 34 S5 30 M4 35 S4 31 M3 36 S3 32 M2 37 S2 33 M1 38 S1 39 Not with Honours 59 Not Applicable 79 Symbol A: 1680+ 80 Symbol B: 1470 - 1679 81 Symbol C: 1260 - 1469 82 Symbol D: 1050 - 1259 83 Symbol E: 840 - 1049 84 Symbol F: 720 - 839 SAQA
Learner Achievement Status Id A unique identifier for the status of a learner achievement. As of May 2010, the values of 1 (Unknown) and 6 (Other) are no longer allowed. 2 Achieved 3 Enrolled 4 De-enrolled 5 (not 500) Re-enrolled 7 Withheld 10 Discontinued 14 Achieved - Certification Not Required 15 Achieved and Certificated 27 Withdrawn 28 Reinstated 29 Achieved and Not Entitled to Practise 31 Waiting for WIL 32 WIL in progress 49 Non-Endorsed Enrolment 50 Non-Endorsed Achievement 69 Enrolled (Provider reversed achievement) 70 Enrolled (ETQA/QAB reversed the achievement) 89 Handover to Next Provider or Qualification SAQA Learner Achievement Type Id A unique (system-generated) identifier for a type of learner achievement. As of May 2010, the value of 1 (Unknown) is no longer allowed. 2 RPL for Unknown Purpose 3 Distance Learning 4 Residential Learning (i.e. Contact Mode) 5 (not 500) Work Place Learning 6 (not 501) Other 7 Mixed Mode 8 Self-study 28 Previous Achievement 48 Residential (Contact) at more than one Provider 49 Distance Learning at more than one Provider 68 RPL for Access to Qualification 69 RPL for Credits or Advanced Standing 70 RPL for Complete Qualification 71 RPL for Designation SAQA
Provider Accred Status Code A code indicating the current status of the accreditation, regardless of its end date A Active I Inactive L Legacy V Provisional SAQA Provider Accredit Assessor An indicator as to whether a provider has been delegated the ability to accredit assessors by the ETQA. Y Yes N No SAQA Provider Class Id A general classification of providers. Data suppliers are urged not to use ‘1 – Unknown.’ 1 Unknown 3 Foreign 4 Public 5 Private 6 Interim (for SAQA use only - will soon fall away) 7 NGO / CBO 8 Mixed: Public and Private SAQA Provider Type Id A classification of providers used in the NLRD. As of May 2010, the value of 1 (Unknown) is no longer allowed. 2 Development NGO 3 Education 4 Employer 5 Training 500 Education and Training SAQA Province Code A code referencing a particular South African province. As of May 2010, the value of 0 (Undefined) is no longer allowed. 1 2 3 4 5 Kwazulu/Natal 6 7 Gauteng 8 Mpumalanga 9 Limpopo N SA National (i.e. in SA but province unspecified) X Outside SA Statistics SA (Note: the codes for “SA National” and “Outside SA” are SAQA’s, as Stats SA does not have codes for these)
Qualification Type Id A unique (system-generated) identifier for a type of certificate. (Professional Registration has been removed, as it is now covered by Designation.) Data suppliers are urged not to use ‘1 – Unknown.’ 1 Unknown 2 National Certificate 3 National Diploma 4 National First Degree (Min 360) 501 Post-doctoral Degree 503 Doctoral Degree 505 Masters Degree 507 Professional Qualification 509 Honours Degree 511 National Higher Diploma 513 National Masters Diploma 515 National Higher Certificate 532 Further Diploma 533 Post Graduate Diploma 534 Senior Certificate 535 Qual at Nat Sen Cert level 554 Apprenticeship / Trade Cert 574 Post Grad B Degree (phasing out) e.g. B Ed 575 Post Diploma Diploma (phasing out) 594 Post-basic Diploma [mainly applies to Nursing] 596 Further Ed and Training Cert (FETC) 617 National First Degree (Min 480) 658 Schl below SenC: not full qual 678 Advanced Certificate 679 Advanced Diploma 680 Higher Certificate 721 Occupational Certificate SAQA Socioeconomic Status Code A code indicating the (socio)economic status of an individual. U Unspecified 01 Employed 02 Unemployed, looking for work 03 Not working – not looking for work 04 Home-maker (not working) 06 Scholar/student (not working) 07 Pensioner/retired (not working) 08 Not working – disabled person 09 Not working – not wishing to work 10 Not working – Not elsewhere classified 97 N/A: Aged <15 98 N/A: Institution Statistics SA (Note: the code for “Unspecified” is U on the NLRD, but 99 for Stats SA)
Std Industry Class Code (values are DoL’s Std Activity Class Codes) Applied per Provider on the NLRD. Adapted by DoL from the Standard Industry Class Code list (which is an international classification scheme to group businesses) Lookup Table (extensive) supplied by DoL. The list is too large to be printed here. A full list will be provided by SAQA on request Department of Labour Structure Status Id Can apply to Providers or to Person Designation including Assessors (also to SGB Members or ETQAs – not applicable to Load Specs) The value is assigned by SAQA. As of May 2010, the value of 1 (Unknown) is no longer allowed. As applied to Providers: 510 Accredited 513 Accredited - Provisional 512 De-accredited 506 Proposed 511 Reaccredited 501 Registered 514 Withdrawn 515 Unsuccessful 574 Previously used in Interim process 575 Closed (Legacy) As applied to Person Designation: 503 Deregistered 506 Proposed 501 Registered 505 Reregistered 514 Withdrawn 515 Unsuccessful 580 Deceased 594 Exemption - Age 595 Exemption - Ill Health 596 Exemption - Other 597 Exemption - Restricted Further applications will be added later. There are also already a few more in existence, added on the basis of specific requests. Please contact the Director: NLRD if the Status required for a data extract is not yet shown here. SAQA
Person_Home_Address_1 Person_Home_Address_2 Person_Home_Address_3 Person_Postal_Address_1 Person_Postal_Address_2 Person_Postal_Address_3 Provider_Address_1 Provider_Address_2 Provider_Address_3 Provider_Physical_Address_1 Provider_Physical_Address_2 Provider_Physical_Address_Town Provider_Web_Address abcdefghijklmnopqrstuvwxyz 1234567890 # & ( ) / \ : . _ , ' [space] - [hyphen] Everything else Disallowed: A data value that contains only numbers Person_Email_Address Provider_Contact_Email_Address abcdefghijklmnopqrstuvwxyz 1234567890 _ . < > - [hyphen] Everything else Disallowed: A data value that does NOT contain the @ character Provider_Code Designation_Registration_Number Course_Code Qualification_Code Assessor_Registration_Number Etqa_Decision_Number Provider_Sars_Number Provider_Accreditation_Num abcdefghijklmnopqrstuvwxyz 1234567890 @ # & ( ) / \ : . _ + [space] - [hyphen] Everything else Qualification_Name Course_Name Provider_Name abcdefghijklmnopqrstuvwxyz 1234567890 @ # & ( ) / \ : . _ , ' + [space] - [hyphen] Everything else Person_Phone_Number Person_Fax_Number Provider_Phone_Number Provider_Fax_Number Provider_Contact_Phone_Number 1234567890 ( ) / [space] - [hyphen] Everything else Person_Cell_Phone_Number Provider_Contact_Cell_Number 1234567890 ( ) [space] - [hyphen] Everything else APPENDIX E:
Non-fatal Unable to validate Provider_Code values. Non-ETQA provider codes supplied - SAQA to confirm provider codes exist on NLRD. Some of the records have Provider Codes not appearing in File 21, thus not belonging to the uploading ETQA. ETQA & SAQA The ETQA must ensure that they have captured the correct Provider Codes. SAQA must confirm that all the codes do have valid Provider IDs The file "Non-ETQA Providers ..." generated by Edu.Dex gives a list of all Provider Codes. File 23 - Legacy Courses Validation Severity Description Explanation For Action Actions To Be Taken Fatal Records that have space as first character for: Abet_Band_Id Course_Code Course_Name Course_Registration_End_Date Course_Registration_Start_Date Date_Stamp NQF_Level_Id Provider_Code Provider_Etqa_Id Subdomain_Id A space is not allowed as the first character in any field. ETQA Ensure that no fields commence with spaces. Also, ensure that there are no ‘offset’ problems in the extract. File 24 - Provider Accreditations Validation Severity Description Explanation For Action Actions To Be Taken Fatal Records that have space as first character for: Date_Stamp Etqa_Decision_Number Learnership_Id Provider_Accred_End_Date Provider_Accred_Start_Date Provider_Accred_Status_Code Provider_Accredit_Assessor_Ind Provider_Accreditation_Num Provider_Code Provider_Etqa_Id Qualification_Id Unit_Standard_Id A space is not allowed as the first character in any field. ETQA Ensure that no fields commence with spaces. Also, ensure that there are no ‘offset’ problems in the extract.