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

(O) STRUCTURE OF DERIVED TABLES GENERATED BY VALPAC.NET

STUDFINAL table structure prior to Submission 1, 2003

STUDFINAL table structure after Submission 1, 2003 prior to Submission 1, 2007

STUDFINAL table structure after Submission 1, 2007

CREGFINAL table structure prior to Submission 1, 2004

CREGFINAL table structure after Submission 3, 2003 prior to Submission 1, 2007

CREGFINAL table structure after Submission 3, 2006

PROFFINAL table structure prior to Submission 1, 2007

PROFFINAL table structure after Submission 3, 2006

SFTEFINAL table structure

STUDFINAL table structure prior to Submission 1, 2003

Field name	Element name used in collection documentation	Data type
001	Qualification code	Text
004	Approval status	Text
005	Qualification type	Text
007	Student number	Text
008	South African identity number	Text
009	Qualification commencement date	Text
010	Entrance category	Text
011	Date of birth	Text
012	Gender	Text
013	Race	Text
014	Nationality	Text
015	Home postcode	Text
016	Disability status	Text
017	Socio-economic status	Text
019	NSFAS status	Text
020	Institutional housing	Number
021	Previous year’s activity	Text
022	Secondary education completion	Text
023	Matriculation aggregate	Number
024	Attendance mode	Text
025	Qualification requirements status	Text
026	CESM category for first area of specialisation	Text
027	CESM category for second area of specialisation	Text
028	CESM category for third area of specialisation	Text
029	CESM category for fourth area of specialisation	Text
049	Citizen-resident status	Text
052	Home language	Text
053	Minimum time – total	Number
054	Minimum time – experiential	Number
063	Institution code	Text
524	Institution type	Text
529	Collection year	Text
571	Age in years	Number
572	Year of attendance	Text
573	Qualification level group	Text
515	Occasional / UG first-time / UG other / PG	Text
588	Submission	Text
rank	(None: work field value generated by NATPAC)	Number
009year	(None: work field value generated by NATPAC)	Number
011dob	(None: work field value generated by NATPAC)	Number
temp	(None: work field value generated by NATPAC)	Text
589	Headcount indicator	Text
592	Headcount indicator for students with qualification requirements fulfilled	Text
537	Agriculture and renewable resources indicator	Text
538	Architecture and environmental design specialisation	Text
539	Arts, visual and performing, indicator	Text
540	Business, commerce and management sciences specialisation	Text
541	Communication specialisation	Text
542	Communication science and data processing specialisation	Text
543	Education specialisation	Text
544	Engineering and engineering technology specialisation	Text
545	health care and health sciences specialisation	Text
546	Home economics specialisation	Text
547	Industrial arts, trades and technology specialisation	Text
548	languages, linguistics and literature specialisation	Text
549	Law specialisation	Text
550	Libraries and museums specialisation	Text
551	Life sciences and physical sciences specialisation	Text
552	mathematical sciences specialisation	Text
553	Military science specialisation	Text
554	Philosophy, religion and theology specialisation	Text
555	Physical education, health education and leisure specialisation	Text
556	Psychology specialisation	Text
557	Public administration and social services specialisation	Text
558	Social sciences and social studies specialisation	Text

STUDFINAL table structure after Submission 1, 2003 prior to Submission 1, 2007

