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: 20 January 2009

 

EDIT VALIDATION RULES 201**  TO  210**

 

ERROR No.

ERROR MESSAGE TO APPEAR ON VALIDATION REPORT

ERROR TYPE

VALIDATION RULE

ELEMENT BEING TESTED

TABLES USING THE VALID-ATION

20101

20101:  E201 (campus code) is blank.

Fatal

E201 (campus code) must not be all spaces or null

201

CAMP

BLDG

ROOM

20102

20102:  E201 (campus code) + E204 (campus province code) duplicated in another record.

Fatal

The value for E201 (campus code) + E204 (campus province code) must not be duplicated in another record in the table

201

CAMP

20103

20103:  E201 (campus code) + E205 (building code) duplicated in another record.

Fatal

The value for E201 (campus code) + E205 (building code) must not be duplicated in another record in the table

201

BLDG

20104

20104:  E201 (campus code) + E205 (building code) + E214 (room code) + E215 (room proration key) duplicated in another record.

Fatal

The value for E201 (campus code) + E205 (building code) + E214 (room code) + E215 (room proration key) must not be duplicated in another record in the table

201

ROOM

20105

20105: E201 (campus code) not found in CAMP table

Fatal

E201 (campus code) must be in a record in the CAMP table

201

ROOM

BLDG

20201

20201:  E202 (Campus name) is blank.

Fatal

E202 (campus name) must not be all spaces or null

202

CAMP

20301

20301:  E203 (campus postcode) is not a valid code.

Fatal

E203 (campus postcode) must be exist as a value in the "Campus postcode" field in a record in the Access table "LookupCodesPOST", and includes "XXXX", "YYYY" and "ZZZZ".

203

CAMP

20401

20401:   E204 (campus province code) is not a valid code.

Fatal

E204 (campus province code) must be one of the codes specified in the Data Element Dictionary as being valid for this element

204

CAMP

20501

20501:  E205 (building code) is blank.

Fatal

E205 (building code) must not be all spaces or null

205

BLDG

ROOM

20502

20502:  E205 (building code) not found in BLDG table

Fatal

E205 (building code) must be in a record in the BLDG table

205

ROOM

20601

20601:  E206 (building name) is blank.

Fatal

E206 (building name) must not be all spaces or null

206

BLDG

20701

20701:  E207 (ownership code) is not a valid code.

Fatal

E207 (ownership code) must be one of the codes specified in the Data Element Dictionary as being valid for this element

207

BLDG

20801

20801:   E208 (year of construction) is not a valid year in yyyy format.

Fatal

E208 (year of construction) must be in yyyy format.

208

BLDG

20901

20901:   E209 (building condition) is not a valid code.

Fatal

E209 (building condition) must be one of the codes specified in the Data Element Dictionary as being valid for this element

209

BLDG

21001

21001:     E210 (inventory value) is less than 0000000001.

Fatal

E210 (inventory value) must be a number > or equal to 0000000001 but < or equal to 9999999999.

210

BLDG