1 / 6

Load Specifications and Lookup Tables saqa.za/nlrdpbinfo.asp

Load Specifications and Lookup Tables www.saqa.org.za/nlrdpbinfo.asp. Carina Oelofsen Deputy Director: NLRD: Data Quality and Information Management South African Qualifications Authority (SAQA) 14 March 2013. Data Flow to the NLRD. Record. Record. Record. Person info. Person info.

klaus
Download Presentation

Load Specifications and Lookup Tables saqa.za/nlrdpbinfo.asp

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Load Specifications and Lookup Tableswww.saqa.org.za/nlrdpbinfo.asp Carina Oelofsen Deputy Director: NLRD: Data Quality and Information Management South African Qualifications Authority (SAQA) 14 March 2013

  2. Data Flow to the NLRD Record Record Record Person info Person info Person info Designation Designation Designation Professional Body Professional Body Professional Body SAQA – Loaded onto NLRD

  3. Person Information From database: To fixed-length record: www.saqa.org.za/nlrdpbinfo.asp

  4. Person Designation Link between person and designation www.saqa.org.za/nlrdpbinfo.asp

  5. General Comments • Ensure the integrity of ID numbers, date of birth and gender • Ensure the integrity of the date stamp values – update date • Ensure fields contain valid characters only – note the prescribed formats (e.g. dates) • No orphan records allowed (e.g. when a Person Designation record does not match a Person record) www.saqa.org.za/nlrdpbinfo.asp

  6. General Comments (continued) • Submit as much data per record as possible • Ensure that records are not duplicated • Keep a record of errors encountered and solutions to these • Edu.Dex data validation utility www.saqa.org.za/nlrdpbinfo.asp

More Related