Field name	Element name used in collection documentation	Data type
001	Qualification code	Text
004	Approval status	Text
005	Qualification type	Text
007	Student number	Text
008	South African identity number	Text
009	Qualification commencement date	Text
010	Entrance category	Text
011	Date of birth	Text
012	Gender	Text
013	Race	Text
014	Nationality	Text
015	Home postcode	Text
016	Disability status	Text
017	Socio-economic status	Text
019	NSFAS status	Text
020	Institutional housing	Number
021	Previous year’s activity	Text
022	Secondary education completion	Text
023	Matriculation aggregate	Number
024	Attendance mode	Text
025	Qualification requirements status	Text
026	CESM category for first area of specialisation	Text
027	CESM category for second area of specialisation	Text
028	CESM category for third area of specialisation	Text
029	CESM category for fourth area of specialisation	Text
049	Citizen-resident status	Text
052	Home language	Text
053	Minimum time – total	Number
054	Minimum time – experiential	Number
063	Institution code	Text
073	% research time for masters qualification	Number
524	Institution type	Text
529	Collection year	Text
571	Age in years	Number
572	Year of attendance	Text
573	Qualification level group	Text
515	Occasional / UG first-time / UG other / PG	Text
588	Submission	Text
rank	(None: work field value generated by NATPAC)	Number
009year	(None: work field value generated by NATPAC)	Number
011dob	(None: work field value generated by NATPAC)	Number
temp	(None: work field value generated by NATPAC)	Text
589	Headcount indicator	Text
592	Headcount indicator for students with qualification requirements fulfilled	Text
537	Agriculture and renewable resources indicator	Text
538	Architecture and environmental design specialisation	Text
539	Arts, visual and performing, indicator	Text
540	Business, commerce and management sciences specialisation	Text
541	Communication specialisation	Text
542	Communication science and data processing specialisation	Text
543	Education specialisation	Text
544	Engineering and engineering technology specialisation	Text
545	health care and health sciences specialisation	Text
546	Home economics specialisation	Text
547	Industrial arts, trades and technology specialisation	Text
548	languages, linguistics and literature specialisation	Text
549	Law specialisation	Text
550	Libraries and museums specialisation	Text
551	Life sciences and physical sciences specialisation	Text
552	mathematical sciences specialisation	Text
553	Military science specialisation	Text
554	Philosophy, religion and theology specialisation	Text
555	Physical education, health education and leisure specialisation	Text
556	Psychology specialisation	Text
557	Public administration and social services specialisation	Text
558	Social sciences and social studies specialisation	Text

STUDFINAL table structure after Submission 1, 2007

Field name	Element name used in collection documentation	Data type
001	Qualification code	Text
004	Approval status	Text
005	Qualification type	Text
007	Student number	Text
008	South African identity number	Text
009	Qualification commencement date	Text
010	Entrance category	Text
011	Date of birth	Text
012	Gender	Text
013	Race	Text
014	Nationality	Text
015	Home postcode	Text
016	Disability status	Text
017	Socio-economic status	Text
019	NSFAS status	Text
020	Institutional housing	Number
021	Previous year’s activity	Text
022	Secondary education completion	Text
023	Matriculation aggregate	Number
024	Attendance mode	Text
025	Qualification requirements status	Text
026	CESM category for first area of specialisation	Text
027	CESM category for second area of specialisation	Text
028	CESM category for third area of specialisation	Text
029	CESM category for fourth area of specialisation	Text
049	Citizen-resident status	Text
052	Home language	Text
053	Minimum time – total	Number
054	Minimum time – experiential	Number
063	Institution code	Text
073	% research time for masters qualification	Number
074	Centre number	Number
075	Centre name	Text
077	Examination centre	Number
078	Professional development	Text
079	Full-time/Part-time study	Text
080	Activity in current year	Text
524	Institution type	Text
529	Collection year	Text
571	Age in years	Number
572	Year of attendance	Text
573	Qualification level group	Text
515	Occasional / UG first-time / UG other / PG	Text
588	Submission	Text
rank	(None: work field value generated by NATPAC)	Number
009year	(None: work field value generated by NATPAC)	Number
011dob	(None: work field value generated by NATPAC)	Number
temp	(None: work field value generated by NATPAC)	Text
589	Headcount indicator	Text
592	Headcount indicator for students with qualification requirements fulfilled	Text
537	Agriculture and renewable resources indicator	Text
538	Architecture and environmental design specialisation	Text
539	Arts, visual and performing, indicator	Text
540	Business, commerce and management sciences specialisation	Text
541	Communication specialisation	Text
542	Communication science and data processing specialisation	Text
543	Education specialisation	Text
544	Engineering and engineering technology specialisation	Text
545	health care and health sciences specialisation	Text
546	Home economics specialisation	Text
547	Industrial arts, trades and technology specialisation	Text
548	languages, linguistics and literature specialisation	Text
549	Law specialisation	Text
550	Libraries and museums specialisation	Text
551	Life sciences and physical sciences specialisation	Text
552	mathematical sciences specialisation	Text
553	Military science specialisation	Text
554	Philosophy, religion and theology specialisation	Text
555	Physical education, health education and leisure specialisation	Text
556	Psychology specialisation	Text
557	Public administration and social services specialisation	Text
558	Social sciences and social studies specialisation	Text

