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: 22 June 2016

 

EDIT VALIDATION RULES 001**   TO   010**

 

ERROR No.

ERROR MESSAGE TO APPEAR ON VALIDATION REPORT

ERROR TYPE

VALIDATION RULE

ELEMENT BEING TESTED

TABLES USING THE VALID-ATION

00101

00101:     E001 (Qualification code) is blank.

Fatal

E001 (Qualification code) must not be all spaces or a null.

001

STUD

QUAL

CREG

CRED

CESM

00102

00102:     E001 (Qualification code) duplicated in another record.

Fatal

The value for E001 (Qualification code) must not be duplicated in another record in the table.

001

QUAL

00103

00103:     E001 (Qualification code) not found in Qualification Table.

Fatal

The value for E001 (Qualification code) must appear in some record in the Qualification Table.

001

STUD

CREG

00104

00104:     E001 (Qual code) + E030 (Course code) is duplicated in another record.

Fatal

The value of E001 (Qualification code) concatenated with E030 (Course code) must not appear in another record in the table.

001,

030

CRED

00105

00105:     E001 (Qual code)) + E030  (Course code) not found in Cred. Value Table.

Fatal

The value of E001 (Qualification code) concatenated with E030 (Course code) must appear in some record in the Credit Value Table.

001,

030

CREG

00106

00106:     E001 (Qual code) + E006 (Maj. CESM) duplicated in another record.

Fatal

The value of E001 (Qualification code) concatenated with E006 (Major CESM field) must not be duplicated in another record in the table.

001,

006

CESM

00107

00107:     E001 (Qual code) credit values summed for foundation courses must not be less than 0.5 or greater than 1.00

Warning

The total value for E036 (Course credit value) for E001 (Qualification code), E030 (Course Code) combination must not be less than 0.5 or greater than 1.0

001,

036

CESM

00201

