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

DATA ELEMENTS 501 TO 510

ELEMENT NUMBER/NAME:	501 Qualification commencement date group.
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	COMDAT1
DESCRIPTION:	Derived groups for data from Element 009 (Qualification commencement date).
CODE FORMAT:	Data type:	Text
	Format:
	Width:	1

CLASSIFICATION:	Code	Meaning	Derivation
	A	Later than 31 Dec. of Collection Year	Derive from comparing value of E009 with date indicated under "meaning".
	B	16 Sep. to 31 Dec. of Collection Year	Derive from comparing value of E009 with date indicated under "meaning".
	C	1 Jan. to 15 Sep. of Collection Year	Derive from comparing value of E009 with date indicated under "meaning".
	D	16 Sep. to 31 Dec. of Year prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	E	1 Jan. to 15 Sep. of year prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	F	In the year that is 2 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	G	In the year that is 3 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	H	In the year that is 4 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	I	In the year that is 5 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	J	In the year that is 6 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	K	In the year that is 7 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	L	In a year that is 8 to 10 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	M	In a year that is 11 to 15 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	N	In a year that is 16 to 20 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	O	In a year that is more than 20 years prior to Colln. Yr.	Derive from comparing value of E009 with date indicated under "meaning".
	Z	Cannot be determined	Not one of the above.

CODING NOTES:
PREPARED ON:	18 August 1999

ELEMENT NUMBER/NAME:	502 Age group.
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	AGEGROUP
DESCRIPTION:	Age group derived from data from Element 011 (Date of birth) relative to the date if 1 January of the Collection Year.

CODE FORMAT:	Data type:	Text
	Format:
	Width:	8

CLASSIFICATION:		Code	Meaning	Derivation
	< 18 yrs		< 18 yrs	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	18		18	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	19-20		19-20	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	21-22		21-22	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	23-24		23-24	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	25-29		25-29	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	30-34		30-34	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	35-39		35-39	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	40-44		40-44	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	45-49		45-49	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	50-54		50-54	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	55-59		55-59	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	60-65		60-65	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	>65		>65	Derive from Element 011 (Date of birth) relative to the date of 1 January in the Collection Year.
	ZZZZZZZZ		Cannot be determined	Not one of the above.

CODING NOTES:
PREPARED ON:	18 August 1999

ELEMENT NUMBER/NAME:	503 Institutional housing amount group.
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	HOUSIN1
DESCRIPTION:	Institutional housing group categories derived from data from Element 020 (Institutional housing).

CODE FORMAT:	Data type:	Text
	Format:
	Width:	12

CLASSIFICATION:	Code	Meaning	Derivation
	No usage	No usage of institutional housing	Value of E020 (Institutional housing) is 0 (zero)
	>0 to 0.1	Usage >0 to 0.1% of academic year	Value of E020 (Institutional housing) is greater than 0 and not greater than 0.1
	> 0.1 to 0.2	Usage > 0.1 to 0.2 of academic year.	Value of E020 (Institutional housing) is greater than 0.1 and not greater than 0.2
	>0.2 to 0.3	Usage >0.2 to 0.3 of academic year	Value of E020 (Institutional housing) is greater than 0.2 and not greater than 0.3
	>0.3 to 0.4	Usage >0.3 to 0.4 of academic year	Value of E020 (Institutional housing) is greater than 0.3 and not greater than 0.4
	>0.4 to 0.5	Usage >0.4 to 0.5 of academic year	Value of E020 (Institutional housing) is greater than 0.4 and not greater than 0.5
	>0.5 to 0.6	Usage >0.5 to 0.6 of academic year	Value of E020 (Institutional housing) is greater than 0.5 and not greater than 0.6
	>0.6 to 0.7	Usage >0.6 to 0.7 of academic year	Value of E020 (Institutional housing) is greater than 0.6 and not greater than 0.7
	>0.7 to 0.8	Usage >0.7 to 0.8 of academic year	Value of E020 (Institutional housing) is greater than 0.7 and not greater than 0.8
	>0.8 to 0.9	Usage >0.8 to 0.9 of academic year	Value of E020 (Institutional housing) is greater than 0.8 and not greater than 0.9
	>0.9 to 0.95	Usage >0.9 to 0.95 of academic year	Value of E020 (Institutional housing) is greater than 0.9 and not greater than 0.95
	> 0.95	Usage > 0.95 to 1.0 of academic year	Value of E020 (Institutional housing) is greater than 0.95 and not greater than 1.0
	> 1.0	Usage > 1.0 of academic year	Value of E020 (Institutional housing) is greater than 1.0
	ZZZZZZZZZZZZ	Cannot be determined	Not one of the above.

