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 031**   TO   040**

 

ERROR No.

ERROR MESSAGE TO APPEAR ON VALIDATION REPORT

ERROR TYPE

VALIDATION RULE

ELEMENT BEING TESTED

TABLES USING THE VALID-ATION

03101

03101:     E031 (Course approval status) is not a valid code.

Fatal

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

031

CRSE

03201

03201:     E032 (Course completion status) not a valid code.

Fatal

If this is the 2nd or 3rd submission of the Course Registrations Table, then:

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

032

CREG

03301

03301:     E033 (Course CESM) is not a valid code.

Fatal

E033 (Course CESM) must be a code specified in the Data Element Dictionary as being valid for this element.

033

CRSE

03302

03302:     E033 (Course CESM) is “ZZZZ”.

Fatal

E033 (Course CESM) must not be "ZZZZ".

033

CRSE

03401

03401:     E034 (Course level code) is not a valid code.

Fatal

E034 (Course level code) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

034

CRSE

03402

03402:     E034 (Course level code) must equal element 092 (NQF Level)

Fatal

E034 (Course level code) must be the same level as E092 (NQF Level).

034,

092

CRSE

03601

03601:     E036 (Course credit value) is -ve or greater than 1.

Fatal

The value for E036 (Course credit value) must not be negative or greater than 1.

036

CRED

03602

03602:     E036 (Course cred.) sum, excl. Exam-only and Experiential is > 2.0.

Fatal

If the submission number is 2 or 3 then the value for E036 (Course credit value) aggregated across all records for the courses being undertaken for the student's qualification but excluding those coded “E” on E051 (Examination-only indicator) or “E” on E062 (Experiential training indicator) must not be greater than 2.0.

Note:  the aggregated value for the qualification for the student is calculated thus:

(a) Get the set of records in the CREG table that have an identical value for E007 (Student number) concatenated with E001 (Qualification code).  Note:  there will usually be more than one record in the set, but there might only be one record in the set.

(b) For each record in the set, find a matching record in the CRED table.  The match is to be in terms of the value for E001 (Qualification code) concatenated with E030 (Course code).

(c) From the matching records in the CRED table, add all the values reported for E036 (Course credit value).

036

STUD

03603

03603:     E036 (Course cred.) sum, excl. Exam-only, Experiential & Repeats is > 1.5

Fatal

If the submission number is 2 or 3 then the value for E036 (Course credit value) aggregated across all records for the courses being undertaken for a qualification, but excluding repeat courses and those coded “E” on E051 (Examination-only indicator) or “E” on E062 (Experiential training indicator) must not be greater than 1.5

Note:  the aggregated value for the qualification for the student is calculated thus:

(a) Get the set of records in the CREG table that have an identical value for E007 (Student number) concatenated with E001 (Qualification code) concatenated with E030 (Course code).  Note:  there will usually be more only one record in the set, but there might only be more than one record in the set.

(b) For the first record in the set, find a matching record in the CRED table.  The match is to be in terms of the value for E001 (Qualification code) concatenated with E030 (Course code).

(c) Accumulate the value of E036 (Course credit value) in the sum of the credit values.

(d) See if there is another set of records in the CREG table which have an identical value for E007 (Student number) concatenated with E001 (Qualification code) concatenated with E030 (Course code), but which is a different set to the set just processed.  If there is such a set, repeat steps (b) and (c), accumulating the value found for E036 (Course credit value) in the sum of the credit values.

