Return to:

Main menu

Steps in preparing returns

File scopes

File structures

Base element definition listing

Derived element definition listing

Glossary

Edit validation rule listing

Using Valpac.Net

 

 

Edition: 20 January 2009

 

EDIT VALIDATION RULES 011**   TO   020**

 

ERROR No.

ERROR MESSAGE TO APPEAR ON VALIDATION REPORT

ERROR TYPE

VALIDATION RULE

ELEMENT BEING TESTED

TABLES USING THE VALID-ATION

01101

01101:     E011 (Date of birth) is not a valid yyyymmdd date.

Fatal

E011 (Date of birth) must be a valid date of the calendar, and in yyyymmdd format.

011

STUD

PROF

01102

01102:     E011 (Date of birth) indicates a person aged less than 12.

Fatal

E011 (Date of birth) must not be less than 12 years prior to 31 December the collection year.

011

STUD

01103

01103:     E011 (Date of birth) indicates a person aged between 13 and 17.

Warning

Normally, E011 (Date of birth) would not be 13 to 17 years prior to 31 December of the collection year.

Note:  The institution needs to check to make sure that the coding for this element is correct.  If it is correct then this error can be ignored.

011

STUD

01104

01104:     E011 (Date of birth) indicates a person older than 90.

Fatal

E011 (Date of birth) must not be more than 90 years prior to 31 December of the collection year.

011

STUD

01105

01105:     E011 (Date of birth) indicates a person aged between 75 and 90.

Warning

Normally, E011 (Date of birth) would not be 75 to 90 years prior to 31 December of the collection year.

Note:  The institution needs to check to make sure that the coding for this element is correct.  If it is correct then this error can be ignored.

011

STUD

01106

01106:     E011 (Date of birth) indicates a person aged less than 16.

Fatal

E011 (Date of birth) must not be less than 16 years prior to 31 December of the collection year.

011

PROF

01107

01107:     E011 (Date of birth) indicates a person aged between 16 and 20.

Warning

Normally, E011 (Date of birth) would not be 16 to 20 years prior to 31 December of the collection year.

Note:  The institution needs to check to make sure that the coding for this element is correct.  If it is correct then this error can be ignored.

011

PROF

01108

01108:     E011 (Date of birth) indicates a person aged between 80 and 90.

Warning

Normally, E011 (Date of birth) would not be 80 to 90 years prior to 31 December of the collection year.

Note:  The institution needs to check to make sure that the coding for this element is correct.  If it is correct then this error can be ignored.

011

PROF

01201

01201:     E012 (Gender) is not a valid code.

Fatal

E012 (Gender) must be one of the codes specified in the Data Element Dictionary as being valid for this element..

012

STUD

PROF

01301

01301:     E013 (Race) is not a valid code.

Fatal

E013 (Race) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

013

STUD

PROF

01401

01401:     E014 (Nationality) is not a valid code.

Fatal

E014 (Nationality) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

014

STUD

PROF

01402

01402:     E014 (Nationality) code "SAF" but E049 (Citiz-res) is not "SA".

Fatal

If E014 (Nationality)  is coded "SAF" (prior 2011) or "ZAF", then:

E049 (Citizen-resident status) must be coded "SA".

014,

049

STUD

01501

01501:     E015 (Home postcode) is not a valid code.

Fatal

E015 (Home postcode) must be exist as a value in the "Home postcode" field in a record in the Access table "PostalCodes", and includes "XXXX", "YYYY" and "ZZZZ".

015

STUD

01502

01502:     E015 (Home postcode) "ZZZZ" but E049 (Cit.Res) is SA or PR.

Fatal

If E015 (Home postcode) is coded "ZZZZ", then:

E049 (Citizen-resident status) must not be coded "SA" or "PR".

015,

049

STUD

01503

01503:     E015 (Home postcode) XXXX or YYYY where E024 (Att mode) is “C” and E049 (Cit.Res) of "SA" or “PR”.

Warning

If E024 (Attendance mode) is coded “C” AND E049 (Citizen-resident status) is coded "SA" or “PR”, then:

normally, E015 (Home postcode) would not be coded "XXXX" or "YYYY".

Note:  The institution needs to check to make sure that the coding for this element is correct.  If it is correct then this error can be ignored.

015,

024,

049

STUD

01601

01601:     E016 (Disability status) is not a valid code.

Fatal

If the collection year is 2001 or later then E016 (Disability status) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

016

STUD

01701

01701:     E017 (Socio-economic status) is not a valid code.

Fatal

If the collection year is 2001 or later then E017 (Socio-economic status) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

017

STUD

01801

01801:     E018 (Funding status) is not a valid code.

Fatal

If the Collection Year is greater than 1999, then the value for E018 (Funding status) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

018

CREG

01901

01901:     E019 (NSFAS status) is not a valid code.

Fatal

E019 (NSFAS status) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

019

STUD

02001

02001:     E020 (Institutional housing) is > 1, or is < 0

Fatal

If this is the 2nd or 3rd submission, then:

the value for E020 (Institutional housing) must meet all these criteria:

     it is a real number; AND

     the number is composed of only the digits "0" to "9" or decimal point, AND

     any space characters are leading or trailing characters, AND

     there is not more than one decimal point

     there are no "+" or "-" signs and

     is not > 1

020

STUD