Return to: |
|||
|
|||
|
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.
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 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 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 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 |
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 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 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 |
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 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 |
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 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 |
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 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 |
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 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 |