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 511 TO 520

 

ELEMENT NUMBER/NAME:

511         Completed aggregated credit values.

FIRST YEAR:

1999

LAST YEAR:

 

FIELD NAME:

AGGCOMP

 

 

DESCRIPTION:

The sum of values reported for Element 036 (Course credit value) or Element 050 (Completed research course credit value) aggregated in respect of a set of records extracted from the Course Registrations File. Element 050 is used in respect of completed research postgraduate courses and Element 036 is used in respect of all other courses.

 

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 aggregated in respect of a set of records extracted from the Course Registrations File.

Records in the Course Registrations File are processed in this way:

(a)  If the value for E032 (Course completion status) in the record in the Course Registrations File is other then "C", the record is not processed any further - in that case go to step (h).

(b) A matching record in the Course File is found using the value for E030 (Course code) as the key.  (If no find, then the record in the Course Registrations File is not processed any further - in that case, go to step (h)).

(c)  If the value of E034 (Course level code) is "07", "09", "28", "30", "32" or "34", set the "level flag" to "research PG".

(d) If the value of E034 (Course level code) is NOT "07", "09", "28", "30", "32" or "34", set the "level flag" to "not research PG".

(e)  A matching record in the Credit Value File is found using the value for E001 (Qualification code) concatenated with E030 (Course code) as the key.   (If no find, then the record in the Course Registrations File is not processed any further - in that case, go to step (h)).

(f)  If the "level flag" is "not research PG" then add the value of E036 (Course credit value) with the other values relating to other suitable records from the Course Registrations File.  Go to step (h).

(g) If the "level flag" is "research PG" then add the value of E050 (Completed research course credit value) with the other values relating to other suitable records from the Course Registrations File.

(h)  Process the next record in the Course Registrations File.

 

CODING NOTES:

 

PREPARED ON:

7 October 1999

 

 


 

ELEMENT NUMBER/NAME:

512         Aggregated credit value all funded courses

FIRST YEAR:

1999

LAST YEAR:

 

FIELD NAME:

CREDALL

 

 

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, but only in respect of courses which meet all these criteria: it is being undertaken in a qualification which has been approved for funding or the qualification type is "occasional", the course has been approved for funding; the reporting institution receives funding for it from the Government; it is not being undertaken as an examination-only course, and it is not a pre-tertiary course.

 

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 aggregated in respect of a set of records extracted from the Course Registrat-ions File.

Records in the Course Registrations File are processed in this way:

(a)     If the value for E051 (Examination-only indicator) in the record in the Course Registrations File is other than "N" then the record is not processed any further - in that case go to step (i).

(b.1)  If the Collection Year is 1999 go to step (c)

(b.2)  If the collection year is later than 1999 and the value for E018 (Funding status) is other than "GV" then the record is not processed any further - in that case go to step (i).

(c)     A matching record in the Qualification File is found using the value for E001 (Qualification code) as the key.  (If no find, then the record in the Course Registrations File is not processed any further - in that case, go to step (i)).

(d.1)  If the value for E005 (Qualification type) in the record in the Qualification File is "ZZ" then go to step (e).

(d.2)  If the value for E004 (Approval status) in the record in the Qualification File is not NOT "A" then the record in the Course Registrations File is not processed any further - in that case go to step (i).

(e)     A matching record in the Course File is found using the value for E030 (Course code) as the key.  (If no find, then the record in the Course Registrations File is not processed any further - in that case, go to step (i)).

(f)     If in that matching record, the value for E031 (Course approval status) is other than "A" OR the value for E034 (Course level code) is ("00" or "20"), then the Course Registrations File record is not processed any further - in that case go to step (i).

(g)     A matching record in the Credit Value File is found using the value for E001 (Qualification code) concatenated with E030 (Course code) as the key.   (If no find, then the record in the Course Registrations File is not processed any further - in that case, go to step (i)).

(h)     Add the value of E036 (Course credit value) with the other values relating to other suitable records from the Course Registrations File.

(i)      Process the next record in the Course Registrations File.

 

CODING NOTES:

 

PREPARED ON:

17 May 2000

 

 


 

ELEMENT NUMBER/NAME:

513         Aggregated credit value for completed funded courses

FIRST YEAR:

1999

LAST YEAR:

 

FIELD NAME:

CREDCOMP

 

 

DESCRIPTION:

The sum of values reported for Element 036 (Course credit value) or Element 050 (Completed research course credit value) aggregated in respect of a set of records extracted from the Course Registrations File, but only in respect of courses which have been completed and which meet all the following criteria:  it is being undertaken in a qualification which has been approved for funding or the qualification type is "occasional", the course has been approved for funding; the reporting institution receives funding for it from the Government;  and it is not a pre-tertiary course.

 

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 aggregated in respect of a set of records extracted from the Course Registrat-ions File.

Records in the Course Registrations File are processed in this way:

(a)    If the value for E032 (Course completion status) in the record in the Course Registrations File is other then "C", the record is not processed any further - in that case go to step (l).

(b.1) If the Collection Year is 1999 go to step (c)

(b.2) If the Collection Year is later than 1999 and the value for E018 (Funding status) is other than "GV" then the record is not processed any further - in this case go to step (l).

(c)    A matching record in the Qualification File is found using the value for E001 (Qualification code) as the key.  (If no find, then the record in the Course Registrations File is not processed any further - in that case, go to step (l)).

(d.1)  If the value for E005 (Qualification type) in the record in the Qualification File is "ZZ" then go to step (e).

(d.2) If the value for E004 (Approval status) in the record in the Qualification File is other than "A" then the record in the Course Registrations File is not processed any further - in that case go to step (l).

(e)    A matching record in the Course File is found using the value for E030 (Course code) as the key.  (If no find, then the record in the Course Registrations File is not processed any further - in that case, go to step (l)).

(f)     If in that matching record, the value for Element 031 (Course approval status) is other than "A" OR the value for E034 (Course level code) is ("00" or "20"), then the Course Registrations File record is not processed any further - in that case go to step (l).

(g)    If the value of E034 (Course level code) is "07", "09", "28", "30", "32" or "34", set the "level flag" to "research PG".

(h)    If the value of E034 (Course level code) is NOT "07", "09", "28", "30", "32" or "34", set the "level flag" to "not research PG".

(i)     A matching record in the Credit Value File is found using the value for E001 (Qualification code) concatenated with E030 (Course code) as the key.  (If no find, then the record in the Course Registrations File is not processed any further - in that case, go to step (l)).

(j)     If the "level flag" is "not research PG" then add the value of E036 (Course credit value) with the other values relating to other suitable records from the Course Registrations File.  Go to step (l).

(k)    If the "level flag" is "research PG" then add the value of E050 (Completed research course credit value) with the other values relating to other suitable records from the Course Registrations File.

(l)     Process the next record in the Course Registrations File.

 

CODING NOTES:

 

PREPARED ON:

17 May 2000

 

 


 

ELEMENT NUMBER/NAME:

514         Aggregated credit value size group for a student-qualification

FIRST YEAR:

1999

LAST YEAR:

 

FIELD NAME:

CREDAGGG

 

 

DESCRIPTION:

The value of Element 518 (Aggregated credit for a student/qualification) reported as a group code.

 

CODE FORMAT:

Data type:

Text

 

Format:

 

 

Width:

11

 

CLASSIFICATION:

Code

Meaning

Derivation

 

NIL

NIL

E518 = nil

 

>0 to 0.1

>0 to 0.1

E518 is > 0 but not > 0.1

 

>0.1 to 0.2

>0.1 to 0.2

E518 is > 0.1 but not > 0.2

 

>0.2 to 0.3

>0.2 to 0.3

E518 is > 0.2 but not > 0.3

 

>0.3 to 0.4

>0.3 to 0.4

E518 is > 0.3 but not > 0.4

 

>0.4 to 0.5

>0.4 to 0.5

E518 is > 0.4 but not > 0.5

 

>0.5 to 0.6

>0.5 to 0.6

E518 is > 0.5 but not > 0.6

 

>0.6 to 0.7

>0.6 to 0.7

E518 is > 0.6 but not > 0.7

 

>0.7 to 0.8

>0.7 to 0.8

E518 is > 0.7 but not > 0.8

 

>0.8 to 0.9

>0.8 to 0.9

E518 is > 0.8 but not > 0.9

 

>0.9 to 1.0

>0.9 to 1.0

E518 is > 0.9 but not > 1.0

 

>1.0 to 1.1

>1.0 to 1.1

E518 is > 1.0 but not > 1.1

 

>1.1 to 1.2

>1.1 to 1.2

E518 is > 1.1 but not > 1.2

 

>1.2 to 1.3

>1.2 to 1.3

E518 is > 1.2 but not > 1.3

 

>1.3 to 1.4

>1.3 to 1.4

E518 is > 1.3 but not > 1.4

 

> 1.4

> 1.4

E518 is > 1.4

 