CREGFINAL table structure prior to Submission 1, 2004

Field name	Element name used in collection documentation	Data type
004	Approval status	Text
005	Qualification type	Text
010	Entrance category	Text
012	Gender	Text
013	Race	Text
014	Nationality	Text
018	Funding status	Text
019	NSFAS status	Text
024	Attendance mode	Text
025	Qualification requirement status	Text
031	Course approval status	Text
032	Course completion status	Text
033	Course CESM	Text
034	Course level code	Text
049	Citizen-resident status	Text
051	Examination-only indicator	Text
059	Contact-only availability	Text
060	Distance-only availability	Text
061	Mixed mode availability	Text
062	Experiential training indicator	Text
063	Institution code	Text
064	Course repeat code	Text
515	Occasional / UG first-time / UG other / PG	Text
517	Type of science category	Text
524	Institution type	Text
529	Collection year	Text
588	Submission	Text
562	First-order course CESM	Text
573	Qualification level group	Text
575	Research type course indicator	Text
583	Course level/label	Text
586	Credit table CESM category/label	Text
036	Course credit value	Number
050	Completed research course credit value	Number
574	Course credit value on completion	Number
578	Weighted course credit	Number
579	Apportioned weighted course credit, prior to Sub 2, 2000	Number
584	Apportioned weighted course credit, after Sub1, 2000	Number
580	Weighted course credit on completion	Number
581	Apportioned weighted course credit on completion, prior to Sub 2, 2000	Number
585	Apportioned weighted course credit on completion, after Sub1, 2000	Number

CREGFINAL table structure after Submission 3, 2003 prior to Submission 1, 2007

Field name	Element name used in collection documentation	Data type
004	Approval status	Text
005	Qualification type	Text
010	Entrance category	Text
012	Gender	Text
013	Race	Text
014	Nationality	Text
018	Funding status	Text
019	NSFAS status	Text
024	Attendance mode	Text
025	Qualification requirement status	Text
031	Course approval status	Text
032	Course completion status	Text
033	Course CESM	Text
034	Course level code	Text
049	Citizen-resident status	Text
051	Examination-only indicator	Text
059	Contact-only availability	Text
060	Distance-only availability	Text
061	Mixed mode availability	Text
062	Experiential training indicator	Text
063	Institution code	Text
064	Attendance mode for course	Text
515	Occasional / UG first-time / UG other / PG	Text
517	Type of science category	Text
518	Summary category	Text
524	Institution type	Text
529	Collection year	Text
588	Submission	Text
562	First-order course CESM	Text
573	Qualification level group	Text
575	Research type course indicator	Text
583	Course level/label	Text
586	Credit table CESM category/label	Text
036	Course credit value	Number
050	Completed research course credit value	Number
574	Course credit value on completion	Number
578	Weighted course credit	Number
579	Apportioned weighted course credit, prior to Sub 2, 2000	Number
584	Apportioned weighted course credit, after Sub1, 2000	Number
580	Weighted course credit on completion	Number
581	Apportioned weighted course credit on completion, prior to Sub 2, 2000	Number
585	Apportioned weighted course credit on completion, after Sub1, 2000	Number

