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: 21 October 2003

 

(F)       STRUCTURE OF FLAT ASCII FILES TO BE PREPARED BY INSTITUTIONS

 

1.            GENERAL SPECIFICATIONS FOR ASCII FILES TO BE PREPARED BY INSTITUTIONS

 

Records to be terminated preferably with a carriage return and line feed (Hex 0D0A).  A less preferred alternative is a line feed only (Hex 0A).

 

No non-printing characters to be included in any record, except for terminating carriage return and line feed (Hex 0D0A) or line feed (Hex 0A).

 

No null record to be included after the last data record.

 

Lengths of all the records in the one file to be the same.

 

In each record, the "comments" field allows input of any optional alphanumeric text of interest to the institution.  This field may be filled with spaces.  The VALPAC.Net database will treat this field as a text field during the importing of data to its database.

 

 

2.            STUDENT FILE

 

File name:    yyyyxxxSTUD.s   (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 007 concatenated with Element 001

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

007

Student number

STUDNUM

15

1

15

Text

008

South African identity number

SAIDNUM

15

16

30

Text

001

Qualification code

QUALCODE

15

31

45

Text

009

Qualification commencement date

COMDATE

8

46

53

Numeric

010

Entrance category

ENTRCAT

1

54

54

Text

011

Date of birth

DOB

8

55

62

Numeric

012

Gender

GENDER

1

63

63

Text

013

Race

RACE

1

64

64

Text

014

Nationality

NATIONAL

3

65

67

Text

049

Citizen-resident status

CITIRES

2

68

69

Text

052

Home language

HOMELANG

4

70

73

Text

019

NSFAS status

NSFAS

2

74

75

Text

020

Institutional housing

HOUSING

4

76

79

Numeric

021

Previous year’s activity

PREVACT

2

80

81

Text

022

Secondary education completion

SECED

2

82

83

Text

023

Matriculation aggregate

MATRIC

4

84

87

Numeric

024

Attendance mode

ATTMODE

1

88

88

Text

025

Qualification requirements status

REQUIRE

1

89

89

Text

026

CESM category for first area of specialisation

CESMSPE1

4

90

93

Text

027

CESM category for second area of specialisation

CESMSPE2

4

94

97

Text

028

CESM category for third area of specialisation

CESMSPE3

4

98

101

Text

029

CESM category for fourth area of specialisation

CESMSPE4

4

102

105

Text

015

Home postcode

POSTCODE

4

106

109

Text

055

Home address line 1

ADDRES1

38

110

147

Text

056

Home address line 2

ADDRES2

38

148

185

Text

057

Home address line 3

ADDRES3

38

186

223

Text

016

Disability status

DISABIL

10

224

233

Text

017

Socio-economic status

SOCSTAT

2

234

235

Text

066

Student last name

LASTNAME

26

236

261

Text

067

Student first name

FRSTNAME

26

262

287

Text

068

Student middle name

MIDDNAME

26

288

313

Text

069

Postal address line 1

PSTADDR1

50

314

363

Text

070

Postal address line 2

PSTADDR2

50

364

413

Text

071

Postal address line 3

PSTADDR3

50

414

463

Text

072

Postal address postcode

PSTPCODE

4

464

467

Text

073

% research for masters qualification

RESTIME

5

468

472

Numeric

 

Comments

COMMENTS

30

473

502

Text

 

 

3a           COURSE REGISTRATIONS FILE (1999 all submissions, 2000 1ST submission)

 

File name:    yyyyxxxCREG (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 007 concatenated with Element 001 concatenated with Element 030 concatenated with Element 064

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

007

Student number

STUDNUM

15

1

15

Text

001

Qualification code

QUALCODE

15

16

30

Text

030

Course code

CRSECODE

9

31

39

Text

064

Course repeat code

CRSEREPT

1

40

40

Text

018

Funding status

FUNDING

2

41

42

Text

032

Course completion status

COMPSTAT

1

43

43

Text

051

Examination-only indicator

EXAMONLY

1

44

44

Text

 

Comments

COMMENTS

30

45

74

Text

 

 

3b           COURSE REGISTRATIONS FILE (1999 all submissions; 2000 2nd submission)

 

File name:    yyyyxxxCREG (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 007 concatenated with Element 001 concatenated with Element 030

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

007

Student number

STUDNUM

15

1

15

Text

001

Qualification code

QUALCODE

15

16

30

Text

030

Course code

CRSECODE

9

31

39

Text

064

Attendance mode for course

ATTMODEC

1

40

40

Text

018

Funding status

FUNDING

2

41

42

Text

032

Course completion status

COMPSTAT

1

43

43

Text

051

Examination-only indicator

EXAMONLY

1

44

44

Text

 

Comments

COMMENTS

30

45

74

Text

 

 

 

4.            CREDIT VALUE FILE

 

File name:    yyyyxxxCRED.s   (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 001 concatenated with Element 030

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

001

Qualification code

QUALCODE

15

1

15

Text

030

Course code

CRSECODE

9

16

24

Text

065

Filler1

FILLER1

1

25

25

Text

036

Course credit value

CRSECRED

8

26

33

Numeric

050

Completed research course credit value

CRSECRER

8

34

41

Numeric

 

Comments

COMMENTS

30

42

71

Text

 

 

5.            QUALIFICATION FILE

 

File name:    yyyyxxxQUAL.s   (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 001

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

001

Qualification code

QUALCODE

15

1

15

Text

002

Previous years qualification code

QUALPREV

15

16

30

Text

003

Qualification name

QUALNAME

65

31

95

Text

004

Approval status

APSTATUS

1

96

96

Text

005

Qualification type

QUALTYPE

2

97

98

Text

053

Minimum time - total

MINTIMET

4

99

102

Numeric

054

Minimum time - experiential

MINTIMEX

4

103

106

Numeric

 

Comments

COMMENTS

30

107

136

Text

 

 

6.            QUALIFICATION CESM FILE

 

File name:    yyyyxxxCESM.s   (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 001

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

001

Qualification code

QUALCODE

15

1

15

Text

006

Major field CESM

CESMMAJ

4

16

19

Text

 

Comments

COMMENTS

30

20

49

Text

 

 

7.            COURSE FILE

 

File name:    yyyyxxxCRSE.s   (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 030

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

030

Course code

CRSECODE

9

1

9

Text

065

Filler1

FILLER1

1

10

10

Text

031

Course approval status

CRSEAPPR

1

11

11

Text

033

Course CESM

CESMCRSE

4

12

15

Text

034

Course level code

CLEVCODE

2

16

17

Text

059

Contact-only availability

CONMODE

1

18

18

Text

060

Distance-only availability

DISTMODE

1

19

19

Text

061

Mixed mode availability

MIXMODE

1

20

20

Text

062

Experiential training indicator

EXPTRAIN

1

21

21

Text

058

Course name

CRSENAME

65

22

86

Text

 

Comments

COMMENTS

30

87

116

Text

 

 

8.            STAFF PROFILE FILE

 

File name:    yyyyxxxPROF.s   (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 037 concatenated with Element 039

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

037

Staff number

STAFNUM

15

1

15

Text

038

Employment commencement year

ECOMYEAR

4

16

19

Numeric

039

Personnel category

PERSCAT

2

20

21

Text

040

Rank of staff member

STAFRANK

2

22

23

Text

011

Date of birth

DOB

8

24

31

Text

012

Gender

GENDER

1

32

32

Text

013

Race

RACE

1

33

33

Text

014

Nationality

NATIONAL

3

34

36

Text

041

Permanent/temporary status

PERMTEMP

2

37

38

Text

042

Full-time/part-time status

FULLPART

2

39

40

Text

046

Qualification type

STAFQUAL

2

41

42

Text

047

Joint appointment

JOINTAPP

1

43

43

Text

048

On payroll code

ONPAYRL

1

44

44

Text

 

Comments

COMMENTS

30

45

74

Text

 

 

9.            STAFF FTE FILE

 

File name:    yyyyxxxSFTE.s   (replace “yyyy” with the submission year, "xxx" with the institution code, and "s" by the submission number)

Sort order:    Any order

Unique key:  Element 037 concatenated with Element 039 concatenated with Element 044 concatenated with Element 045

 

Element number

Element name

Field name

Width

Start column

End column

Data type

 

037

Staff number

STAFNUM

15

1

15

Text

039

Personnel category

PERSCAT

2

16

17

Text

043

Staff FTE value

STAFFTE

8

18

25

Numeric

044

Staff programme

STAFPROG

3

26

28

Text

045

Staff programme CESM

CESMSTAF

4

29

32

Text

 

Comments

COMMENTS

30

33

62

Text