2003 Data Validations

Error Message
Validation
No site data found A record exists with predetermined info for each site
Quad abbreviation missing
Quad abbreviation/code invalid
Quad code is present and valid
Site number missing
Site number is zero
Site number is present and greater than zero
Placement date missing
Invalid date
Trap placement date is present and valid
Trapper's initials missing
Invalid initials for agency
Trapper initials are present and valid within the agency responsible for the site
Trap type missing
Trap type invalid
Trap type is one of the following: D, M, O (delta, milk carton, omit)
Omit reason missing
Omit reason invalid
A valid reason is included for each omitted site: H, L, O, W, R, V, S, X, B
Duplicate site in quad Each record has a unique quad code and site number
Duplicate UTMs
Duplicate grid node UTMs
UTM coordinates are unique within the UTM zone
Each record corresponds to a unique predetermined grid node

Error Message

Validation

No site data found

A record exists with predetermined info for each site

County code missing
Invalid state and/or county

County code is present and valid

Site number missing
Site number is zero

Site number is present and greater than zero

Placement date missing
Invalid date

Trap placement date is present and valid

Trapper's initials missing
Invalid initials for agency

Trapper initials are present and valid within the agency responsible for the site

Trap type missing
Trap type invalid

Trap type is one of the following: D, M, O (delta, milk carton, omit)

Omit reason missing
Omit reason invalid

A valid reason is included for each omitted site: H, L, O, W, R, V, S, X, B

Duplicate site in county/block

Each record has a unique county code, block_id, and site number

Duplicate UTMs
Duplicate grid node UTMs

UTM coordinates are unique within the UTM zone
Each record corresponds to a unique predetermined grid node

Error Message

Validation

Quad abbreviation missing
Quad abbreviation/code invalid

Quad code is present and valid

Site number missing
Site number is zero

Site number is present and greater than zero

No trap placement record match

A trap placement record exists for this quad and site

Inspection at omitted site

Inspections should be performed on placed traps

Trapper's initials missing
Invalid initials for agency

Trapper initials are present and valid within agency responsible for site

Duplicate inspection

Each record has a unique quad, site, date, and inspection type

(One routine trap inspection and one passing or failing QC inspection are allowed on the same date. A trapper should visit a site only one time in a day.)

Final visit before mid season

All mid season inspection dates are earlier than final inspections

Trap condition missing
Trap condition invalid

Trap condition is one of the following: D, G, I, M
(damaged, good, inaccessible, missing)

Catch value missing

If trap condition is D or G, trap catch must be greater than or equal to zero

Catch Present, Trap Missing/Inaccessible

If trap condition is I or M, trap catch should be blank

QC Field Check code invalid

Field check entry, if present, is either a P or F to indicate a quality control inspection

QC Fail code missing or invalid

If field check entry is F, a valid quality control failure code must be entered (A, C, D, G, I, R, T, U, X, M)

Trap check missing or invalid

Trap check is either M or F (mid season or final)

Duplicate final visit

Only one final routine inspection may be reported for a site
(Supervisors may also report a final QC inspection.)

Error Message

Validation

County code missing
Invalid state and/or county

County code is present and valid

Site number missing
Site number is zero

Site number is present and greater than zero

No trap placement record match

A trap placement record exists for this county, block_id, and site

Inspection at omitted site

Inspections should be performed on placed traps

Trapper's initials missing
Invalid initials for agency

Trapper initials are present and valid within agency responsible for site

Duplicate inspection

Each record has a unique county, block_id, site, date, and inspection type

(One routine trap inspection and one passing or failing QC inspection are allowed on the same date. A trapper should visit a site only one time in a day.)

Final visit before mid season

All mid season inspection dates are earlier than final inspections

Trap condition missing
Trap condition invalid

Trap condition is one of the following: D, G, I, M
(damaged, good, inaccessible, missing)

Catch value missing

If trap condition is D or G, trap catch must be greater than or equal to zero

Catch Present, Trap Missing/Inaccessible

If trap condition is I or M, trap catch should be blank

QC Field Check code invalid

Field check entry, if present, is either a P or F to indicate a quality control inspection

QC Fail code missing or invalid

If field check entry is F, a valid quality control failure code must be entered (A, C, D, G, I, R, T, U, X, M)

Trap check missing or invalid

Trap check is either M or F (mid season or final)

Duplicate final visit

Only one final routine inspection may be reported for a site
(Supervisors may also report a final QC inspection.)

   
  © 2012 Slow the Spread Foundation, Inc.  

Page developed and maintained by Virginia Tech

  Contact Us