CREGFINAL table structure after Submission 3, 2006

Field name	Element name used in collection documentation	Data type
004	Approval status	Text
005	Qualification type	Text
010	Entrance category	Text
012	Gender	Text
013	Race	Text
014	Nationality	Text
018	Funding status	Text
019	NSFAS status	Text
024	Attendance mode	Text
025	Qualification requirement status	Text
031	Course approval status	Text
032	Course completion status	Text
033	Course CESM	Text
034	Course level code	Text
049	Citizen-resident status	Text
051	Examination-only indicator	Text
059	Contact-only availability	Text
060	Distance-only availability	Text
061	Mixed mode availability	Text
062	Experiential training indicator	Text
063	Institution code	Text
064	Attendance mode for course	Text
091	Foundation course	Text
515	Occasional / UG first-time / UG other / PG	Text
517	Type of science category	Text
518	Summary category	Text
524	Institution type	Text
529	Collection year	Text
588	Submission	Text
562	First-order course CESM	Text
573	Qualification level group	Text
575	Research type course indicator	Text
583	Course level/label	Text
586	Credit table CESM category/label	Text
036	Course credit value	Number
050	Completed research course credit value	Number
574	Course credit value on completion	Number
578	Weighted course credit	Number
579	Apportioned weighted course credit, prior to Sub 2, 2000	Number
584	Apportioned weighted course credit, after Sub1, 2000	Number
580	Weighted course credit on completion	Number
581	Apportioned weighted course credit on completion, prior to Sub 2, 2000	Number
585	Apportioned weighted course credit on completion, after Sub1, 2000	Number

PROFFINAL table structure prior to Submission 1, 2007

Field name	Element name used in collection documentation	Data type
011	Date of birth	Text
012	Gender	Text
013	Race	Text
014	Nationality	Text
037	Staff number	Text
038	Employment commencement year	Text
039	Personnel category	Text
040	Rank of staff member	Text
041	Permanent/temporary status	Text
042	Full-time/part-time status	Text
046	Qualification type	Text
047	Joint appointment	Text
048	On payroll code	Text
063	Institution code	Text
589	Headcount indicator	Text
038year	(None: work field value generated by NATPAC)	Number
591	Employment commencement year	Number
011value	(None: work field value generated by NATPAC)	Number
571	Age in years	Number
524	Institution type	Text
529	Collection year	Number

PROFFINAL table structure after Submission 3, 2006

Field name	Element name used in collection documentation	Data type
011	Date of birth	Text
012	Gender	Text
013	Race	Text
014	Nationality	Text
037	Staff number	Text
038	Employment commencement year	Text
039	Personnel category	Text
040	Rank of staff member	Text
041	Permanent/temporary status	Text
042	Full-time/part-time status	Text
046	Qualification type	Text
047	Joint appointment	Text
048	On payroll code	Text
063	Institution code	Text
094	Post doctoral/Research fellow	Text
589	Headcount indicator	Text
038year	(None: work field value generated by NATPAC)	Number
591	Employment commencement year	Number
011value	(None: work field value generated by NATPAC)	Number
571	Age in years	Number
524	Institution type	Text
529	Collection year	Number

SFTEFINAL table structure

Field name	Element name used in collection documentation	Data type
012	Gender	Text
013	Race	Text
014	Nationality	Text
037	Staff number	Text
039	Personnel category	Text
040	Rank of staff member	Text
041	Permanent/temporary status	Text
042	Full-time/part-time status	Text
043	Staff FTE value	Number
044	Staff programme	Text
045	Staff programme CESM	Text
046	Qualification type	Text
047	Joint appointment	Text
048	On payroll code	Text
063	Institution code	Text
524	Institution type	Text
529	Collection year	Number
571	Age in years	Number
591	Employment commencement year	Number