(e) Repeat the above steps until all records for the particular Student/Qualification (defined by E007 (Student number) concatenated with E001 (Qualification code) have been processed.

036

STUD

03604

03604:     E036 (Course cred.) sum, excl. Exam-only, Experiential & Repeats is 1.2 to 1.5

Warning

If the submission number is 2 or 3 then normally, the value for E036 (Course credit value) aggregated across all records for the courses being undertaken for the student's qualification, but excluding repeat courses and those coded “E” on E051 (Examination-only indicator) or “E” on E062 (Experiential training indicator) would not be 1.2 to 1.5

Note:  the aggregated value for the qualification for the student is calculated thus:

(a) Get the set of records in the CREG table that have an identical value for E007 (Student number) concatenated with E001 (Qualification code) concatenated with E030 (Course code).  Note:  there will usually be more only one record in the set, but there might only be more than one record in the set.

(b) For the first record in the set, find a matching record in the CRED table.  The match is to be in terms of the value for E001 (Qualification code) concatenated with E030 (Course code).

(c) Accumulate the value of E036 (Course credit value) in the sum of the credit values.

(d) See if there is another set of records in the CREG table which have an identical value for E007 (Student number) concatenated with E001 (Qualification code) concatenated with E030 (Course code), but which is a different set to the set just processed.  If there is such a set, repeat steps (b) and (c), accumulating the value found for E036 (Course credit value) in the sum of the credit values.

(e) Repeat the above steps until all records for the particular Student/Qualification (defined by E007 (Student number) concatenated with E001 (Qualification code) have been processed.

036

STUD

03605

03605:     E036 (Course credit value) is zero.

Warning

If the submission number is 2 or 3 then the value for E036 (Course credit value) is normally not zero.

036

CRED

03701

03701:     E037 (Staff number) is blank.

Fatal

E037 (Staff number) must not be all spaces or a null.

037

PROF

SFTE

03702

03702:     E037 (Staff num.) + E039 (Pers. cat.) not in Staff FTE Table.

Fatal

The value for E037 (Staff number) concatenated with E039 (Personnel category) must appear in some record in the Staff FTE Table.

037,

039

PROF

03703

03703:     E037 (Staff num.) + E039 (Pers. cat.) not in Staff Profile Table.

Fatal

The value for E037 (Staff number) concatenated with E039 (Personnel category) must appear in some record in the Staff Profile Table.

037,

039

SFTE

03704

03704:     E037 (Staff num.) + E039 (Pers. cat.) duplicated in another record.

Fatal

The value of E037 (Staff number) concatenated with E039 (Personnel category) must not appear in another record in the table.

037,

039

PROF

03705

03705:     E037 (Staff num.) in other records but profile differs.

Fatal

If the value of E037 (Staff number) appears in more than one record, then:

the values for these elements must be constant across all the records:

011 (Date of birth),

012 (Gender),

013 (Race),

014 (Nationality)

037,

011,

012,

013,

014

PROF

03706

03706:     E037 + E039 + E044 + 045 is duplicated in another record.

Fatal

The value of E037 (Staff number) concatenated with E039 (Personnel category), concatenated with E044 (Staff programme), concatenated with E045 (Staff programme CESM) must not appear in another record in the table.

037,

039,

044,

045

SFTE

03801

03801:     E038 (Employ. comm. year) not a valid year in yyyy format.

Fatal

E038 (Employment commencement year) must be a valid year in yyyy format.

038

PROF

03802

03802:     E038 (Employ. comm. yr) later than the Collection year

Fatal

E038 (Employment commencement year) must not be later than the collection year.

038

PROF

03803

03803:     E038 (Employ. comm. year) more than 65 years ago.

Fatal

The E038 (Employment commencement year) must not be earlier than 65 years prior to the collection year.

038

PROF

03804

03804:     E038 (Employ. comm. year) 40 to 65 years ago.

Warning

Normally, E038 (Employment commencement year) would not be between 40 and 65 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.

038

PROF

03805

03805:     E038 (Employ. comm. year) is before the person was aged 16.

Fatal

The value of E038 (Employment commencement year) must not be less than this value:

VAL(1st 4 digits of E011 (Date of birth)) plus 15.

038

PROF

03901

03901:     E039 (Personnel category) is not a valid code.

Fatal

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

039

PROF

SFTE

04001

04001:     E040 (Rank of staff member) is not a valid code.

Fatal

E040 (Rank of staff member) must be one of the codes specified in the Data Element Dictionary as being valid for this element.

040

PROF

04002

04002:     E040 (Rank of staff) code "Z" not OK for E039 (Pers. cat.) of "01".

Fatal

If E040 (Rank of staff member) is "ZZ", then:

E039 (Personnel category) must NOT be "01"

040,

039

PROF