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 021**   TO   030**

 

ERROR No.

ERROR MESSAGE TO APPEAR ON VALIDATION REPORT

ERROR TYPE

VALIDATION RULE

ELEMENT BEING TESTED

TABLES USING THE VALID-ATION

02101

02101:     E021 (Previous year's activity) is not a valid code.

Fatal

The value for E021 (Previous year's activity) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

021

STUD

02102

02102:     E021 (Prev. year's activity) is ZZ, but E010 (Entr. cat) is F or T.

Fatal

If the value of E021 (Previous year's activity) is "ZZ", then:

the value of E010 (Entrance category) must be other than "F" or "T".

021,

010

STUD

02201

02201:     E022 (Secondary ed. completed) is not a valid code.

Fatal

The value for E022 (Secondary ed. completed) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

022

STUD

02202

02202:     E022 (Sec. ed. compl.) is ZZ, but E010 (Entr. cat) or E005 (Qual type) is inappropriate.

Fatal

If E022 (Secondary education completion) is "ZZ", then one or both of these conditions must be true:

(a)  E010 (Entrance category) is NOT "F"  OR

(b)  the value of E005 (Qualification type) in the matching record in the Qualification Table is NOT any of these: 01, 11, 02, 03, 21, 22, or 23.

      The matching record is the one which has the same value for E001 (Qualification code) as in the record in the Student Table

022,

010

STUD

02301

02301:     E023 (Matric. aggregate) is outside range of 0 to 2600

Fatal

The value for E023 (Matriculation aggregate) must meet all these criteria:

*    it is zero or an integer AND

*    the number is composed of only the digits "0" to "9", AND

*    any space characters are leading or trailing characters,

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

*    is not > 2600.

023        

STUD

02302

02303:     E023 (Matric. agg.) is zero or -ve, but E010 (Entr. cat)  or E005 (Qual type) is inappropriate

Fatal

If the VAL of E023 (Matriculation aggregate) is zero or less,  then one or both of these conditions must be true:

(a)  E010 (Entrance category) must NOT be "F"

(b)  the value of E005 (Qualification type) in the matching record in the Qualification Table must NOT be any of these: 01, 11, 02, 03, 21, 22, or 23.

The matching record is the one which has the same value for E001 (Qualification code) as in the record in the Student Table.

 

Note:  The VAL function will convert alphabetic values to zero.

023,

010

STUD

02401

02401:     E024 (Attendance mode) is not a valid code.

Fatal

If the submission is Sub 1 year 2000 or earlier, then E024 (Attendance mode) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

024

STUD

02402

02402:     E024 (Attendance mode) "C" inconsistent with course mode.

Warning

If the submission is Sub 1 year 2000 or earlier, AND E024 (Attendance mode) is coded "C" then the courses undertaken must be coded either:

"C" on E059 (Contact-only mode availability) or

"M" on E061 (Mixed mode availability).

The "courses undertaken" are identified through finding all the records in the Course Registrations Table which have a matching value for E007 (Student number) concatenated with E001 (Qualification code), then:

for each such record, finding the record in the Course Table which has a matching value on E030 (Course code).

024,

059,

061

CREG

02403

02403:     E024 (Attendance mode) "D" inconsistent with course mode.

Warning

If the submission is Sub 1 year 2000 or earlier, AND E024 (Attendance mode) is coded "D" then the courses undertaken by the student must be coded either:

"D" on E060 (Distance-only mode availability) or

"M" on  E061 (Mixed mode availability).

The "courses undertaken" are identified through finding all the records in the Course Registrations Table which have a matching value for E007 (Student number) concatenated with E001 (Qualification code), then:

for each such record, finding the record in the Course Table which has a matching value on E030 (Course code).

024,

060,

061

CREG

02501

02501:     E025 (Qualifications requirement status) is not a valid code.

Fatal

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

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

025

STUD

02502

02502:     E025 (Qual. req. status) code "F" or "W" also occurred in prior year's table.

Fatal

If the collection year is 2000 or later, AND E025 (Qualifications requirement status) is coded "F" or "W", AND in the STUD table for the prior collection year, there is a matching record for this student/qualification, then:

the value for E025 (Qualifications requirement status) in that prior year's record must not be coded "F" or "W". 

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

025

STUD

02503

02503:     E025 (Qual. req. status) may not be "F" or "W" in the first submission

Fatal

E025 (Qualifications requirement status) may not be coded "F" or "W" for the first submission. 

025

STUD

02601

02601:     E026 (CESM for 1st area of spec.) is not a valid code.

Fatal

E026 (CESM category for first area of specialisation) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

026

STUD

02602

02602:     E026 (CESM for 1st area of spec.) is “ZZZZ”.

Fatal

E026 (CESM category for first area of specialisation) must not be “ZZZZ”.

026

STUD

02701

02701:     E027 (CESM for 2nd area of spec.) is not a valid code.

Fatal

E027 (CESM category for second area of specialisation) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

027

STUD

02702

02702:     E027 (CESM for 2nd area of spec.) is same as another area of spec.

Fatal

If E027 (CESM category for second area of specialisation) is NOT "ZZZZ", then its value must be different to the values for E026 (CESM category for first area of specialisation), E028 (CESM category for third area of specialisation) and E029 (CESM category for fourth area of specialisation).

027,

026,

028,

029

STUD

02801

02801:     E028 (CESM for 3rd area of spec.) is not a valid code.

Fatal

E028 (CESM category for third area of specialisation) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

028

STUD

02802

02802:     E028 (CESM for 3rd area of spec.) is same as another area of spec.

Fatal

If E028 (CESM category for third area of specialisation) is NOT "ZZZZ", then its value must be different to the values for E026 (CESM category for first area of specialisation), E027 (CESM category for second area of specialisation) and E029 (CESM category for fourth area of specialisation).

028,

026,

027,

029

STUD

02901

02901:     E029 (CESM for 4th area of spec.) is not a valid code.

Fatal

E029 (CESM category for fourth area of specialisation) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

029

STUD

02902

02902:     E029 (CESM cat. for 4th area of spec.) is same as another area of spec.

Fatal

If E029 (CESM category for fourth area of specialisation) is NOT "ZZZZ", then its value must be different to the value for E026 (CESM category for first area of specialisation), and E027 (CESM category for second area of specialisation) and E028 (CESM category for third area of specialisation).

029,

026,

027,

028

STUD

03001

03001:     E030 (Course code) is blank.

Fatal

E030 (Course code) must not be all spaces or a null.

030

CREG

CRSE

CRED

03002

03002:     E030 (Course code) duplicated in another record.

Fatal

The value of E030 (Course code) must not be duplicated in another record in the Course Table.

030

CRSE

03003

03003:     E030 (Course code) not found in Course Table

Fatal

The value for E030 (Course code) must appear as the value of E030 (Course code) in some record in the Course Table.

030

CREG