ZZ

Cannot be determined

Not one of the above

 

CODING NOTES:

 

PREPARED ON:

5 August 1999

 

 


 

ELEMENT NUMBER/NAME:

515         Undergraduate/postgraduate indicator

FIRST YEAR:

1999

LAST YEAR:

 

FIELD NAME:

QUALTYP2

 

 

DESCRIPTION:

A code indicating whether a student is a first-time entering undergraduate student, other undergraduate student, or postgraduate student.

 

CODE FORMAT:

Data type:

Text

 

Format:

 

 

Width:

2

 

CLASSIFICATION:

Code

Meaning

Derivation

 

 

 

 

Value for E005 (Qual. type)

Value for E010 (Entr. cat)

 

OC

Occasional student

ZZ

Any value

 

UGF

1st-time entering undergraduate.

01, 02, 03, 11, 21, 22, 23, 26 or 33

"F"

 

UGO

Other undergraduate

01, 02, 03, 11, 21, 22, 23, 26 or 33

NOT "F"

 

PG

Postgraduate.

04, 05, 06, 07, 08, 24, 25, 27, 28, 29 or 30

Any value

 

ZZ

Cannot be determined

Not one of the above

 

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 taken from that found record.

The value of Element 010 (Entrance category) is the value from the source record in the Student File.

PREPARED ON:

27 January 2001

 


 

ELEMENT NUMBER/NAME:

516         Credit table CESM categories

FIRST YEAR:

1999

LAST YEAR:

2009

FIELD NAME:

CREDCESM

 

 

DESCRIPTION:

CESM groups which are used in the credit tables.

CODE FORMAT:

Data type:

Text

 

Format:

 

 

Width:

3

 

CLASSIFICATION:

Code

Meaning

Derivation from Value for E033 (Course CESM)

 

010

Ag. and renewable natural resources

leftmost 2 characters = "01"

 

020

Architect. and environmental design

leftmost 2 characters = "02”

 

03A

Music

Value of E033 is 0303

 

03B

Visual arts

Value of E033 is 0305

 

03C

All other arts, visual and performing

Value of E033 is 0301, 0302, 0304, 0306, 0307 or 0399

 

040

Business, commerce and mngt sciences

leftmost 2 characters = "04”

 

050

Communication

leftmost 2 characters = "05”

 

060

Computer Science and data process

leftmost 2 characters = "06”

 

070

Education

leftmost 2 characters = "07”

 

080

Engineering and engineering technology

leftmost 2 characters = "08”

 

09A

Nursing, rehab and therapy, emergency services, hospital and health care adm, public health

Value of E033 is 0902, 0903, 0905, 0906 or 0907

 

09B

All other health care and health sciences

Value of E033 is 0901, 0904, 0908, 0909 or 0999

 

100

Home economics

leftmost 2 characters = "10”

 

110

Industrial arts, trades and technology

leftmost 2 characters = "11”

 

120

Languages, linguistics and literature

leftmost 2 characters = "12”

 

130

Law

leftmost 2 characters = "13”

 

140

Libraries and museums

leftmost 2 characters = "14"

 

150

Life Sciences and physical sciences

leftmost 2 characters = "15”

 

160

Mathematical sciences

leftmost 2 characters = "16”

 

170

Military sciences

leftmost 2 characters = "17”

 

180

Philosophy, religion and theology

leftmost 2 characters = "18”

 

190

Physical educ, health educ and leisure

leftmost 2 characters = "19”

 

200

Psychology

leftmost 2 characters = "20”

 

210

Public administration and social services

leftmost 2 characters = "21”

 

220

Social sciences and social studies

leftmost 2 characters = "22”

 

ZZZ

Unknown

Codes other than the above

 

CODING NOTES:

The values for E033 (Course CESM) are the values extracted from a record "looked up" in the Course File.  The value for E030 (Course code) in the source record in the Course Registrations File is used as the lookup value to find the record in the Course File which has the same value for E030.  The value of E033 (Course CESM) is then taken from that found record.

PREPARED ON:

27 December 1999

 

 


 

ELEMENT NUMBER/NAME:

516         Credit table CESM categories

FIRST YEAR:

2010

LAST YEAR:

 

FIELD NAME:

CREDCESM

 

 

DESCRIPTION:

CESM groups which are used in the credit tables.

CODE FORMAT:

Data type:

Text

 

Format:

 

 

Width:

3

 

CLASSIFICATION:

Code

Meaning

Derivation from Value for E033 (Course CESM)

 

010

