|
Return to: |
|||
Edition: 20 January 2009
EDIT VALIDATION RULES
041** TO 050**
|
ERROR
No. |
ERROR
MESSAGE TO APPEAR ON VALIDATION REPORT |
ERROR
TYPE |
VALIDATION
RULE |
ELEMENT
BEING TESTED |
FILES
USING THE VALID-ATION |
|
04101:
E041 (Permanent/ temporary status) is not a valid code. |
Fatal |
E041 (Permanent/
temporary status) must be one of the codes specified in the Data Element
Dictionary as being valid for this element. |
041 |
PROF |
|
|
04201:
E042 (Full-time/part-time status) is not a valid code. |
Fatal |
E042
(Full-time/part-time status) must be one of the codes specified in the
Data Element Dictionary as being valid for this element. |
042 |
PROF |
|
|
04202:
E042 (FT/PT status) is PT but E043 (Staff FTE value) > 0.9 |
Warning |
If the value for E042
(Full-time/part-time status) is "PT" then: normally, in the records in the SFTE table which have a matching value for E037 (Staff number) concatenated with E039 (Personnel category), the sum of all the values for E043 (Staff FTE value) in those SFTE records would not be greater than 0.9. 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. |
042, 043 |
PROF |
|
|
04301:
E043 (Staff FTE value) is 0, or greater than 1. |
Fatal |
The value for E043
(Staff FTE value) must greater than 0 and not greater than 1. |
043 |
SFTE |
|
|
04302:
Sum of E043 (Staff FTE value) for one person is > 1.5 |
Fatal |
The value for E043
(Staff FTE value) aggregated for the set of records that have an
identical value for E037 (Staff number)
must not be greater than 1.5. |
043 |
PROF |
|
|
04303:
Sum of E043 (Staff FTE value) for one person is > 1.0 but not >
1.5 |
Warning |
The value for E043
(Staff FTE value) aggregated for the set of records that have an
identical value for E037 (Staff number)
would normally not be in this range: 1.000001 to 1.5. |
043 |
PROF |
|
|
04401:
E044 (Staff programme) is not a valid code. |
Fatal |
E044 (Staff
programme) must be one of the codes specified in the Data Element
Dictionary as being valid for this element.. |
044 |
SFTE |
|
|
04501:
E045 (Staff programme CESM) is not a valid
code. |
Fatal |
E045 (Staff
programme CESM) must be one of the codes
specified in the Data Element Dictionary as being valid for this element.. |
045 |
SFTE |
|
|
04502:
E045 (Staff prog.CESM) of ZZZZ not OK for
E044 (Staff prog.) 010 or 020. |
Fatal |
If the value for E045
(Staff programme CESM) is "ZZZZ",
then: the value of E044 (Staff programme) must be other
than "010" or "020". |
045, 044 |
SFTE |
|
|
04601:
E046 (Qualification type) is not a valid code. |
Fatal |
If E041
(Permanent/ temporary status) is "PE" then: E046
(qualification type) must be one of the codes specified in the Data
Element Dictionary as being valid for this element. |
046, 041 |
PROF |
|
|
04602:
E046 (Qual. type) "ZZ" not OK for
E039 (Pers. cat.) of "01". |
Fatal |
If E041
(Permanent/ temporary status) is "PE" then: If E046
(Qualification type) is "ZZ", then: E039 (Personnel
category) must NOT be "01". |
046, 041, 039 |
PROF |
|
|
04603 |
04603:
E046 (Qualification type) is not a valid code. |
Warning |
If E041
(Permanent/ temporary status) is "TE" then: E046
(qualification type) must be one of the codes specified in the Data
Element Dictionary as being valid for this element. |
046, 041 |
PROF |
|
04604 |
04604:
E046 (Qual. type) "ZZ" not OK for
E039 (Pers. cat.) of "01". |
Warning |
If E041
(Permanent/ temporary status) is "TE" then: If E046
(Qualification type) is "ZZ", then: E039 (Personnel
category) must NOT be "01". |
046, 041, 039 |
PROF |
|
04701:
E047 (Joint appointment) is not a valid code. |
Fatal |
E047 (Joint
appointment) must be one of the codes specified in the Data Element
Dictionary as being valid for this element. |
047 |
PROF |
|
|
04801:
E048 (On payroll code) is not a valid code. |
Fatal |
E048 (On payroll
code) must be one of the codes specified in the Data Element Dictionary as
being valid for this element. |
048 |
PROF |
|
|
04901:
E049 (Citiz-resident status) is not a valid
code. |
Fatal |
E049
(Citizen-resident status) must be one of the codes specified in the Data Element
Dictionary as being valid for this element. |
049 |
STUD |
|
|
04902:
E049 (Citiz-resident status) is
"SA" but E014 (National.) code not "SAF". |
Fatal |
If E049
(Citizen-resident status) is coded "SA" then E014 (Nationality) must be coded "SAF" (prior 2011) or "ZAF" |
049, 014 |
STUD |
|
|
05001:
E050 (Completed resh. crse.
credit) is greater than 2 |
Fatal |
The value for E050
(Completed research course credit value) must not be greater than 2. |
050 |
CRED |
|
|
05003:
E050 (Completed resh. crse.
credit) value is missing |
Fatal |
The value for E050
(Completed research course credit value) cannot be blank. |
050 |
CRED |