00201:     E002 (Previous year's qual code) is blank.

Fatal

E002 (Previous year's Qualification code) must not be all spaces or a null.

002

QUAL

00202

00202:     E002 (Previous year's qual code) differs from E001 (Qual. code).

Warning

Normally, the value of E002 (Previous year's Qualification code) would be the same as the value for E001 (Qualification code).

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.

002,

001

QUAL

00301

00301:     E003 (Qualification name) is blank.

Fatal

E003 (Qualification name) must not be all spaces or a null.

003

QUAL

00401

00401:     E004 (Approval status) is not a valid code.

Fatal

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

004

QUAL

00402

00402:     E004 (Approval status) code "A" not OK with E005 (Qual. type) "ZZ".

Fatal

If the value for E004 (Approval status) is "A" then:

the value for E005 (Qualification type) must NOT be "ZZ".

004,

005

QUAL

00501

00501:     E005 (Qualification type) is not a valid code.

Fatal

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

005

QUAL

00502

00502:     E005 (Qual. type) is not research type, but E034 (Course level) is research.

Warning

If  the value of E005 (Qualification type) looked up in the Qualification table, using E001 (Qualification code) as the key is other than 07, 08, 27, 28, 29, 30, 49, 50, 72, 73, 74 or 75, then the value of E034 (Course level code) looked up in the Course Table using E030 (Course code) as the key, would normally NOT be 07, 09, 28, 30, 32, 34, 47 or 49.

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.

005,

034

CREG

00503

00503:     E005 (Qualification type) must be 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73,74,75 or ZZ if E084 (Legacy indicator) = "Y".

Fatal

If the value of E084 (Legacy indicator) is ‘Y’ then the value of E005 (Qualification type) must be 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73,74, 75 or ZZ.

005,

084

QUAL

00504

00504:     E005 (Qualification type) is 47 but E034 (Course level code) 05 or E005 (Qualification type) is 69 but E034 (Course level code) 44 or 45.

Fatal

If the value of E005 (Qualification type) is 47 then the value of E034 (Course level code) looked up in the Course Table using E030 (Course code) as the key, must be 05 or if the value of E005 (Qualification type) is 69 then the value of E034 (Course level code) looked up in the Course Table using E030 (Course code) as the key, must be 44 or 45.

005,

034,

084

QUAL

00505

00505:     E005 (Qualification type) is 04 but E034 (Course level code) not 01, 02, 03 or 04.

Fatal

If the value of E005 (Qualification type) is 04 then the value of E034 (Course level code) looked up in the Course Table using E030 (Course code) as the key, must be 01, 02, 03 or 04.

005,

034

QUAL

00601

00601:     E006 (Major field CESM) not a valid code.

Fatal

The value for E006 (Major field CESM) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

006

CESM

00602

00602:     E006 (Major field CESM) is "ZZZZ" but E005 (Qual. type) not "ZZ".

Fatal

If E006 (Major field CESM) is "ZZZZ", then E005 (Qualification type) must be "ZZ".

006,

005

CESM

00701

00701:     E007 (Student number) is blank.

Fatal

E007 (Student number) must not be all spaces or a null.

007

STUD

CREG

00702

00702:     E007 (Stud. num.) not found in Student Table; not all E051 records = “E”

Fatal

If all values for E051 (Examination-only indicator) are not “E” then the value for E007 (Student number) must appear in some record in the Student Table.

007

CREG

00703

00703:     E007 (Stud. num.) + E001 (Qual. code) not found in CREG; E025 = “F” or “W”

Warning

If the value of E025 (Qualification requirements status) is “F” or “W” then normally the value for E007 (Student number)  concatenated with E001 (Qualification code) would appear in some record in the Course Registration Table.

007

STUD

00704

00704:     E007 (Stud. num.) + E001 (Qual. code) duplicated in another record.

Fatal

The value for E007 (Student number)  concatenated with E001 (Qualification code)  must not be duplicated in another record in the table.

007,

001

STUD

00705

00705:     Data for other records with same E007 (Stud. num.) inconsistent.

Fatal

If the value for E007 (Student number) appears in another record, then:

in this record and the other record, the values for these elements must match:

E008 (South African identity number)

E011 (Date of birth),

E012 (Gender),

E013 (Race),

E014 (Nationality),

E049 (Citizen-resident),

E052 (Home language)

007,

008,

011,

012,

013,

014,

049,

052

STUD

00706

00706:     E007 (Stud. num.) + E001 (Qual. code) not in CREG but E025<>F.

Fatal

If this is the 2nd or 3rd submission, then if the value for E025 (Qualification requirement status) is other than "F", then the value for E007 (Student number) concatenated with E001 (Qualification code) must appear in some record in the Course Registration Table.

007,

001

STUD

00707

00707:     E007 (Stud. num.) not found in Student Table; all E051 records = “E”

Warning

If all values for E051 (Examination-only indicator) are “E” then the value for E007 (Student number) normally appear in some record in the Student Table.

007

CREG

00708

00708:     E007 (Stud. Num.) + E001 (Qual. Code) not found in Student Table; not all E051 records = “E”

Warning

If not all values for E051 (Examination-only indicator) are “E” then the value for E007 (Student number) concatenated with E001 (Qualification code) must appear in some record in the Student Table.

007,

001

CREG

00801

00801:     E008 (South African identity number) is blank.

Fatal

The value of E008 (South African identity number) must not be all spaces or a null.

008

STUD

00802

00802:     E008 (SA ident. number) "Z…" inconsistent with E049 (Cit.-res).

Fatal

If the value for  E008 (South African identity number)  is "ZZZZZZZZZZZZZZZ" then:

the value for E049 (Citizen-resident status) must NOT be "SA"

008,

049

STUD

00803

00803:     E008 (SA ident. number) does not contain numbers.

Fatal

The value for  E008 (South African identity number)  may only contain numbers:

where the value for E049 (Citizen-resident status) is "SA"

008,

049

STUD

00804

00804:     E008 (SA ident. number) length <> 13.

Fatal

The value for  E008 (South African identity number)  excluding any spaces must be exactly 13:

where the value for E049 (Citizen-resident status) is "SA"

008,

049

STUD

00805

00805:     E008 (SA ident. number) first six digits not a valid date.

Fatal

The value for  E008 (South African identity number)  must start with a valid date:

where the value for E049 (Citizen-resident status) is "SA"

008,

049

STUD

00806

00806:     E008 (SA ident. number) 7th to 10th digits contains 0000.

Fatal

The value for  E008 (South African identity number)  may not contain 0000 from characters 7 to 10:

where the value for E049 (Citizen-resident status) is "SA"

008,

049

STUD

00807

00807:     E008 (SA ident. number) not equal to birthdate.

Fatal

The value for the first six characters of E008 (South African identity number)  must correspond to the birthdate in E011 (Date of Birth):

 

where the value for E049 (Citizen-resident status) is "SA"

008,

011,

049

STUD

00808

00808:     :     E008 (SA ident. number) not equal to E012.

Warning

The value for characters 7 to 10 of E008 (South African identity number)  must correspond to the value in Element 012 (Gender) where coded F or M:

 

where the value for E049 (Citizen-resident status) is "SA"

008,

012,

049

STUD

00809

00809:     E008 (SA ident. number) linked to more than one E007 (Student number).

Fatal

The value for E008 (South African identity number) can only be linked to one E007 (Student number).

008,

007

STUD

00810

00810:     E008 (SA ident. number) + E001 (Qual. code) duplicated in another record.

Fatal

The value for E008 (South African identity number)  concatenated with E001 (Qualification code)  must not be duplicated in another record in the table.

008,

001

STUD

00901

00901:     E009 (Qual. commence. date) is not a valid yyyymmdd date.

Fatal

E009 (Qualification commencement date) must be a valid date of the calendar, and in yyyymmdd format.

009

STUD

00902

00902:     E009 (Qual. commence. date) is later than 15 September.

Fatal

If this is the first submission, then:

E009 (Qualification commencement date) must not be later than 15 September in the collection year.

009

STUD

00903

00903:     E009 (Qual. commence. date) is later than 31 December.

Fatal

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

E009 (Qualification commencement date) must not be later than 31 December in the collection year.

009

STUD

00904

00904:     E009 (Qualification commencement date) over 40 years ago.

Warning

E009 (Qualification commencement date) must not be before 31 December of the year that is 39 years prior to the collection year.

009

STUD

00905

00905:     E009 (Qual. commence. date) between 25 and 40 years ago.

Warning

Normally, E009 (Qualification commencement date) would not be between 31 December of the year that is 39 years prior to the collection year, and 31 December of the year that is 24 years prior to 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.

009

STUD

01001

01001:     E010 (Entrance category) is not a valid code.

Fatal

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

010

STUD

01002

01002:     E010 (Entr. cat.) code is "F" or "T" but student-qual is in prior year's STUD table.

Fatal

If the collection year is 2000 or later, AND E010 (Entrance category) is coded "F" or "T" then:

in the STUD table for the most recent submission for the prior collection year there must not be a matching record for the student-qualification. 

Note:  "matching record for this student-qualification" means a record with a matching value for E007 (Student number) concatenated with E001 (Qualification code).

010

STUD

01003

01003:     E010 (Entr. cat.) code is "N" but student-qual is NOT in prior year's STUD table.

Warning

If the collection year is 2000 or later, AND E010 (Entrance category) is coded "N" then: normally, in the STUD table for the most recent submission for the prior collection year there would be a matching record for the student-qualification. 

Note:  "matching record for this student-qualification" means a record with a matching value for E007 (Student number) concatenated with E001 (Qualification code).

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.

010

STUD

01004

01004:     E010 (Entr. cat.) code is "F" but E021 (Sec. ed.) indicates prior higher ed.

Warning

If E010 (Entrance category) is coded "F" AND E005 (Qualification type) is coded "01", “11”, "02", "03", "21", "22", or "23" then: normally, E021(Previous year's activity) would NOT be coded "01", "02" or "03".

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.

010,

021

STUD