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.

 

 


 

CAMPUS FILE

 

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

 

BUILDING FILE

 

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

Numeric

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

 

ROOM FILE FOR 2007

 

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

 

ROOM FILE FROM 2008

 

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