CODING NOTES:
PREPARED ON:	31 January 2000

ELEMENT NUMBER/NAME:	504 Previous year's activity (recoded).
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	PREVAC1
DESCRIPTION:	Element 021 (Previous year's activity) plus indicator for not being a first-time entering or transfer student.
CODE FORMAT:	Data type:	Text
	Format:
	Width:	2

CLASSIFICATION:	Code	Meaning	Derivation
	00	Not a first-time entering or transfer student (FTEN/T)	Element 010 (Entrance category) is NOT "F" and is NOT "T".
	01	FTEN/T who was university student in prior year	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "01".
	02	FTEN/T who was technikon student	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "02".
	03	FTEN/T who was higher education college student	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "03".
	04	FTEN/T who was technical college student	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "04".
	05	FTEN/T who was secondary school student	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "05".
	06	FTEN/T who was in labour force	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "06".
	07	FTEN/T who was unemployed	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "07".
	08	FTEN/T who was in foreign post-secondary education institution	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "08".
	09	FTEN/T student who was in other activity	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "09".
	99	FTEN/T student but activity unknown	Element 010 (Entrance category) is "F" or "T", AND Element 021 (Prev. year's activity) is "99".
	ZZ	Cannot be determined	Not one of the above.

CODING NOTES:
PREPARED ON:	5 August 1999

ELEMENT NUMBER/NAME:	505 Secondary education completion (recoded).
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	SECED1
DESCRIPTION:	Element 022 (Secondary education completion) plus indicator for not being a first-time entering student.

CODE FORMAT:	Data type:	Text
	Format:
	Width:	2

CLASSIFICATION:	Code	Meaning	Derivation
	00	Not a first-time entering student (FTEN)	Element 010 (Entrance category) is NOT "F".
	01	FTEN with Senior Cert. Endorse. or CPU Cert. of Cond. Exempt.	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "01".
	02	FTEN with Ordinary Cond. Cert. of Exemption	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "02".
	03	FTEN with Cond. Cert. of Exempt. - Mature Age	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "03".
	04	FTEN with Cond. Cert. of Exempt. - Foreigner	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "04".
	05	FTEN with Cond. Cert. of Exempt. - Immigrant	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "05".
	06	FTEN with Cond. Cert. of Exempt. - Senate power	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "06".
	07	FTEN with senior certificate other than above	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "07".
	08	FTEN with NTC3/N3/NSC	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "08".
	09	FTEN with standard 10 practical	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "09".
	98	FTEN with some other secondary ed or cert.	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "98".
	99	FTEN student but sec. ed. or cert. unknown	Element 010 (Entrance category) is "F", AND Element 022 (Sec. ed. completion) is "99".
	ZZ	Cannot be determined	Not one of the above

CODING NOTES:	"FTEN" indicates a First Time Entering student.
PREPARED ON:	5 August 1999

ELEMENT NUMBER/NAME:	506 Aggregate interval groups.
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	AGREG1
DESCRIPTION:	Element 023 (Aggregate interval) grouped, plus indicator for not being a first-time entering student.

CODE FORMAT:	Data type:	Text
	Format:
	Width:	2

CLASSIFICATION:	Code	Meaning	Derivation
	01	> 1679	Value of E023 (Aggregate interval) is > 1679.
	02	1440 to 1679	Value of E023 (Aggregate interval) is 1440 to 1679.
	03	1220 to 1439	Value of E023 (Aggregate interval) is 1220 to 1439.
	04	950 to 1199	Value of E023 (Aggregate interval) is 950 to 1199.
	05	720 to 949	Value of E023 (Aggregate interval) is 720 to 949.
	06	2 to 719	Value of E023 (Aggregate interval) is 2 to 719.
	98	1st time entering undergrad or predip but no info.	Value of E023 (Aggregate interval) is 1.
	99	Not 1st time ent. undergrad or prediplomate	Value of E023 (Aggregate interval) is 0.
	ZZ	Cannot be determined	Not one of the above

CODING NOTES:
PREPARED ON:	5 August 1999

ELEMENT NUMBER/NAME:	507 Multiple qualification indicator.
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	QUALTYP3
DESCRIPTION:	A code indicating whether a record in the Student File relates to the sole qualification being undertaken by a student, the highest of multiple qualifications being undertaken by the student, or the other-than-highest of multiple qualifications being undertaken by the student.

CODE FORMAT:	Data type:	Text
	Format:
	Width:	1

CLASSIFICATION:

Code

Meaning

Derivation

S	Sole qualification for the student.	In the Student File there is no other record for the student (identified through Element 007 (Student number)
H	Highest qualification for the student.	There is another record or records for the student in the Student File, and either: (a) this record has a higher "rating" in terms of the looked up value for Element 005 (Qualification type) than any other of the records for this student, or (b) this record is tied with another record or records as having the highest rating on Element 005, and it is the first of such records, or (c) the value of Element 005 for this record ican be established but the value of Element 005 for all the other records cannot be established, or (d) the value of Element 005 for this record and all the other records cannot be established and it is the first of such records.
N	Not-highest qualification for the student	There is more than one record in the Student File for the student, but this record does not meet the criterion for being coded "H".

CODING NOTES:

The values for Element 005 (Qualification type) are the values extracted from a record "looked up" in the Qualifications File. The value for Element 001 (Qualification code) in the source record in the Student File is used as the lookup value to find a record in the Qualifications File which has the same value for Element 001. The value of Element 005 (Qualification type) is then inspected in that found record. The "rating" is then determined from the value of Element 005 following this order of precedence (the highest rating is listed first): (a) If the institution is a university: 08, 07, 06, 05, 04, 03, 02, 01, ZZ (b) If the institution is a technikon: 30, 29, 28, 27, 26, 25, 24, 23, 22, 21, ZZ

PREPARED ON:

27 January 2000

ELEMENT NUMBER/NAME:	508 Count of student-qualifications.
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	STUDQUAL
DESCRIPTION:	The number of records in a set extracted from the Student File.

CODE FORMAT:	Data type:	Numeric
	Format:	Right justified in nnnnnnnnn format
	Width:	9

CLASSIFICATION:	Code	Meaning	Derivation
	Numeric value ranging from 0 to 999999999	The number of student-qualification records in a set extracted from the Student File.	Each student-qualification record extracted from the Student File has a value of 1. This value is aggregated with the values for each of the other records in the set.

CODING NOTES:
PREPARED ON:	5 August 1999

ELEMENT NUMBER/NAME:	509 Qualification level group.
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	QUALTYP1
DESCRIPTION:	A code indicating the level group of the qualification being undertaken by a student and status as a first-time entering undergraduate student.
CODE FORMAT:	Data type:	Text
	Format:
	Width:	2

CLASSIFICATION:		Code	Meaning	Derivation
				Value for E005 (Qual. type)	Value for E010 (Entrance cat)
		CC	Occasional student	ZZ	Any value
		UF	1st-time entering undergraduate	01, 02, 03, 21, 22 or 23	"F"
		UN	Other undergraduate	01, 02, 03, 21, 22 or 23 .	NOT "F"
		PC	Postgraduate diploma or certificate	04 or 24	Any value
		PB	Postgraduate bachelors degree	05, 25 or 26	Any value
		PH	Honours degree	06	Any value
		PM	Masters degree	07, 27 or 28	Any value
		PD	Doctoral degree	08, 29 or 30	Any value
	ZZ		Cannot be determined	Not one of the above

CODING NOTES:

The value for Element 005 (Qualification type) is extracted from a record "looked up" in the Qualifications File. The value for Element 001 (Qualification code) in the source record in the Student File is used as the lookup value to find a record in the Qualifications File which has the same value for Element 001. The value of Element 010 (Entrance category) is the value from the source record in the Student File.

PREPARED ON:

26 September 1999

ELEMENT NUMBER/NAME:	510 Aggregated credit values.
FIRST YEAR:	1999
LAST YEAR:
FIELD NAME:	AGGCRED
DESCRIPTION:	The sum of values reported for Element 036 (Course credit value) aggregated in respect of a set of records extracted from the Course Registrations File.

CODE FORMAT:	Data type:	Numeric
	Format:	Right justified in nnnnnnnnn.nnn format
	Width:	13

CLASSIFICATION:	Code	Meaning	Derivation
	Numeric value ranging from 0.000 to 999999999.999	The credit values for E036 (Course credit value) aggregated in respect of a set of records extracted from the Course Registrations File.	For each of the records in the set of records from the Course Registrations File: (a) Find the matching set of records in the Credit Value File, using the value of E001 (Qualification code) concatenated with E030 (Course Code) as the key. There may be more than one record in this set extracted from the Credit Value File. (b) For the matching set of records in the Credit value File add together the values for E036 (Course credit value). Then add that sum with the sums generated for each other record in the set of records from the Course Registrations File. If there is no matching record found in the Credit Value File, the value to be accumulated in respect of the record in the Course Registrations File is zero.

CODING NOTES:
PREPARED ON:	9 December 1999