FILE STRUCTURES FOR FILES REQUIRED IN THE
BUILDING SPACE INVENTORY UNIT RECORD COLLECTIONS
Version: 15 June 2007
GENERAL SPECIFICATIONS FOR
FILES
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 database will
treat this field as a text field during the importing of data to its database.
The date for the building
space inventory is theoretically set for 31 December of the reporting year, but
practical considerations dictate that each institution be allowed to set a date
for itself as close as possible to the end of the reporting year.
This approach is necessitated by the fact that the
proration of space according to PCS and CESM categories, inter alia requires staff information which is only available at the
end of each reporting year.
File
name: xxxxCAMP.s (replace "xxxx"
with the institution code, and "s" by the submission number)
Sort
order: Any order
Unique
key: Element 201concatenated with
Element 204
Element number |
Element name |
Field name |
Width |
Start column |
End column |
Data type |
201 |
Campus
code |
CAMPCODE |
3 |
1 |
3 |
Text |
202 |
Campus
name |
CAMPNAME |
50 |
4 |
53 |
Text |
203 |
Campus
postcode |
CAMPPSTC |
4 |
54 |
57 |
Text |
204 |
Campus
province code |
CAMPPROV |
2 |
58 |
59 |
Text |
221 |
Latitude
degrees |
LAT_DEG |
3 |
60 |
62 |
Text |
222 |
Latitude
minutes |
LAT_MIN |
2 |
63 |
64 |
Text |
223 |
Latitude
seconds |
LAT_SEC |
6 |
65 |
70 |
Text |
224 |
Longitude
degrees |
LON_DEG |
2 |
71 |
72 |
Text |
225 |
Longitude
minutes |
LON_MIN |
2 |
73 |
74 |
Text |
226 |
Longitude
seconds |
LON_SEC |
6 |
75 |
80 |
Text |
|
Comments |
COMMENTS |
30 |
81 |
110 |
Text |
File
name: xxxxBLDG.s
(replace "xxxx" with the institution code,
and "s" by the submission number)
Sort
order: Any order
Unique key: Element 201 concatenated with Element 205
Element number |
Element name |
Field name |
Width |
Start column |
End column |
Data type |
201 |
Campus
code |
CAMPCODE |
3 |
1 |
3 |
Text |
205 |
Building
code |
BLDGCODE |
5 |
4 |
8 |
Text |
206 |
Building
name |
BLDGNAME |
50 |
9 |
58 |
Text |
207 |
Ownership
code |
OWNCODE |
2 |
59 |
60 |
Text |
208 |
Year
of construction |
YEARCONS |
4 |
61 |
64 |
|
209 |
Building
condition |
BUILDCON |
1 |
65 |
65 |
Numeric |
210 |
Inventory
value |
INVENTVL |
10 |
66 |
75 |
Numeric |
211 |
Total
assignable square metres |
TOTALASM |
6 |
76 |
81 |
Numeric |
212 |
Total
gross square metres |
TOTALGSM |
6 |
82 |
87 |
Numeric |
213 |
Standard
cost unit |
STDCSTUN |
10 |
88 |
97 |
Numeric |
Comments |
COMMENTS |
30 |
98 |
127 |
Text |
File
name: xxxxROOM.s (replace "xxxx"
with the institution code, and "s" by the submission number)
Sort
order: Any order
Unique key: Element 201 concatenated with Element 205
concatenated with Elements 214 and 215
Element number |
Element name |
Field name |
Width |
Start column |
End column |
Data type |
201 |
Campus
code |
CAMPCODE |
3 |
1 |
3 |
Text |
205 |
Building
code |
BLDGCODE |
5 |
4 |
8 |
Text |
214 |
Room
number |
ROOMNMBR |
10 |
9 |
18 |
Text |
215 |
Room
proration key |
ROOMPKEY |
3 |
19 |
21 |
Numeric |
216 |
Space
use category |
SPACECAT |
4 |
22 |
25 |
Text |
217 |
Square
metres |
SQMETRES |
10 |
26 |
35 |
Numeric |
218 |
Number
of stations |
STATIONS |
10 |
36 |
45 |
Numeric |
219 |
PCS
code |
SPACEPCS |
3 |
46 |
48 |
Text |
220 |
CESM
code |
SPCECESM |
4 |
49 |
52 |
Text |
Comments |
COMMENTS |
30 |
53 |
82 |
Text |
File
name: xxxxROOM.s (replace "xxxx"
with the institution code, and "s" by the submission number)
Sort
order: Any order
Unique key: Element 201 concatenated with Element 205
concatenated with Elements 214 and 215
Element number |
Element name |
Field name |
Width |
Start column |
End column |
Data type |
201 |
Campus
code |
CAMPCODE |
3 |
1 |
3 |
Text |
205 |
Building
code |
BLDGCODE |
5 |
4 |
8 |
Text |
214 |
Room
number |
ROOMNMBR |
10 |
9 |
18 |
Text |
215 |
Room
proration key |
ROOMPKEY |
4 |
19 |
22 |
Numeric |
216 |
Space
use category |
SPACECAT |
4 |
23 |
26 |
Text |
217 |
Square
metres |
SQMETRES |
10 |
27 |
36 |
Numeric |
218 |
Number
of stations |
STATIONS |
10 |
37 |
46 |
Numeric |
219 |
PCS
code |
SPACEPCS |
3 |
47 |
49 |
Text |
220 |
CESM
code |
SPCECESM |
6 |
50 |
55 |
Text |
Comments |
COMMENTS |
30 |
56 |
85 |
Text |