Data Validation provides two levels of checking for potential errors: coarse and fine. Coarse errors are those that indicate file damage such as data fragments and illegal characters; illegal field values or logic errors that cannot be created from within SPARKS thereby suggesting manipulation using dBase, etc; and major logic errors within a specimen record that conflict with data analysis. Fine errors are intended to warnings about potentially problematic data entry conventions; missing values; and minor logic errors. Several error codes have been split intc separate coarse and fine versions depending upon the situation. For example, errors T-11, T-12, T-14, T-15 are coarse for transaction events and fine for management and social group events.
Master Errors - Coarse
ERROR M-01: Empty Studbook ID
Studbook ID field is blank
ERROR M-02: Duplicate Studbook ID
There are two records with the same studbook ID. This may indicated a duplicate record (the same specimen entered twice) or two individuals with the same studbook ID.
ERROR M-03: Illegal ASCII Character in Studbook ID
The <STUDBOOK ID> field should only contain numbers or numbers preceded by the letter "T" (for temporary ID numbers). This message indicates that other characters are present.
ERROR M-07: Master Record Orphan
This indicates that a specimen record exists but there is no corresponding event record. Every specimen should have at least one event (i.e., captive birth, capture, or unknown origin).
ERROR M-08: Invalid First Event
The first event must be entered as a birth or capture. This message indicates that the first event is either a transfer, a release, or a death!
ERROR M-09: Illegal Sex Code
Specimen is entered as incorrect sex.
ERROR M-10: Illegal Rearing Code
84
ERROR M-12: Incompatible Hatch / Birth Type
The <BIRTH TYPE> is entered as {WILD CAUGHT}, but the first event is a captive birth
ERROR M-13C: COARSE Empty Hatch / Birth Type
The <BIRTH TYPE> field is blank.
ERROR M-14: Illegal Hatch / Birth Type Code
The <BIRTH TYPE> field contains a character or number other than those recognized by SPARKS.
ERROR M-15: Missing Master Birth Date for a Captive Birth / Hatch
SPARKS stores a specimen's birth date in two fields (these dates should be the same!). This message indicates that the <BIRTH DATE> field in the Master Record window of the SPARKS Data Entry screen is blank.
ERROR M-16: Missing Master Birth Date for a Captive Birth / Hatch
ERROR M-17: Birth / Hatch Date Conflict
Birth event date and birth date do not match.
ERROR M-18: Illegal Birth l Hatch Date Estimate Character
Character used to indicate birth/hatch date estimate must be chosen from those listed.
ERROR M-20: Empty Master Birth / Hatch Date w/o Estimate = 'U' for a Wild Capture
Master birth/hatch date field is empty; no estimate is given.
ERROR M-21: Birth / Hatch Date After Capture or First Event
The first event must be entered as a birth or capture.
ERROR M-22: Birth / Hatch Date In Future
Birth/hatch date has been entered as occurring in the future.
Dam Error Conditions - Coarse
ERROR D-01: illegal ASCII Character in Dam Studbook ID
The <STUDBOOK ID> field should only contain numbers or numbers preceded by the letter "7" (for temporary ID numbers). This message indicates that other characters are present.
85
ERROR D-04: Dam-Offspring Studbook ID Conflict
The ID number(s) of offspring listed for the dam does not cross-match the dam ID given for offspring.
ERROR D-05: Dam Sex Error
Dam is not listed as female.
ERROR D-06: Dam ID Not Found In Studbook
Dam ID has not been entered into studbook.
ERROR D-07: Unable to determine Dam location prior to specimen hatch / birth
Dam location data prior to specimen birth is missing.
ERROR D-08: Dam Lost-To-Follow-Up prior to Specimen hatch / birth
Specimen birth location differs from dam location.
ERROR D-09: Dam Hatch/Birth Date Conflict - Born after offspring.
Dam hatch/birth date is entered as occurring after its offspring was born.
ERROR D-10: Dam Death Conflict - Dam dead before offspring birth
Dam death date is entered as occuring before its offspring was born.
ERROR D-11: Dam in Wild at time of Specimen hatch / birth
The first event must be entered as a captive birth or capture.
ERROR D-13: Dam Location Conflict - Does Not Agree With Specimen Birth / Hatch Check that location ID for both dam and offspring match; check that removal dates are correct.
ERROR D-15: Dam ID inconsistent with specimen first event / origin
Dam ID does not correspond to offspring birth or first event.
Sire Error Conditions - Coarse
ERROR S-01: Illegal ASCII Character in Sire Studbook ID
ERROR S-04: Sire - Offspring Studbook ID Conflict
The ID number(s) of offspring listed for the sire does not cross-match the sire ID given for offspring.
86
ERROR S-05: Sire Sex Error
Sire is not listed as a male.
ERROR S-06: Sire ID Not Found In Studbook
Sire ID has not been entered into studbook.
ERROR S-07: Unable to determine Sire location prior to Specimen hatch / birth
Sire location data prior to specimen birth is missing.
ERROR S-08: Sire Lost-To-Follow-Up prior to Specimen hatch / birth
Specimen birth location differs from sire location.
ERROR S-09: Sire Hatch/Birth Date Conflict - Born after offspring.
Sire hatch/birth date is entered as occuring after its offspring was born.
ERROR S-15: Sire ID inconsistent with specimen first event
Sire ID does not correspond to offspring birth or first event.
Transaction Stream Errors - Coarse
ERROR T-01: Multiple Origin Events
The first event date and birth date are entered as different dates.
ERROR T-03: Events After Death
Events are entered after death of specimen.
ERROR T-04: No Acquisition Event
The first event must be entered as a birth or capture.
ERROR T-06: Transfer After Release
ERROR T-07: Multiple Conflicting Release Events
ERROR T-08: Embedded Lost-To-Follow-Up
Event data is missing prior to final entry.
ERROR T-XX: Internal Program Error in Interpreting Events Stream
ERROR T-10: Empty Transaction Date
The date a transaction occurred is blank.
87
ERROR T-11C: COARSE Transaction Date Prior To Birth Date The first event must be entered as a birth or capture.
ERROR T-12C: COARSE Transaction Date in the Future
Date entered for transaction has been entered as occuring in the future.
ERROR T-13: Invalid Transaction Date Estimator
Code for date estimate must be chosen from those listed.
ERROR T-14C: COARSE Removal Date Prior To Birth Date
The first event must be entered as a birth or capture.
ERROR T-15C: COARSE Removal Date in the Future
Date entered for removal has been entered as occuring in the future.
ERROR T-16: Invalid Removal Date Estimator
Code for date estimate must be chosen from those listed.
ERROR T-17: invalid Transaction Code
Transaction code must be chosen from those listed.
ERROR T-18: Missorted Transactions
ERROR T-19: Removal-Transaction Date Overlap (between records)
ERROR T-20C: COARSE Removal-Transaction Date Large Gap
ERROR T-21: Removal-Transaction Date Conflict (same record)
ERROR T-22: Non-Physical Birth
File Relationship Errors - Coarse
ERROR F-01: Moves.dbf Record Orphan
ERROR F-02: Specials.dbf Record Orphan
ERROR F-03: UDF.dbf Record Orphan
88
FINE Errors
Master Errors - Fine
Error M-04: Inappropriate ASCII Character in Studbook ID
Error M-05: Illegal Justification of Studbook ID
Error M-06: Improper or Inappropriate Studbook ID
Error M-11: Incompatible Rearing Code
Error M-13f: FINE Empty Hatch / Birth Type
Hatch/birth type field is empty.
Error M-19: Hatch I Birth Date Estimate Conflict
Birth date is entered under master birth date and as an estimate.
Dam Error Conditions - Fine
Error D-02: Inappropriate ASCII Character in Dam Studbook ID
Error 0-03: Illegal Justification of Dam Studbook ID
Error D-12: No Parental ID Assumptions Recorded
Error D-14: Blank Dam ID
Dam ID has not been entered.
Sire Error Conditions - Fine
Error S-02: Inappropriate ASCll Character in Sire Studbook ID
Error S-03: lllegal Justification of Sire Studbook ID
Error S-10: Sire Death Conflict - Sire Dead Before Offspring birth / hatch
Sire death date is entered as occuring before its offspring was born.
89
Error S-11: Sire in Wild at time of Specimen hatch / birth
The first event must be entered as a captive birth or capture.
Error S-12: No Parental ID Assumptions Recorded
Error S-13: Sire Location Conflict - Does Not Agree With Specimen Birth / Hatch Check that location ID for both sire and offspring match; check that removal dates are correct.
Error S-14: Blank Sire ID
Sire ID has not been entered.
Transaction Stream Errors - Fine
Error T-02: First Event = Transfer
The first event must be entered as a birth or capture.
Error T-05: Multiple Death Events
Specimen death event entered more than once.
Error T-09: Lost-To-Follow-Up
Final history on the specimen is missing
Error T-11f: FINE Transaction Date Prior To Birth Date
The first event must be entered as a birth or capture.
Error T-12f: FINE Transaction Date in the Future
Date entered for transaction has been entered as occuring in the future.
Error T-14f: FINE Removal Date Prior To Birth Date
Date for specimen removal has been entered as occuring before it was born.
Error T-15f: FINE Removal Date in the Future
Date for specimen removal has been entered as occuring in the future.
Error T-20f: FINE Removal-Transaction Date Small Gap
90