Agriculture, Agricultural Operations and Related Sciences

leftmost 2 characters = "01"

 

020

Architecture and the Built Environment

leftmost 2 characters = "02”

 

03A

Music

Value of E033 is 0306

 

03B

Visual arts

Value of E033 is 0305

 

03C

All other arts, visual and performing

Value of E033 is 0301, 0302, 0303, 0304 or 0399

 

040

Business, Economics and Management Studies

leftmost 2 characters = "04”

 

050

Communication, Journalism and Related Studies

leftmost 2 characters = "05”

 

060

Computer and Information Sciences

leftmost 2 characters = "06”

 

070

Education

leftmost 2 characters = "07”

 

080

Engineering

leftmost 2 characters = "08”

 

09A

Nursing, rehab and therapy, emergency services, hospital and health care adm, public health

Value of E033 is 0905, 0908, 0913, 0914, 0921, 0922 or 0923

 

09B

All other health care and health sciences

Value of E033 is 0901, 0902, 0903, 0904, 0906, 0907, 0909, 0910, 0911, 0912, 0915, 0916, 0917, 0918, 0919, 0920, 0924 or 0999

 

100

Family Ecology and Consumer Sciences

leftmost 2 characters = "10”

 

110

Languages, Linguistics and Literature

leftmost 2 characters = "11”

 

120

Law

leftmost 2 characters = "12”

 

130

Life Sciences

leftmost 2 characters = "13”

 

140

Physical Sciences

leftmost 2 characters = "14"

 

150

Mathematics and Statistics

leftmost 2 characters = "15”

 

160

Military Sciences

leftmost 2 characters = "16”

 

170

Philosophy, Religion and Theology

leftmost 2 characters = "17”

 

180

Psychology

leftmost 2 characters = "18”

 

190

Public Management and Services

leftmost 2 characters = "19”

 

200

Social Sciences

leftmost 2 characters = "20”

 

ZZZ

Unknown

Codes other than the above

 

CODING NOTES:

The values for E033 (Course CESM) are the values extracted from a record "looked up" in the Course File.  The value for E030 (Course code) in the source record in the Course Registrations File is used as the lookup value to find the record in the Course File which has the same value for E030.  The value of E033 (Course CESM) is then taken from that found record.

PREPARED ON:

09 July 2010

 

 


 

ELEMENT NUMBER/NAME:

517         Type of science category.

FIRST YEAR:

1999

LAST YEAR:

2009

FIELD NAME:

SCIENCE

 

 

DESCRIPTION:

A code indicating whether a course is classified as being human science or natural science.

CODE FORMAT:

Data type:

Text

 

Format:

 

 

Width:

3

 

CLASSIFICATION:

Code

Meaning

Derivation from Value for leftmost 2 characters of E033 (Course CESM)

 

HUM

Human science

03, 04, 05, 07, 12, 13, 14, 18, 19, 20, 21 or 22

 

NAT

Natural science

01, 02, 06, 08, 09, 10, 11, 15, 16 or 17

 

ZZZ

No information

Codes other than the above

 

CODING NOTES:

The values for E033 (Course CESM) are the values extracted from a record "looked up" in the Course File.  The value for E030 (Course code) in the source record in the Course Registrations File is used as the lookup value to find the record in the Course File which has the same value for E030.  The value of E033 (Course CESM) is then taken from that found record.

 

PREPARED ON:

5 August 1999

 

 


 

ELEMENT NUMBER/NAME:

517         Type of science category.

FIRST YEAR:

2010

LAST YEAR:

 

FIELD NAME:

SCIENCE

 

 

DESCRIPTION:

A code indicating whether a course is classified as being human science or natural science.

CODE FORMAT:

Data type:

Text

 

Format:

 

 

Width:

3

 

CLASSIFICATION:

Code

Meaning

Derivation from Value for leftmost 2 characters of E033 (Course CESM)

 

HUM

Human science

03, 04, 05, 07, 11, 12, 17, 18, 19 or 20

 

NAT

Natural science

01, 02, 06, 08, 09, 10, 13, 14, 15 or 16

 

ZZZ

No information

Codes other than the above

 

CODING NOTES:

The values for E033 (Course CESM) are the values extracted from a record "looked up" in the Course File.  The value for E030 (Course code) in the source record in the Course Registrations File is used as the lookup value to find the record in the Course File which has the same value for E030.  The value of E033 (Course CESM) is then taken from that found record.

 

PREPARED ON:

9 July 2010

 

 


 

ELEMENT NUMBER/NAME:

518         Aggregated credit for a student-qualification

FIRST YEAR:

1999

LAST YEAR:

2003

FIELD NAME:

STUQCRED

 

 

DESCRIPTION:

For a student/qualification record reported in the Student File, the value for Element 036 (Course credit value) aggregated in respect of all the related records in the Course Registrations File.

 

CODE FORMAT:

Data type:

Numeric

 

Format:

Right justified, in n.nnn format

 

Width:

5

 

CLASSIFICATION:

Code

Meaning

Derivation

 

Numeric value ranging from 0.000 to 9.900

The credit values aggregated for a record in the Student File in respect of all the related records in the Course Registrations File.

For the record in the Student File, each related record in the Course Registrations File is identified.  "Related records" are all those with a matching value for E007 (Student number) + E001 (Qualification code).

For each of the Related records in the Course Registrations File, a related record is found in the Credit Value File.  The "related record" is one with a matching value for E001 (Qualification code) + E030 (Course code). 

From those related records found in the Credit Value File, the values for E036 (Course credit value) are summed - this result is the value for E518.

 

CODING NOTES:

 

PREPARED ON:

5 August 1999

 


 

ELEMENT NUMBER/NAME:

518         Summary category.

FIRST YEAR:

2004

LAST YEAR:

2009

FIELD NAME:

SUMMARY

 

 

DESCRIPTION:

A code indicating whether a course is classified as being SET, Business and Commerce, Education or Other human science.

CODE FORMAT:

Data type:

Text

 

Format:

 

 

Width:

3

 

CLASSIFICATION:

Code

Meaning

Derivation from Value for leftmost 2 characters of E033 (Course CESM)

 

SET

Science Education and Technology

01, 02, 06, 08, 09, 10, 11, 15, 16 and 17

 

BUS

Business and Commerce

04

 

EDU

Education

07

 

OTH

Other Human Sciences

03, 05, 12, 13, 14, 18, 19, 20, 21 and 22

 

UNK

No information

Codes other than the above

 

CODING NOTES:

The values for E033 (Course CESM) are the values extracted from a record "looked up" in the Course File.  The value for E030 (Course code) in the source record in the Course Registrations File is used as the lookup value to find the record in the Course File which has the same value for E030.  The value of E033 (Course CESM) is then taken from that found record.

 

PREPARED ON:

10 February 2005

 


 

ELEMENT NUMBER/NAME:

518         Summary category.

FIRST YEAR:

2010

LAST YEAR:

 

FIELD NAME:

SUMMARY

 

 

DESCRIPTION:

A code indicating whether a course is classified as being SET, Business and Commerce, Education or Other human science.

CODE FORMAT:

Data type:

Text

 

Format:

 

 

Width:

3

 

CLASSIFICATION:

Code

Meaning

Derivation from Value for leftmost 2 characters of E033 (Course CESM)

 

SET

Science Education and Technology

01, 02, 06, 08, 09, 10, 13, 14, 15 and 16

 

BUS

Business and Commerce

04

 

EDU

Education

07

 

OTH

Other Human Sciences

03, 05, 11, 12, 17, 18, 19 and 20

 

UNK

No information

Codes other than the above

 

CODING NOTES:

The values for E033 (Course CESM) are the values extracted from a record "looked up" in the Course File.  The value for E030 (Course code) in the source record in the Course Registrations File is used as the lookup value to find the record in the Course File which has the same value for E030.  The value of E033 (Course CESM) is then taken from that found record.

 

PREPARED ON:

09 July 2010

 


 

ELEMENT NUMBER/NAME:

519         Count of staff-personnel category.

FIRST YEAR:

1999

LAST YEAR:

2003

FIELD NAME:

STPERNUM

 

 

DESCRIPTION:

The number of records in a set extracted from the Staff 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 staff-personnel category records in a set extracted from the Staff File.

Each staff-personnel category record extracted from the Staff 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:

18 August 1999

 

 


 

ELEMENT NUMBER/NAME:

520         Aggregated Staff FTE values.

FIRST YEAR:

1999

LAST YEAR:

2003

FIELD NAME:

AGSTAFTE

 

 

DESCRIPTION:

The sum of values reported for Element 043 (Staff FTE value) aggregated in respect of a set of records extracted from the Staff FTE 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 staff FTE values aggregated in respect of a set of records extracted from the Staff FTE File.

Sum of the values for E043 (Staff FTE value) for a set of records from the Staff FTE File.

 

 

CODING NOTES:

 

PREPARED ON:

18 August 1999