The validation rules below were downloaded on 14 December 2010
R001 is a date field and should be in the following format: dd/MM/yyyy. (Date of Survey)
R002 is a string field and should be no longer than 255 characters. (Weather Conditions)
R003 is a string field and should be no longer than 255 characters. (Assessor Last Name)
R004 is a string field and should be no longer than 255 characters. (Name of Alliance Accredited System)
R005 is a string field and should be no longer than 255 characters. (Distance measurement accuracy)
R006 is a string field and should be no longer than 255 characters. (Spatial measurement accuracy)
R100 is a required string field and should be one of the following case insensitive values: yes,no.
R101 is a required string field and should be one of the following case insensitive values: yes,no.
R102 is a required string field and should be one of the following case sensitive values: LRRS,State Strategic Roads,Regional and Other District Roads,Other Local Government Road,Auslink A,Auslink B,Other Road.
R103 is a required string field and should be at least 1 characters long, but no longer than 255 characters.
R104 is a required string field and should be at least 1 characters long, but no longer than 255 characters.
R105 is a required string field and should be at least 1 characters long, but no longer than 255 characters.
R106 is a required string field and should be at least 1 characters long, but no longer than 6 characters.
R107 is a required string field and should be one of the following case insensitive values: 1,1A,1B,1C,2,2A,2B,3,3A,3B,3C,4,4A,4B,5,5A,5B,5C,6,6A,6B,6C,7,7A,7B,7C,8,8A,8B,8C,9,9A,9B,9C.
R108 is a required string field and should be at least 1 characters long, but no longer than 6 characters.
R109 is a string field and should be no longer than 6 characters.
R110 is a required string field and should be one of the following case insensitive values: A,B,C,L,R,M,P,Q.
R111 is a required string field and should be at least 1 characters long, but no longer than 255 characters.
R200 is a required string field and should be at least 1 characters long, but no longer than 255 characters.
R201 is a required number field and should have no more than 3 decimal places.
R202 is a required number field and should have no more than 3 decimal places.
R203 is a required string field and should be one of the following case insensitive values: increasing,decreasing.
R204 is a string field and should be one of the following case insensitive values: flat,rolling,mountainous.
R205 is a string field and should be one of the following case insensitive values: wet non reactive,wet reactive,dry non reactive,dry reactive.
R208 is a string field and should be no longer than 255 characters.
R209 is a string field and should be no longer than 255 characters.
R300 is a blank string IF R304 is UNSEALED
R300 is a required number with no decimal places IF R304 is NOT UNSEALED
R301 is a required number field and should have no more than 1 decimal places and is between 4 and 50.
R302 is a blank string IF R304 is UNSEALED
R302 is a required number field and should have no more than 1 decimal places and is between 4 and 50 IF R304 is NOT UNSEALED
R303 is a blank string IF R304 is UNSEALED
R303 is a required number field and should have no more than 1 decimal places and is between 4 and 50 IF R304 is NOT UNSEALED
R304 is a required string field and should be one of the following case insensitive values: unsealed,sprayed seal,asphalt,concrete,pavers.
R305 is a required date field and should be in the following format: yyyy.
R306 is a required string field and should be one of the following case insensitive values: unformed,formed,formed and gravelled,sealed.
R307 is a required string field and should be one of the following case insensitive values: above,level,below.
R308 is a required date field and should be in the following format: yyyy.
R309 is a number with no decimal places.
R310 is a required number with no decimal places and is between 1 and 10.
R311 is a number with no decimal places and is between 1 and 10.
R312 is a number with no decimal places and is between 1 and 10.
R313 is a number with no decimal places and is between 1 and 10.
R314 is a number with no decimal places and is between 1 and 10.
R315 is a number with no decimal places and is between 1 and 10.
R316 is a number field and should have no more than 1 decimal places and is between 0.5 and 10.
R317 is a number field and should have no more than 1 decimal places and is between 0.5 and 10.
R318 is a number field and should have no more than 1 decimal places and is between 0.5 and 10.
R319 is a number field and should have no more than 1 decimal places and is between 2 and 20.
R320 is a number with no decimal places and is between 10 and 200.
R321 is a string field and should be one of the following case insensitive values: rigid,unbound granular,cement treated,bituminous,paver,other.
R322 is a string field and should be no longer than 255 characters.
R323 is a number with no decimal places and is between 50 and 1000.
R324 is a string field and should be one of the following case insensitive values: cement,lime,cement and lime,foam bitumen,chemical,other.
R325 is a string field and should be no longer than 255 characters.
R326 is a number with no decimal places and is between 50 and 1000.
R327 is a string field and should be one of the following case insensitive values: cement,lime,cement and lime,foam bitumen,chemical,other.
R328 is a string field and should be no longer than 255 characters.
R329 is a number with no decimal places and is between 50 and 1000.
R330 is a string field and should be one of the following case insensitive values: cement,lime,cement and lime,foam bitumen,chemical,other.
R331 is a string field and should be no longer than 255 characters.
R332 is a number with no decimal places and is between 50 and 1000.
R333 is a string field and should be one of the following case insensitive values: cement,lime,cement and lime,foam bitumen,chemical,other.
R334 is a number field and should have no more than 1 decimal places and is between 0 and 10.
R335 is a string field and should be one of the following case insensitive values: unsealed,sprayed seal,asphalt,concrete,pavers.
R336 is a string field and should be no longer than 255 characters.
R337 is a number with no decimal places and is between 50 and 1000.
R338 is a string field and should be one of the following case insensitive values: cement,lime,cement and lime,foam bitumen,chemical,other.
R339 is a number field and should have no more than 1 decimal places and is between 0 and 10.
R340 is a string field and should be one of the following case insensitive values: unsealed,sprayed seal,asphalt,concrete,pavers.
R341 is a string field and should be no longer than 255 characters.
R342 is a number with no decimal places and is between 50 and 1000.
R343 is a string field and should be one of the following case insensitive values: cement,lime,cement and lime,foam bitumen,chemical,other.
R344 is a string field and should be one of the following case insensitive values: concrete,timber,glass,steel,composite,other.
R345 is a number field and should have no more than 1 decimal places and is between 1 and 20.
R346 is a string field and should be one of the following case insensitive values: concrete,timber,glass,steel,composite,other.
R347 is a number field and should have no more than 1 decimal places and is between 1 and 20.
R348 is a string field and should be one of the following case insensitive values: uncontrolled,channelised,traffic signals,roundabout,grade separated.
R349 is a string field and should be one of the following case insensitive values: emergency telephone,other.
R350 is a string field and should be one of the following case insensitive values: lighting part standard,lighting to standard,no lighting.
R351 is a string field and should be one of the following case insensitive values: lighting part standard,lighting to standard,no lighting.
R352 is a string field and should be one of the following case insensitive values: variable sign,other.
R353 is a string field and should be one of the following case insensitive values: barrier,mountable,semi-mountable,other.
R354 is a string field and should be one of the following case insensitive values: barrier,mountable,semi-mountable,other.
R355 is a string field and should be one of the following case insensitive values: full width concrete,concrete path,full width asphalt,asphalt path,full width spray seal,spray seal path ,full width pavers,paver path,grass.
R356 is a number field and should have no more than 1 decimal places and is between 0 and 10.
R357 is a string field and should be one of the following case insensitive values: full width concrete,concrete path,full width asphalt,asphalt path,full width spray seal,spray seal path ,full width pavers,paver path,grass.
R358 is a number field and should have no more than 1 decimal places and is between 0 and 10.
R359 is a number with no decimal places and is between 1 and 100.
R360 is a number with no decimal places and is between 100 and 20000.
R361 is a number with no decimal places and is between 100 and 20000.
R362 is a string field and should be one of the following case insensitive values: RC pipe,FRC pipe,uPVC pipe,HDPE Pipe,Steel pipe,RC box culvert,other.
R363 is a number field and should have no more than 1 decimal places and is between 0 and 10.
R364 is a string field and should be one of the following case insensitive values: concrete barrier,steel channel,armco guardrail,grassed channel,grassed median,paved median,wire rope,other.
R365 is a string field and should be one of the following case insensitive values: armco,double armco,wire rope,steel channel,concrete barrier,other.
R366 is a string field and should be one of the following case insensitive values: armco,double armco,wire rope,steel channel,concrete barrier,other.
R367 is a string field and should be one of the following case insensitive values: yes,no.
R368 is a string field and should be one of the following case insensitive values: yes,no.
R369 is a string field and should be one of the following case insensitive values: yes,no.
R370 is a string field and should be one of the following case insensitive values: yes,no.
R371 is a string field and should be one of the following case insensitive values: full width concrete,concrete path,full width asphalt,asphalt path,full width spray seal,spray seal path ,full width pavers,paver path,grass.
R372 is a number field and should have no more than 1 decimal places and is between 0 and 10.
R373 is a string field and should be one of the following case insensitive values: yes,no.
R374 is a string field and should be one of the following case insensitive values: yes,no.
R375 is a string field and should be one of the following case insensitive values: yes,no.
R376 is a string field and should be one of the following case insensitive values: yes,no.
R377 is a string field and should be one of the following case insensitive values: yes,no.
R378 is a string field and should be one of the following case insensitive values: boom gates,flashing lights,signs,other.
R379 is a string field and should be one of the following case insensitive values: yes,no.
R380 is a string field and should be one of the following case insensitive values: yes,no.
R400 is a blank string IF R304 is UNSEALED
R400 is a required number with no decimal places and is between 1 and 5 IF R304 is NOT UNSEALED
R401 is a blank string IF R304 is UNSEALED
R401 is a required number with no decimal places and is between 1 and 5 IF R304 is NOT UNSEALED
R401 should be blank if R402 is set
R402 is a blank string IF R304 is UNSEALED
R402 is a required number with no decimal places and is between 1 and 5 IF R304 is NOT UNSEALED
R402 should be blank if R401 is set
R403 is a blank string IF R304 is UNSEALED
R403 is a required number with no decimal places and is between 1 and 5 IF R304 is NOT UNSEALED
R404 is a blank string IF R304 is NOT UNSEALED
R404 is a required number with no decimal places and is between 1 and 5 IF R304 is UNSEALED
R404 should be blank if R405 is set
R405 is a blank string IF R304 is NOT UNSEALED
R405 is a required number with no decimal places and is between 1 and 5 IF R304 is UNSEALED
R405 should be blank if R404 is set
R406 is a blank string IF R304 is NOT UNSEALED
R406 is a required number with no decimal places and is between 1 and 5 IF R304 is UNSEALED
R407 is a string field and should be no longer than 255 characters.
R408 is a string field and should be no longer than 255 characters.
R409 is a string field and should be no longer than 255 characters.
R410 is a number with no decimal places and is between 1 and 5.
R411 is a number with no decimal places and is between 1 and 5.
R412 is a string field and should be no longer than 255 characters.
R413 is a number with no decimal places and is between 1 and 5.
R414 is a number with no decimal places and is between 1 and 5.
R415 is a number with no decimal places and is between 1 and 5.
R416 is a number with no decimal places and is between 0 and 100.
R417 is a number field and should have no more than 1 decimal places and is between 1 and 20.
R418 is a number field and should have no more than 1 decimal places and is between 0 and 20.
R419 is a number with no decimal places and is between 1 and 100.
R420 is a number with no decimal places and is between 1 and 100.
R421 is a number with no decimal places and is between 1 and 300.
R422 is a number with no decimal places and is between 1 and 5.
R423 is a number with no decimal places and is between 1 and 5.
R424 is a number with no decimal places and is between 1 and 5.
R425 is a number with no decimal places and is between 1 and 300.
R426 is a number with no decimal places and is between 1 and 5.
R427 is a number with no decimal places and is between 1 and 5.
R428 is a number with no decimal places and is between 1 and 5.
R429 is a number with no decimal places and is between 1 and 5.
R430 is a number with no decimal places and is between 1 and 5.
R431 is a number with no decimal places and is between 1 and 5.
R432 is a number with no decimal places and is between 1 and 5.
R433 is a number with no decimal places and is between 1 and 5.
R434 is a number with no decimal places and is between 1 and 5.
R435 is a number with no decimal places and is between 1 and 5.
R436 is a number with no decimal places and is between 1 and 5.
R437 is a number with no decimal places and is between 1 and 5.
R438 is a number with no decimal places and is between 1 and 5.
R439 is a number with no decimal places and is between 1 and 5.
R440 is a number with no decimal places and is between 1 and 5.
R441 is a number with no decimal places and is between 1 and 5.
R442 is a number with no decimal places and is between 1 and 5.
R443 is a number with no decimal places and is between 1 and 5.
R444 is a number with no decimal places and is between 1 and 5.
R445 is a number with no decimal places and is between 1 and 5.
R446 is a number with no decimal places and is between 1 and 5.
R447 is a number with no decimal places and is between 1 and 5.
R448 is a number with no decimal places and is between 1 and 5.
R449 is a number with no decimal places and is between 1 and 5.
R450 is a number with no decimal places and is between 1 and 5.
R451 is a number with no decimal places and is between 1 and 5.
R500 is a required number with no decimal places.
R500 should be blank if R501 is set
R501 is a required number with no decimal places.
R501 should be blank if R500 is set
R502 is a required date field and should be in the following format: yyyy.
R503 is a required number field and should have no more than 1 decimal places and is between 0 and 100.
R503 should be blank if R504 is set
R504 is a required number field and should have no more than 1 decimal places and is between 0 and 100.
R504 should be blank if R503 is set
R505 is a required string field and should be at least 1 characters long, but no longer than 255 characters.
R506 is a number with no decimal places.
R507 is a number with no decimal places.
R508 is a number with no decimal places.
R509 is a string field and should be no longer than 255 characters.
R510 is a number with no decimal places.
R511 is a number with no decimal places.
R512 is a number with no decimal places.
R513 is a number with no decimal places.
R514 is a number with no decimal places.
R515 is a number with no decimal places.
R516 is a number with no decimal places.
R517 is a number with no decimal places.
R518 is a number with no decimal places.
R519 is a number with no decimal places.
R520 is a number with no decimal places.
R521 is a number with no decimal places.
R522 is a number with no decimal places.
R523 is a string field and should be one of the following case insensitive values: A,B,C,D,E,F.
R524 is a number field and should have no more than 1 decimal places.
R525 is a number with no decimal places.
R526 is a string field and should be one of the following case insensitive values: Restricted, Semi,B-double, B-triple, Type 1, Type 2, PBSL1,PBSL2,PBSL3,PBSL4,Other.
R527 is a string field and should be one of the following case insensitive values: yes,no.
R528 is a string field and should be one of the following case insensitive values: high volume, medium volume, low volume, nil.
R529 is a string field and should be one of the following case insensitive values: yes,no.
R530 is a string field and should be one of the following case insensitive values: high volume, medium volume, low volume, nil.
R531 is a string field and should be one of the following case insensitive values: high volume, medium volume, low volume, nil.
R532 is a number with no decimal places and is between 1 and 366.
R533 is a number field and should have no more than 1 decimal places and is between 0 and 50.
R534 is a number with no decimal places and is between 0 and 200.
R535 is a string field and should be one of the following case insensitive values: yes,no.
R536 is a string field and should be one of the following case insensitive values: yes,no.
R537 is a string field and should be one of the following case insensitive values: yes,no.
R538 is a number with no decimal places.
R539 is a number with no decimal places.
R540 is a number with no decimal places.
R541 is a number with no decimal places.
R542 is a date field and should be in the following format: MM/yyyy.