ICES Marine Data
DATSU
 
DATSU > List of operations > Specification of the format (checks)
 
 
Dataset:
 
Format / Checks / Species
 
Checks
Record:
 
Record Checks:
Duplicate value in record constrainterror
Key Value not recognisederror
Mandatory fielderror
Mandatory recorderror
Missing values in mandatory fieldwarning
Records referring to the same haul and species must have identical values for a number of fieldserror
 
Cross checks
 
Field Checks
RecordTypestartFieldDescription Error Type
CA1RecordType   
CA2QuarterNot in the range specifiedLower:1.000000000000 Upper: 4.000000000000warning
CA3CountryField value is invalid (Rel) - prevents entry to database error
CA3CountryReported ship is not registered for that country warning
CA4ShipField A is not consistent with field B (rel)Ship is not consistent with Gear (rel) error
CA4ShipField value is invalid (Rel) - prevents entry to database error
CA5GearField A is not consistent with field BGear is not consistent with GearEx error
CA5GearField A is not consistent with field BGear is not consistent with DoorType error
CA5GearField value is invalid (Rel) - prevents entry to database error
CA6SweepLngtNot in the range specifiedLower:0.000000000000 Upper: 999.000000000000warning
CA7GearExField value is invalid - prevents entry to database error
CA8DoorTypeField value is invalid (Rel) - prevents entry to database error
CA9StNo   
CA10HaulNoNot in the range specifiedLower:1.000000000000 Upper: 999.000000000000warning
CA11YearNot in the range specifiedLower:1900.000000000000 Upper: 2099.000000000000warning
CA12SpecCodeTypeField value is invalid - prevents entry to database error
CA13SpecCodeLngtClass is larger than allowed for the speciesLngtClass is larger than allowed for the species warning
CA13SpecCodeLngtClass is larger than allowed for the speciesLngtClass is larger than allowed for the species warning
CA13SpecCodeInconsistency between species and field BInconsistency between species and LngtCode error
CA14AreaTypeField value is invalid (Rel) - prevents entry to database error
CA14AreaTypeArea code is not consistent with area type error
CA15AreaCode   
CA16LngtCodeField value is invalid (Rel) - prevents entry to database error
CA17LngtClassIf LengthClassCode = 0 then MinLengthClass must be half cm units error
CA17LngtClassIf LengthClassCode = 1 then MinLengthClass must be cm units error
CA17LngtClassNot in the range specifiedLower:1.000000000000 Upper: 999.000000000000warning
CA17LngtClassIf LengthClassCode = . then MinLengthClass must be mm units error
CA18SexField value is invalid (Rel) - prevents entry to database error
CA19MaturityField value is invalid (Rel) - prevents entry to database error
CA20PlusGrField value is invalid - prevents entry to database error
CA20PlusGrPer haul, species and length class only the oldest age group can be PlusGr error
CA20PlusGrIf a plus group is defined per haul/area and species then all records for this species with age => than the plus group must contain the plus identifier error
CA21AgeRingsNot in the range specifiedLower:0.000000000000 Upper: 30.000000000000warning
CA22CANoAtLngtNot in the range specifiedLower:1.000000000000 Upper: 999.000000000000warning
CA23IndWgtNot in the range specifiedLower:1.000000000000 Upper: 99999.000000000000warning
CA24MaturityScaleField value is invalid (Rel) - prevents entry to database error
CA25FishID   
CA26GenSampField value is invalid - prevents entry to database error
CA27StomSampField value is invalid - prevents entry to database error
CA28AgeSourceField value is invalid (Rel) - prevents entry to database error
CA29AgePrepMetField value is invalid (Rel) - prevents entry to database error
CA30OtGradingField value is invalid (Rel) - prevents entry to database error
CA31ParSampField value is invalid - prevents entry to database error
 

International Council for the Exploration of the Sea (ICES) · Conseil International pour l'Exploration de la Mer (CIEM)
ICES Secretariat · H. C. Andersens Boulevard 44-46, DK 1553, Copenhagen Denmark · Tel: +45 3338 6700 · Fax: +45 3393 4215 · info@ices.dk
Disclaimer © ICES - All Rights Reserved