| Error Code | Error Message | |
|---|
| BILL-CLKEEL001 |
Cleithrum-to-keel length (CLEITH_KEEL_LEN) is outside database range |
TOC |
| BILL-CLKEEL002 |
Cleithrum-to-keel length (CLEITH_KEEL_LEN) is outside database range |
TOC |
| BILL-EYEFK001 |
EYE_FORK_LEN is outside database range |
TOC |
| BILL-HGIRTH001 |
HALF_GIRTH_MEAS exceeds database maximum or is zero |
TOC |
| BILL-SEX001 |
Billfish GENDER is not one of the valid codes (M, F or U) |
TOC |
| BILL-SPEC001 |
SPECIES_CODE is not a valid billfish code |
TOC |
| BIRD-ASCAPLATDIR001 |
Captured latitude (captured_lat) is in the northern hemisphere. |
TOC |
| BIRD-ASRELLATDIR001 |
Released latitude (released_lat) is in the northern hemisphere. |
TOC |
| BIRD-BILLCLR001 |
BILL_COLOR_ID is not present in the LOP_BIRD_BILL_COLOR table |
TOC |
| BIRD-BILLTIP001 |
BILL_TIP_DIFF_COLOR_YN is not Y or N |
TOC |
| BIRD-CAPLATDIR001 |
Captured latitude (captured_lat) is in the southern hemisphere. |
TOC |
| BIRD-CAPLONDIR001 |
Captured longitude (captured_lon) is in the eastern hemisphere. |
TOC |
| BIRD-CAPREL001 |
Release date/time cannot occur before capture date/time |
TOC |
| BIRD-CAPTUREDT001 |
CAPTURED DATETIME is not between departure and arrival dates |
TOC |
| BIRD-CAPTUREDT002 |
WARNING: The CAPTURED_DATETIME is not within a day of the RELEASED_DATETIME |
TOC |
| BIRD-CAPTUREDT003 |
WARNING: The CAPTURED_DATETIME is after the RELEASED_DATETIME |
TOC |
| BIRD-COLLFRMV001 |
COLLECT_FORM_VERS is blank (BIRDS form)
|
TOC |
| BIRD-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (BIRDS form) |
TOC |
| BIRD-DISP001 |
ENFORCEMENT ISSUE!!! Seabird was treated as catch (kept) |
TOC |
| BIRD-DISPOSID001 |
DISPOSITION_ID for this bird is blank |
TOC |
| BIRD-DISPOSID002 |
DISPOSITION_ID is not present in the LOP_ANIMAL_DISPOSITION table |
TOC |
| BIRD-ENTANG001 |
ENTANGLED_YNU is not Y, N or U |
TOC |
| BIRD-ENTANGLOC001 |
ENTANGLED_LOC_ID is not present in the LOP_ENTANGLED_LOC table |
TOC |
| BIRD-GRATTCH001 |
GEAR_ATTACHED_TYPE_ID is not present in the LOP_GEAR_ATTACHED_TYPE table |
TOC |
| BIRD-GRRMVL001 |
GEAR_REMVL_TYPE_ID is not present in the LOP_GEAR_REMVL_TYPE table |
TOC |
| BIRD-HEADCLR001 |
HEAD_COLOR_ID is not present in the LOP_BIRD_HEAD_COLOR table |
TOC |
| BIRD-HICAPLATDIR001 |
Captured latitude (captured_lat) is in the southern hemisphere. |
TOC |
| BIRD-HICAPLONDIR001 |
Captured longitude (captured_lon) is in the eastern hemisphere. |
TOC |
| BIRD-HIRELLATDIR001 |
Released latitude (released_lat) is in the southern hemisphere. |
TOC |
| BIRD-HIRELLONDIR001 |
Released longitude (released_lon) is in the eastern hemisphere. |
TOC |
| BIRD-HKD001 |
HOOKED_YNU is not Y, N or U |
TOC |
| BIRD-HKDLOC001 |
HOOKED_LOC_ID is not present in the LOP_HOOKED_LOC table |
TOC |
| BIRD-LANDED001 |
LANDED_YN is not Y or N |
TOC |
| BIRD-LTDVCCLR001 |
LITE_DEVICE_COLOR_ID is not present in the LOP_COLOR table |
TOC |
| BIRD-LTDVCPROX001 |
LITE_DEVICE_PROX_ID is not present in the LOP_LITE_DEVICE_PROX table |
TOC |
| BIRD-MANTLCLR001 |
MANTLE_COLOR_ID is not present in the LOP_BIRD_MANTLE_COLOR table |
TOC |
| BIRD-RELLATDIR001 |
Released latitude (released_lat) is in the southern hemisphere. |
TOC |
| BIRD-RELLONDIR001 |
Released longitude (released_lon) is in the eastern hemisphere. |
TOC |
| BIRD-RLSDDT001 |
RELEASED DATETIME is not between departure and arrival dates |
TOC |
| BIRD-SPECIDNUM001 |
SPECIMEN_IDNUM is not UPPERCASE |
TOC |
| BIRD-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (BIRDS table) |
TOC |
| BIRD-TABVERS002 |
TAB_VERS_ID is not in the LOPADM_TAB_VERS table |
TOC |
| BIRD-TAGPRESNT001 |
TAGS_PRESENT_YNU is not Y, N or U |
TOC |
| BIRDMIT-BLUEDYED001 |
Blue-dyed bait was used during the set but not during the haul |
TOC |
| BIRDMIT-BLUEDYED002 |
Blue-dyed bait was used during the haul but not during the set |
TOC |
| BIRDMIT-BRNCHLNWGTHD001 |
The branchline was marked as weighted during the set but not during the haul. |
TOC |
| BIRDMIT-BRNCHLNWGTHD002 |
The branchline was marked as weighted during the haul but not during the set. |
TOC |
| BIRDMIT-COLLFRMV001 |
COLLECT_FORM_VERS is blank (BIRD MITIGATION form) |
TOC |
| BIRDMIT-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (BIRD MITIGATION form) |
TOC |
| BIRDMIT-DHBIRDSPRST001 |
Strategic offal and/or bait discard was checked during the haul but no birds were present. If no birds were present discard cannot be strategic. |
TOC |
| BIRDMIT-DSBIRDSPRST001 |
Strategic offal and/or bait discard was checked during the set but no birds were present. If no birds were present discard cannot be strategic. |
TOC |
| BIRDMIT-FLTS001 |
Number of floats observed (NUM_FLTS_OBSRVD) is blank |
TOC |
| BIRDMIT-FLTS002 |
Number of floats observed (NUM_FLTS_OBSRVD) exceeds database maximum |
TOC |
| BIRDMIT-FLTS003 |
Number of floats observed (NUM_FLTS_OBSRVD) is outside debriefer manual limits |
TOC |
| BIRDMIT-FLTS004 |
The number of floats observed (NUM_FLTS_OBSRVD) is larger than the number of floats for this set |
TOC |
| BIRDMIT-HICOLLFRMV001 |
COLLECT_FORM_VERS is blank (BIRD MITIGATION form) |
TOC |
| BIRDMIT-HIFLTS001 |
Number of floats observed (NUM_FLTS_OBSRVD) is blank |
TOC |
| BIRDMIT-HITABVERS001 |
The table version id (TAB_VERS_ID) is blank (BIRD MITIG table) |
TOC |
| BIRDMIT-LAT23BAIT001 |
!! ENFORCEMENT ISSUE: BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and the bait was not strategically discarded |
TOC |
| BIRDMIT-LAT23BAITTHWD001 |
!! ENFORCEMENT ISSUE: Fishing occurred on a deep set trip above 23.0 degrees N and the bait was not thawed. |
TOC |
| BIRDMIT-LAT23BAITTHWD002 |
!! ENFORCEMENT ISSUE: Fishing occurred on a deep set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) above 23.0 degrees N and the bait was not thawed. |
TOC |
| BIRDMIT-LAT23BLUEDYE001 |
!! ENFORCEMENT ISSUE: BEGIN SET and/or END SET LATITUDE is 23.0 degrees N or above and bluedyed bait was not used during set. |
TOC |
| BIRDMIT-LAT23BLUEDYE002 |
!! ENFORCEMENT ISSUE: BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and bluedyed bait was not used during haul |
TOC |
| BIRDMIT-LAT23BLUEDYE003 |
!! ENFORCEMENT ISSUE: Deep set trip that was not side-setting and BEGIN SET and/or END SET and/or BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and bluedyed bait was not used during s |
TOC |
| BIRDMIT-LAT23BLUEDYE004 |
!! ENFORCEMENT ISSUE: Deep set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) and BEGIN SET and/or END SET and/or BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degr |
TOC |
| BIRDMIT-LAT23LDRLEN001 |
!! ENFORCEMENT ISSUE: Fishing occurred above 23.0 degrees N and the weight was not within 1m of the hook. |
TOC |
| BIRDMIT-LAT23LDRLEN002 |
!! ENFORCEMENT ISSUE: Fishing occurred on a deep set trip above 23.0 degrees N and the weight was not within 1m of the hook. |
TOC |
| BIRDMIT-LAT23OFFAL001 |
!! ENFORCEMENT ISSUE: BEGIN SET and/or END SET LATITUDE is 23.0 degrees N or above and offal was not strategically discarded |
TOC |
| BIRDMIT-LAT23OFFAL002 |
!! ENFORCEMENT ISSUE: BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and offal was not strategically discarded |
TOC |
| BIRDMIT-LAT23SHOOTER001 |
!! ENFORCEMENT ISSUE: BEGIN SET and/or END SET LATITUDE is 23.0 degrees N or above and a shooter was not used |
TOC |
| BIRDMIT-LAT23SHOOTER002 |
!! ENFORCEMENT ISSUE: Deep set trip and fishing occurred above 23.0 degrees N and a shooter was not used |
TOC |
| BIRDMIT-LAT23STRATDSC001 |
!! ENFORCEMENT ISSUE: BEGIN SET and/or END SET and/or BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and there was no strategic discard during the set and the haul. |
TOC |
| BIRDMIT-LAT23STRATDSC002 |
!! ENFORCEMENT ISSUE: Deep set trip that was not side-setting and BEGIN SET and/or END SET and/or BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and there was no strategic discard duri |
TOC |
| BIRDMIT-LAT23STRATDSC003 |
!! ENFORCEMENT ISSUE: Deep set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) and BEGIN SET and/or END SET is 23.0 degrees N or above and there was no strategic d |
TOC |
| BIRDMIT-LAT23STRATDSC004 |
!! ENFORCEMENT ISSUE: Deep set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) and BEGIN HAUL and/or END HAUL is 23.0 degrees N or above and there was no strategic |
TOC |
| BIRDMIT-LAT23SUNSET001 |
!!! POSSIBLE ENFORCEMENT ISSUE: Shallow set declared but night set not checked off on Bird Mitigation Form. Go to http://aa.usno.navy.mil/data/docs/RS_OneDay.html to make sure it was not a night set. |
TOC |
| BIRDMIT-LAT23WEIGHT001 |
!! ENFORCEMENT ISSUE: Fishing occurred above 23.0 degrees N and the weight was not the minimum 45g. |
TOC |
| BIRDMIT-LAT23WEIGHT002 |
!! ENFORCEMENT ISSUE: Fishing occurred on a deep set trip above 23.0 degrees N and the weight was not the minimum 45g. |
TOC |
| BIRDMIT-LAT23WTDDRPLN001 |
!! ENFORCEMENT ISSUE: BEGIN SET and/or END SET LATITUDE is 23.0 degrees N or above and the drop line was not weighted. |
TOC |
| BIRDMIT-LAT23WTDDRPLN002 |
!! ENFORCEMENT ISSUE: BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and the drop line was not weighted. |
TOC |
| BIRDMIT-LAT23WTDDRPLN003 |
!! ENFORCEMENT ISSUE: Deep set trip and BEGIN SET and/or END SET LATITUDE is 23.0 degrees N or above and the drop line was not weighted. |
TOC |
| BIRDMIT-LAT23WTDDRPLN004 |
!! ENFORCEMENT ISSUE: Deep set trip and BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and the drop line was not weighted. |
TOC |
| BIRDMIT-LAT23WTDDRPLN005 |
!! ENFORCEMENT ISSUE: Deep set trip and BEGIN SET and/or END SET and/or BEGIN HAUL and/or END HAUL LATITUDE is 23.0 degrees N or above and the drop line was not weighted. |
TOC |
| BIRDMIT-NIGHTHAUL001 |
The begin haul was at 2000 hours or thereafter and the night haul is not checked |
TOC |
| BIRDMIT-NIGHTHAUL002 |
The begin haul was before 2000 hours and the night haul is checked |
TOC |
| BIRDMIT-NIGHTSET001 |
The begin set was at 2000 hours or thereafter and the night set is not checked |
TOC |
| BIRDMIT-NIGHTSET002 |
The begin set was before 2000 hours and the night set is checked |
TOC |
| BIRDMIT-NUMBLK001 |
Number of blackfooted albatross during set exceeds database maximum |
TOC |
| BIRDMIT-NUMBLK002 |
Number of blackfooted albatross during haul exceeds database maximum |
TOC |
| BIRDMIT-NUMLAY001 |
Number of laysan albatross during set exceeds database maximum |
TOC |
| BIRDMIT-NUMLAY002 |
Number of laysan albatross during haul exceeds database maximum |
TOC |
| BIRDMIT-NUMSHRT001 |
Number of shorttailed albatross during set exceeds database maximum |
TOC |
| BIRDMIT-NUMSHRT002 |
Number of shorttailed albatross during haul exceeds database maximum |
TOC |
| BIRDMIT-NUMUNID001 |
Number of unidentified albatross during set exceeds database maximum |
TOC |
| BIRDMIT-NUMUNID002 |
Number of unidentified albatross during haul exceeds database maximum |
TOC |
| BIRDMIT-SHALBAITTHWD001 |
!! ENFORCEMENT ISSUE: Fishing occurred on a shallow set trip that was not side-setting and the bait was not thawed. |
TOC |
| BIRDMIT-SHALBAITTHWD002 |
!! ENFORCEMENT ISSUE: Fishing occurred on a shallow set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) and the bait was not thawed. |
TOC |
| BIRDMIT-SHALBLUEDYE001 |
!! ENFORCEMENT ISSUE: Shallow set trip that was not side-setting and bluedyed bait was not used during set and/or haul. |
TOC |
| BIRDMIT-SHALBLUEDYE002 |
!! ENFORCEMENT ISSUE: Shallow set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) and bluedyed bait was not used during set and/or haul. |
TOC |
| BIRDMIT-SHALLDRLEN001 |
!! ENFORCEMENT ISSUE: Fishing occurred on a side-setting shallow set trip and the weight was not within 1m of the hook. |
TOC |
| BIRDMIT-SHALLDRLEN002 |
!! ENFORCEMENT ISSUE: Fishing occurred on a side-setting (setting from side and using bird curtain) shallow set trip and the weight was not within 1m of the hook. |
TOC |
| BIRDMIT-SHALSTRATDSC001 |
!! ENFORCEMENT ISSUE: Shallow set trip that was not side-setting and there was no strategic discard during the set and/or haul. |
TOC |
| BIRDMIT-SHALSTRATDSC002 |
!! ENFORCEMENT ISSUE: Shallow set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) and there was no strategic discard during the set and birds were present. |
TOC |
| BIRDMIT-SHALSTRATDSC003 |
!! ENFORCEMENT ISSUE: Shallow set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) and there was no strategic discard during the haul and birds were present. |
TOC |
| BIRDMIT-SHALSUNSET001 |
!!! POSSIBLE ENFORCEMENT ISSUE: Shallow set trip that was not side-setting and night set not checked off. Go to http://aa.usno.navy.mil/data/docs/RS_OneDay.html to make sure it was not a night set. |
TOC |
| BIRDMIT-SHALSUNSET002 |
!!! POSSIBLE ENFORCEMENT ISSUE: Shallow set trip that was not side-setting (NOT setting from side and/or NOT using bird curtain) and night set not checked off. Go to http://aa.usno.navy.mil/data/docs/ |
TOC |
| BIRDMIT-SHALWEIGHT001 |
!! ENFORCEMENT ISSUE: Fishing occurred on a side-setting shallow set trip and the weight was not the minimum 45g. |
TOC |
| BIRDMIT-SHALWEIGHT002 |
!! ENFORCEMENT ISSUE: Fishing occurred on a side-setting (setting from side and using bird curtain) shallow set trip and the weight was not the minimum 45g. |
TOC |
| BIRDMIT-SHALWTDDRPLN001 |
!! ENFORCEMENT ISSUE: Side-setting shallow set trip and the drop line was not weighted. |
TOC |
| BIRDMIT-SHALWTDDRPLN002 |
!! ENFORCEMENT ISSUE: Side-setting (setting from side and using bird curtain) shallow set trip and the drop line was not weighted. |
TOC |
| BIRDMIT-SHOOTER001 |
Deep set trip and vessel did not use a line shooter. |
TOC |
| BIRDMIT-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (BIRD MITIG table) |
TOC |
| BIRDMIT-TABVERS002 |
TAB_VERS_ID is not in the LOPADM_TAB_VERS table |
TOC |
| BIRDMIT-WAKE001 |
WARNING: Bait was not set outside wake |
TOC |
| CAT-APPRXLEN001 |
APPROX_LEN (fish's approximate length) is less than 1 |
TOC |
| CAT-APPRXLEN002 |
APPROX_LEN (fish's approximate length) exceeds database maximum |
TOC |
| CAT-ASPGNUM001 |
PG_NUM is greater than 25 |
TOC |
| CAT-CAUGHT001 |
Fish species caught condition code cannot be I or U |
TOC |
| CAT-CAUGHT002 |
Animal was dead when caught but was released alive |
TOC |
| CAT-COLLFRMV001 |
COLLECT_FORM_VERS is blank (CATCH form) |
TOC |
| CAT-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (CATCH form) |
TOC |
| CAT-COMMENT001 |
COMMENTS_YN is blank |
TOC |
| CAT-COMMENT002 |
COMMENTS_YN is not Y or N |
TOC |
| CAT-DAMAGE002 |
DAMAGE_ID is not valid |
TOC |
| CAT-FEMALESHARK001 |
Female shark has a clasper length |
TOC |
| CAT-FLTNUM001 |
Float number (FLOAT_NUM) is zero |
TOC |
| CAT-FLTNUM003 |
FLOAT_NUM (float number) exceeds database maximum |
TOC |
| CAT-FLTNUM004 |
FLOAT_NUM (float number) is greater than the number of floats for this set |
TOC |
| CAT-GENDER001 |
GENDER_ID is blank |
TOC |
| CAT-GENDER002 |
GENDER_ID is not valid |
TOC |
| CAT-HIPGNUM001 |
PG_NUM is greater than 12 |
TOC |
| CAT-HISWDFSHKEPT001 |
!!!ENFORCEMENT ISSUE: Deep set trip but more than 10 swordfish were kept for entire trip. |
TOC |
| CAT-HKNUM001 |
HK_NUM (hook number) is zero |
TOC |
| CAT-HKNUM003 |
HK_NUM (hook number) exceeds database norm |
TOC |
| CAT-KEPT002 |
Protected species was returned ALIVE |
TOC |
| CAT-KEPT003 |
A blue shark was KEPT |
TOC |
| CAT-KEPT004 |
Warning: A lancetfish was KEPT |
TOC |
| CAT-LNNUM001 |
LN_NUM (line number) is blank |
TOC |
| CAT-LNNUM002 |
LN_NUM (line number) is greater than 15 |
TOC |
| CAT-MEAS020 |
Swordfish CLEITHRUM_KEEL measurement is out of average range |
TOC |
| CAT-MEAS021 |
Marlin CLEITHRUM_KEEL measurement is out of average range |
TOC |
| CAT-MEAS022 |
Shortbill Spearfish CLEITHRUM_KEEL measurement is out of average range |
TOC |
| CAT-MEAS023 |
Skipjack Tuna FORK_LEN is less than 40 or greater than 100 |
TOC |
| CAT-MEAS024 |
Albacore Tuna FORK_LEN is less than 50 or greater than 130 |
TOC |
| CAT-MEAS025 |
EYE_FORK is smaller than CLEITHRUM_KEEL |
TOC |
| CAT-MEAS026 |
EYE_FORK is smaller than HALF_GIRTH |
TOC |
| CAT-MEAS027 |
CLEITHRUM_KEEL is smaller than HALF_GIRTH |
TOC |
| CAT-MEAS030 |
TOTAL_LEN for shark is outside database range |
TOC |
| CAT-MEAS031 |
FORK_LEN for shark is outside database range |
TOC |
| CAT-MEAS032 |
ALTERNATE_LEN for shark is outside database range |
TOC |
| CAT-MEAS033 |
CLASPER_INNER_LEN for shark is less than 1 |
TOC |
| CAT-MEAS034 |
FORK_LEN for tuna is outside normal range |
TOC |
| CAT-MEAS035 |
EYE_FORK for billfish is outside database range |
TOC |
| CAT-MEAS036 |
CLEITHRUM_KEEL for billfish is outside database range |
TOC |
| CAT-MEAS037 |
HALF_GIRTH for billfish is outside database range |
TOC |
| CAT-MEAS038 |
CLASPER_INNER_LEN for shark is greater than the current database maximum |
TOC |
| CAT-MEAS1001 |
Measurement #1 is blank but the measurement type is not blank |
TOC |
| CAT-MEAS1TYP001 |
Measurement type is blank but Measurement #1 is filled in |
TOC |
| CAT-MEAS2001 |
Measurement #2 is blank but the measurement type is not blank |
TOC |
| CAT-MEAS2TYP001 |
Measurement type is blank but Measurement #2 is filled in |
TOC |
| CAT-MEAS3001 |
Measurement #3 is blank but the measurement type is not blank |
TOC |
| CAT-MEAS3TYP001 |
Measurement type is blank but Measurement #3 is filled in |
TOC |
| CAT-MEAS4001 |
Measurement #4 is blank but the measurement type is not blank |
TOC |
| CAT-MEAS4TYP001 |
Measurement type is blank but Measurement #4 is filled in |
TOC |
| CAT-PGNUM001 |
Page number (PG_NUM) is blank |
TOC |
| CAT-PGNUM002 |
PG_NUM is greater than 12 |
TOC |
| CAT-PHOTO001 |
PHOTO_YN is blank |
TOC |
| CAT-PHOTO002 |
PHOTO_YN is not Y or N |
TOC |
| CAT-PROTSPECKEPT001 |
!!ENFORCEMENT ISSUE: A protected species was kept (kept_return_code = K). |
TOC |
| CAT-SKETCH001 |
SKETCH_YN is blank |
TOC |
| CAT-SKETCH002 |
SKETCH_YN is not Y or N |
TOC |
| CAT-SPECIES001 |
SPECIES_CODE is missing |
TOC |
| CAT-SPECIES002 |
SPECIES_CODE is not a valid LODS species code |
TOC |
| CAT-SPECIES003 |
!! ENFORCEMENT ISSUE: Short-tailed albatross caught |
TOC |
| CAT-SPECIMEN001 |
SPECIMEN_YN is blank |
TOC |
| CAT-SPECIMEN002 |
SPECIMEN_YN is not Y or N |
TOC |
| CAT-SPECIMEN004 |
A specimen was collected by the observer but disposition was recorded as kept. Verify that this is correct. Disposition should be what crew would have done if not collected as specimen by the observer |
TOC |
| CAT-SWDFSHKEPT001 |
!!!ENFORCEMENT ISSUE: Deep set trip but more than 10 swordfish were kept for entire trip. |
TOC |
| CAT-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (CATCH table) |
TOC |
| CAT-TABVERS002 |
TAB_VERS_ID is not in the LOPADM_TAB_VERS table |
TOC |
| CAT-TAG001 |
TAG_YN is blank |
TOC |
| CAT-TAG002 |
TAG_YN is not Y or N |
TOC |
| CAT-UNKNOWNSHARK001 |
Shark has 'unknown' gender but clasper length |
TOC |
| GEAR-ASHKSPFLT001 |
Hooks per float (HKS_PER_FLT) is greater than 40 |
TOC |
| GEAR-BAIT001 |
Bait id (BAIT_ID) is blank |
TOC |
| GEAR-BAIT002 |
Bait id (BAIT_ID) is not valid |
TOC |
| GEAR-BAIT003 |
Bait id (BAIT_ID) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-BAIT004 |
!!! ENFORCEMENT ISSUE: Shallow set trip type declared but no mackerel type bait used |
TOC |
| GEAR-BAIT005 |
!!! POSSIBLE ENFORCEMENT ISSUE: Shallow set trip type declared and other bait type used. If other bait not mackerel type then enforcement issue. |
TOC |
| GEAR-BRCLR001 |
Color of the branchline (BRNCHLN_COLOR_ID) is blank |
TOC |
| GEAR-BRCLR002 |
Color of the branchline (BRNCHLN_COLOR_ID) is not valid |
TOC |
| GEAR-BRCLR003 |
Color of the branchline (BRNCHLN_COLOR_ID) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-BRMAT001 |
Branchline material (BRNCHLN_MAT_ID) is blank |
TOC |
| GEAR-BRMAT002 |
Branchline material (BRNCHLN_MAT_ID) is not valid |
TOC |
| GEAR-BRMAT003 |
Branchline material (BRNCHLN_MAT_ID) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-BRNCHLNDIAM001 |
Branchline diameter (BRNCHLN_DIAM) is blank |
TOC |
| GEAR-BRNCHLNDIAM002 |
Branchline diameter (BRNCHLN_DIAM) is outside database range |
TOC |
| GEAR-BRNCHLNDIAM003 |
Branchline diameter (BRNCHLN_DIAM) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-BRNCHLNLEN001 |
Branchline length (BRNCHLN_LEN) is blank |
TOC |
| GEAR-BRNCHLNLEN002 |
Branchline length (BRNCHLN_LEN) is outside database range |
TOC |
| GEAR-BRNCHLNLEN003 |
Branchline length (BRNCHLN_LEN) changed during the trip (the change may not have occurred on this set) |
TOC |
| GEAR-BRNCHLNTST001 |
Branchline test pounds (BRNCHLN_TST_LBS) is blank |
TOC |
| GEAR-BRNCHLNTST002 |
Branchline test pounds (BRNCHLN_TST_LBS) is outside database range |
TOC |
| GEAR-BRNCHLNTST003 |
Branchline test pounds (BRNCHLN_TST_LBS) is outside database range |
TOC |
| GEAR-BRSTRAND001 |
Number of strands in branchline (BRNCHLN_NUM_STRANDS) is blank |
TOC |
| GEAR-BRSTRAND002 |
Number of strands in branchline (BRNCHLN_NUM_STRANDS) is outside database range |
TOC |
| GEAR-BRSTRAND003 |
Number of strands in branchline (BRNCHLN_NUM_STRANDS) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-COLLFRMV001 |
COLLECT_FORM_VERS is blank (GEAR form) |
TOC |
| GEAR-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (GEAR form) |
TOC |
| GEAR-DROPWT001 |
!! ENFORCEMENT ISSUE: Fishing occurred above 23.0 degrees N and no weight was used. |
TOC |
| GEAR-DROPWT002 |
DROP_WT_SZ (dropper weight size) is outside database normal range |
TOC |
| GEAR-DROPWT003 |
DROP_WT_SZ (dropper weight size) changed during the trip (the change may not have occurred during this set) |
TOC |
| GEAR-DROPWT004 |
!! ENFORCEMENT ISSUE: Fishing occurred above 23.0 degrees N and the weight was not the minimum 45g. |
TOC |
| GEAR-DROPWT005 |
!! ENFORCEMENT ISSUE: Deep set trip and fishing occurred above 23.0 degrees N and no weight was used. |
TOC |
| GEAR-DROPWT006 |
!! ENFORCEMENT ISSUE: Deep set trip and fishing occurred above 23.0 degrees N and the weight was not the minimum 45g. |
TOC |
| GEAR-FLT001 |
The number of floats is less than normal |
TOC |
| GEAR-FLT002 |
With TUNA as the target species, the number of floats exceeds the normal range |
TOC |
| GEAR-FLT003 |
With SWORDFISH as the target species, the number of floats exceeds the normal range |
TOC |
| GEAR-FLTLNDIAM001 |
Floatline diameter (FLTLN_DIAM) is blank |
TOC |
| GEAR-FLTLNDIAM002 |
WARNING: FLTLN_DIAM (floatline diameter) is outside database range |
TOC |
| GEAR-FLTLNLEN001 |
Floatline length (FLTLN_LEN) is blank |
TOC |
| GEAR-FLTLNLEN002 |
!! ENFORCEMENT ISSUE: FLOATLINE LENGTH is less than 20 meters |
TOC |
| GEAR-FLTLNLEN003 |
Floatline length (FLTLN_LEN) is outside the database range for this field |
TOC |
| GEAR-FLTLNLEN004 |
!! ENFORCEMENT ISSUE: Deep set trip and FLOATLINE LENGTH is less than 20 meters |
TOC |
| GEAR-FLTLNMAT001 |
Floatline material id (FLTLN_MAT_ID) is blank |
TOC |
| GEAR-FLTLNMAT002 |
Floatline material id (FLTLN_MAT_ID) is blank |
TOC |
| GEAR-HIFLTLNLEN001 |
!! ENFORCEMENT ISSUE: Deep set trip and FLOATLINE LENGTH is less than 20 meters |
TOC |
| GEAR-HIHKSPFLT001 |
!! ENFORCEMENT ISSUE: Deep set trip and hooks per float (HKS_PER_FLT) is less than 15 |
TOC |
| GEAR-HILSTIK001 |
!!!ENFORCEMENT ISSUE: Deep set trip and light devices were used on this set |
TOC |
| GEAR-HKSHAUL002 |
NUM_HKS_HAULED (number of hooks hauled) is outside normal database range or is zero |
TOC |
| GEAR-HKSHAUL003 |
Number of hooks hauled (NUM_HKS_HAULED) is larger than the number of hooks set (NUM_HKS_SET) |
TOC |
| GEAR-HKSPFLT001 |
Hooks per float (HKS_PER_FLT) is blank |
TOC |
| GEAR-HKSPFLT002 |
!! ENFORCEMENT ISSUE: Hooks per float (HKS_PER_FLT) is less than 15 |
TOC |
| GEAR-HKSPFLT003 |
Hooks per float (HKS_PER_FLT) is greater than 35 |
TOC |
| GEAR-HKSPFLT004 |
!! ENFORCEMENT ISSUE: Deep set trip and hooks per float (HKS_PER_FLT) is less than 15 |
TOC |
| GEAR-HKSSET001 |
Number of hooks set is identical to "hooks per float" multiplied by the "number of floats". Verify method that was used to derive number of hooks set. |
TOC |
| GEAR-HKSSET002 |
Number of hooks set is identical to "hooks per float" multiplied by the "number of floats minus 1". Verify method that was used to derive number of hooks set. |
TOC |
| GEAR-HKSSET003 |
Number of hooks set is identical to "hooks per float" multiplied by the "number of floats minus 2". Verify method that was used to derive number of hooks set. |
TOC |
| GEAR-HKSSET004 |
Number of hooks set is identical to "hooks per float" multiplied by the "number of floats minus 3". Verify method that was used to derive number of hooks set. |
TOC |
| GEAR-HKSSET005 |
Number of hooks set is identical to "hooks per float" multiplied by the "number of floats minus 4". Verify method that was used to derive number of hooks set. |
TOC |
| GEAR-HKSSET006 |
Number of hooks set is identical to "hooks per float" multiplied by the "number of floats minus 5". Verify method that was used to derive number of hooks set. |
TOC |
| GEAR-HKSSET007 |
Number of hooks set is identical to "hooks per float" multiplied by the "number of floats minus 6". Verify method that was used to derive number of hooks set. |
TOC |
| GEAR-HKSZ001 |
HOOK SIZE (SZ_HKS) is blank |
TOC |
| GEAR-HKSZ002 |
HOOK SIZE (SZ_HKS) is outside current database range |
TOC |
| GEAR-HKSZ003 |
ENFORCEMENT ISSUE: Shallow set trip and hook size (sz_hks) for circle hooks was not at least 18. |
TOC |
| GEAR-HKTYP001 |
Hook type id (HK_TYPE_ID) is blank |
TOC |
| GEAR-HKTYP002 |
Hook type id (HK_TYPE_ID) is not valid |
TOC |
| GEAR-HKTYP003 |
Hook type id (HK_TYPE_ID) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-HKTYP004 |
ENFORCEMENT ISSUE: Shallow set trip and hook type (HK_TYPE) used was not Circle Hook. |
TOC |
| GEAR-LDRDIAM001 |
LDR_DIAM (leader diameter) is blank |
TOC |
| GEAR-LDRDIAM002 |
WARNING: LDR_DIAM (leader diameter) is outside database range |
TOC |
| GEAR-LDRDIAM003 |
Leader diameter (LDR_DIAM) changed during the trip (in at least one of the sets) |
TOC |
| GEAR-LDRLEN001 |
LDR_LEN (leader length) is blank |
TOC |
| GEAR-LDRLEN002 |
LDR_LEN (leader length) is outside database range |
TOC |
| GEAR-LDRLEN003 |
LDR_LEN (leader length) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-LDRLEN004 |
!! ENFORCEMENT ISSUE: Deep set trip and fishing occurred above 23.0 degrees N and the weight was not within 1m of the hook. |
TOC |
| GEAR-LDRMAT001 |
Leader material (LDR_MAT_ID) is blank |
TOC |
| GEAR-LDRMAT002 |
WARNING: LDR_MAT_ID (leader material ID) was not an ID in the LOP_LDR_MAT table |
TOC |
| GEAR-LDRMAT003 |
Leader material (LDR_MAT_ID) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-LDRTST001 |
LDR_TST_LBS is blank |
TOC |
| GEAR-LDRTST002 |
LDR_TST_LBS is outside database normal range |
TOC |
| GEAR-LDRTST003 |
LDR_TST_LBS changed during the trip (the change may not have occurred during this set) |
TOC |
| GEAR-LLHKSPFLT001 |
Hooks per float (HKS_PER_FLT) is greater than 35 |
TOC |
| GEAR-LSTIK001 |
Light devices were used on this set |
TOC |
| GEAR-LSTIK002 |
A light device color was recorded on this set |
TOC |
| GEAR-LSTIK003 |
A light device was used but no color was recorded |
TOC |
| GEAR-LSTIK004 |
A light device color was recorded but no light device was used |
TOC |
| GEAR-LSTIK005 |
!!!ENFORCEMENT ISSUE: Deep set trip and light devices were used on this set |
TOC |
| GEAR-MAINLNTST001 |
WARNING: MAINLN_TST_LBS (mainline test pounds) is outside database range |
TOC |
| GEAR-MLNCOLOR001 |
Mainline color id (MAINLN_COLOR_ID) is blank |
TOC |
| GEAR-MLNCOLOR002 |
WARNING: MAINLN_COLOR_ID was not an ID in the LOP_COLOR table |
TOC |
| GEAR-MLNCOLOR003 |
Mainline color id (MAINLN_COLOR_ID) changed during the trip (the change may not have occurred during this set) |
TOC |
| GEAR-MLNDIAM001 |
MAINLN_DIAM (mainline diameter) is blank |
TOC |
| GEAR-MLNDIAM002 |
MAINLN_DIAM (mainline diameter) is outside database range |
TOC |
| GEAR-MLNDIAM003 |
Mainline diameter (MAINLN_DIAM) changed during the trip (the change may not have occurred on this set) |
TOC |
| GEAR-MLNLEN001 |
MAINLN_LEN_RPTD (mainline length) is blank |
TOC |
| GEAR-MLNLEN002 |
MAINLN_LEN_RPTD (mainline length) falls outside current database values |
TOC |
| GEAR-MLNMAT001 |
MAINLN_MAT_ID (mainline material id) is blank |
TOC |
| GEAR-MLNMAT002 |
MAINLN_MAT_ID (mainline material id) was not found in LOP_LINE_MAT table |
TOC |
| GEAR-MLNMAT003 |
Mainline material (MAINLN_MAT_ID) changed during the trip (the change may nothave occurred in this set) |
TOC |
| GEAR-MLNSTRAND001 |
Mainline number of strands (MAINLN_NUM_STRANDS) is blank |
TOC |
| GEAR-MLNSTRAND002 |
Mainline number of strands (MAINLN_NUM_STRANDS) is outside database range of values |
TOC |
| GEAR-MLNSTRAND003 |
Mainline number of strands (MAINLN_NUM_STRANDS) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-MLNTST001 |
MAINLN_TST_LBS (mainline test) is blank |
TOC |
| GEAR-MLNTST002 |
MAINLN_TST_LBS (mainline test) is outside database range |
TOC |
| GEAR-MLNTST003 |
MAINLN_TST_LBS (mainline test) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-MNSTRAND001 |
Number of strands in mainline (MAINLN_NUM_STRANDS) is outside database range |
TOC |
| GEAR-SHTRSPD001 |
SHOOTER SPEED is outside current database range |
TOC |
| GEAR-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (GEAR_CFG table) |
TOC |
| GEAR-TABVERS002 |
TAB_VERS_ID is not in the LOPADM_TAB_VERS table |
TOC |
| GEAR-TARGDEPTH001 |
!! ENFORCEMENT ISSUE: Target_depth (TARGET_DEPTH_RPTD) is blank |
TOC |
| GEAR-TARGDEPTH002 |
!! ENFORCEMENT ISSUE: Target depth (TARGET_DEPTH_RPTD) is less than 100 meters |
TOC |
| GEAR-TARGDEPTH003 |
Target_depth (TARGET_DEPTH_RPTD) changed during the trip (the change may not have occurred in this set) |
TOC |
| GEAR-TARGDEPTH004 |
Target_depth (TARGET_DEPTH_RPTD) is outside database norm values |
TOC |
| GEAR-TARGSPEC001 |
Target species (TARGET_SPECIES_CODE) is blank |
TOC |
| GEAR-TARGSPEC002 |
Target species (TARGET_SPECIES_CODE) is not a valid species code |
TOC |
| GEAR-TARGSPEC003 |
Target species (TARGET_SPECIES_CODE) changed during the trip |
TOC |
| GEAR-VESSSPD001 |
VESSEL SPEED is slower than 5 knots or faster than 10 knots |
TOC |
| IMAG-ASSET001 |
The set number (SET_NUM) may be out of range (not between 1 and 75) |
TOC |
| IMAG-FORM001 |
The FORM_TYPE_ID is not valid |
TOC |
| IMAG-HISET001 |
The set number (SET_NUM) may be out of range (not between 1 and 40) |
TOC |
| IMAG-SET001 |
The set number (SET_NUM) exceeds current database range |
TOC |
| IMAG-SKETCHYN001 |
The column SKETCH_YN is blank (IMAGES table) |
TOC |
| IMAG-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (IMAGES table) |
TOC |
| IMAG-TABVERS002 |
TAB_VERS_ID is not in the LOPADM_TAB_VERS table |
TOC |
| MAM-ASCAPLATDIR001 |
Captured latitude (captured_lat) is in the northern hemisphere. |
TOC |
| MAM-ASRELLATDIR001 |
Released latitude (released_lat) is in the northern hemisphere. |
TOC |
| MAM-CAPLATDIR001 |
Captured latitude (captured_lat) is in the southern hemisphere. |
TOC |
| MAM-CAPLONDIR001 |
Captured longitude (captured_lon) is in the eastern hemisphere. |
TOC |
| MAM-CAPREL001 |
Release date/time cannot occur before capture date/time |
TOC |
| MAM-CAPTUREDT001 |
CAPTURED DATETIME is not between departure and arrival dates |
TOC |
| MAM-CAPTUREDT002 |
WARNING: The CAPTURED_DATETIME is not within a day of the RELEASED_DATETIME |
TOC |
| MAM-CAPTUREDT003 |
WARNING: The CAPTURED_DATETIME is after the RELEASED_DATETIME |
TOC |
| MAM-COLLFRMV001 |
COLLECT_FORM_VERS is blank (MAMMALS form) |
TOC |
| MAM-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (MAMMALS form) |
TOC |
| MAM-DISP001 |
ENFORCEMENT ISSUE!!! Marine Mammal was treated as catch (kept) |
TOC |
| MAM-DISPOSID001 |
DISPOSITION_ID for this mammal is blank |
TOC |
| MAM-DISPOSID002 |
DISPOSITION_ID is not present in the LOP_ANIMAL_DISPOSITION table |
TOC |
| MAM-ENTANG001 |
ENTANGLED_YNU is not Y, N or U |
TOC |
| MAM-ENTANGLOC001 |
ENTANGLED_LOC_ID is not present in the LOP_ENTANGLED_LOC table |
TOC |
| MAM-GRATTCH001 |
GEAR_ATTACHED_TYPE_ID is not present in the LOP_GEAR_ATTACHED_TYPE table |
TOC |
| MAM-GRRMVL001 |
GEAR_REMVL_TYPE_ID is not present in the LOP_GEAR_REMVL_TYPE table |
TOC |
| MAM-HICAPLATDIR001 |
Captured latitude (captured_lat) is in the southern hemisphere. |
TOC |
| MAM-HICAPLONDIR001 |
Captured longitude (captured_lon) is in the eastern hemisphere. |
TOC |
| MAM-HIRELLATDIR001 |
Released latitude (released_lat) is in the southern hemisphere. |
TOC |
| MAM-HIRELLONDIR001 |
Released longitude (released_lon) is in the eastern hemisphere. |
TOC |
| MAM-HKD001 |
HOOKED_YNU is not Y, N or U |
TOC |
| MAM-HKDLOC001 |
HOOKED_LOC_ID is not present in the LOP_HOOKED_LOC table |
TOC |
| MAM-LANDED001 |
LANDED_YN is not Y or N |
TOC |
| MAM-LTDVCCLR001 |
LITE_DEVICE_COLOR_ID is not present in the LOP_COLOR table |
TOC |
| MAM-LTDVCPROX001 |
LITE_DEVICE_PROX_ID is not present in the LOP_LITE_DEVICE_PROX table |
TOC |
| MAM-RELLATDIR001 |
Released latitude (released_lat) is in the southern hemisphere. |
TOC |
| MAM-RELLONDIR001 |
Released longitude (released_lon) is in the eastern hemisphere. |
TOC |
| MAM-RLSDDT001 |
RELEASED DATETIME is not between departure and arrival dates |
TOC |
| MAM-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (MAMMALS table) |
TOC |
| MAM-TABVERS002 |
TAB_VERS_ID is not in the LOPADM_TAB_VERS table |
TOC |
| PORT-RESUMEDT001 |
RESUME_DATETIME is not between the DEPART_DATETIME and the ARRIVAL_DATETIME |
TOC |
| PORT-STOPDT001 |
STOP_DATETIME is not between the DEPART_DATETIME and the ARRIVAL_DATETIME |
TOC |
| PORT-STOPDT002 |
STOP_DATETIME is after the RESUME_DATETIME |
TOC |
| PORT-STOPNUM001 |
STOP_NUM is blank |
TOC |
| PORT-STOPNUM002 |
The STOP_NUM is greater than 5 |
TOC |
| PORT-STOPPORT001 |
STOP PORT is blank |
TOC |
| PORT-STOPPORT002 |
STOP PORT is not uppercase |
TOC |
| PORT-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (PORT_STOPS table) |
TOC |
| PORT-TABVERS002 |
The TAB_VERS_ID was not found in the LOPADM_TAB_VERS table (the table version id does not exist) |
TOC |
| PSI-ASLATDIR001 |
Latitude (event_lat) is in the northern hemisphere. |
TOC |
| PSI-ASSOCFRMTYP001 |
EVENT_TYPE is X and ASSOC_FORM_TYPE is blank |
TOC |
| PSI-ASSOCLN001 |
EVENT_TYPE is X and ASSOC_LN_NUM is blank |
TOC |
| PSI-ASSOCPG001 |
EVENT_TYPE is X and ASSOC_PG_NUM is blank |
TOC |
| PSI-ASSOCPG002 |
The combination ASSOC_PG_NUM/ASSOC_LN_NUM is not an existing pg/ln on this form |
TOC |
| PSI-BEHAV001 |
BEHAVIOR_TYPE_ID is blank |
TOC |
| PSI-BEHAV002 |
BEHAVIOR_TYPE_ID is not valid |
TOC |
| PSI-BEHAV003 |
BEHAVIOR_TYPE_ID is blank |
TOC |
| PSI-BEHAV004 |
A seabird other than dAL is recorded with an event type code of 'B'. If this is a seabird sighting, i.e., seabird flying around, outside of a scan it should not be recorded. If this is a seabird conta |
TOC |
| PSI-COLLFRMV001 |
COLLECT_FORM_VERS is blank (PSI form) |
TOC |
| PSI-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (PS INTERACT form) |
TOC |
| PSI-COND001 |
PSI CONDITION_ID is blank |
TOC |
| PSI-COND002 |
PSI CONDITION_ID is not valid |
TOC |
| PSI-COND003 |
PSI CONDITION_ID is blank |
TOC |
| PSI-DISTGR001 |
DIST_TO_GEAR_M is zero |
TOC |
| PSI-ESTIM001 |
HIGH_ESTIM is less than BEST_ESTIM |
TOC |
| PSI-ESTIM002 |
BEST_ESTIM is less than LOW_ESTIM |
TOC |
| PSI-ESTIM003 |
HIGH_ESTIM is less than LOW_ESTIM |
TOC |
| PSI-ESTIM004 |
HIGH_ESTIM is outside database range |
TOC |
| PSI-ESTIM005 |
BEST_ESTIM is outside database range |
TOC |
| PSI-ESTIM006 |
LOW_ESTIM is outside database range |
TOC |
| PSI-ESTIM007 |
HIGH_ESTIM is blank |
TOC |
| PSI-ESTIM008 |
BEST_ESTIM is blank |
TOC |
| PSI-ESTIM009 |
LOW_ESTIM is blank |
TOC |
| PSI-ESTIM010 |
HIGH_ESTIM is outside database range |
TOC |
| PSI-ESTIM011 |
BEST_ESTIM is outside database range |
TOC |
| PSI-ESTIM012 |
LOW_ESTIM is outside database range |
TOC |
| PSI-EVDT001 |
EVENT_DATETIME is blank |
TOC |
| PSI-EVDT002 |
EVENT_BEGIN_DATETIME is later than EVENT_END_DATETIME |
TOC |
| PSI-EVDT003 |
EVENT_DATETIME is not within the trip departure and arrival dates |
TOC |
| PSI-EVNUM001 |
EVENT_NUM is blank |
TOC |
| PSI-EVNUM002 |
EVENT_NUM cannot be zero |
TOC |
| PSI-EVNUM003 |
EVENT_NUM larger than usual (over 20) |
TOC |
| PSI-EVTYP001 |
EVENT_TYPE_ID is blank |
TOC |
| PSI-EVTYP002 |
EVENT_TYPE_ID is not valid |
TOC |
| PSI-GRPINDIV001 |
GRP_INDIV_IDENTITY is blank |
TOC |
| PSI-GRPINDIV002 |
GRP_INDIV_IDENTITY is blank |
TOC |
| PSI-HAULSCANTIME001 |
The begin haul scan was performed prior to the begin haul time. |
TOC |
| PSI-HAULSCANTIME002 |
The end haul scan was performed after the end haul time. |
TOC |
| PSI-HILATDIR001 |
Latitude (event_lat) is in the southern hemisphere. |
TOC |
| PSI-HILONDIR001 |
Longitude (event_lon) is in the eastern hemisphere. |
TOC |
| PSI-LATDIR001 |
Latitude (event_lat) is in the southern hemisphere. |
TOC |
| PSI-LONDIR001 |
Longitude (event_lon) is in the eastern hemisphere. |
TOC |
| PSI-SETNUM001 |
SET_NUM does not exist for this trip |
TOC |
| PSI-SETNUM002 |
The set number (SET_NUM) is blank |
TOC |
| PSI-SETSCANTIME001 |
The begin set scan was performed prior to the begin set time. |
TOC |
| PSI-SETSCANTIME002 |
The end set scan was performed after the end set time. |
TOC |
| PSI-SGHTMETH001 |
SIGHTING_METHOD_ID is blank |
TOC |
| PSI-SGHTMETH002 |
SIGHTING_METHOD_ID is not valid |
TOC |
| PSI-SGHTMETH003 |
SIGHTING_METHOD_ID is blank |
TOC |
| PSI-SPECIES001 |
SPECIES_CODE is blank |
TOC |
| PSI-SPECIES002 |
Short-tailed albatross (dAL) observed |
TOC |
| PSI-SPECIES003 |
SPECIES_CODE is blank |
TOC |
| PSI-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (PS_INTERACT table) |
TOC |
| PSI-TABVERS002 |
TAB_VERS_ID is not in the LOPADM_TAB_VERS table |
TOC |
| PSI-VESSACT001 |
VESS_ACTIVITY_ID is blank |
TOC |
| PSI-VESSACT002 |
VESS_ACTIVITY_ID is not valid |
TOC |
| PSI-WEATH001 |
WEATHER_TYPE_ID is blank |
TOC |
| PSI-WEATH002 |
WEATHER_TYPE_ID is not valid |
TOC |
| SETENV-ASBHLATDIR001 |
Begin haul latitude (HAUL_BEGIN_LAT) is in the northern hemisphere. |
TOC |
| SETENV-ASBSLATDIR001 |
Begin set latitude (SET_BEGIN_LAT) is in the northern hemisphere. |
TOC |
| SETENV-ASEHBEAUF001 |
The Beaufort code (HAUL_END_BEAUF) is blank |
TOC |
| SETENV-ASEHLATDIR001 |
End haul latitude (HAUL_END_LAT) is in the northern hemisphere. |
TOC |
| SETENV-ASESBEAUF001 |
The Beaufort code (SET_END_BEAUF) is blank |
TOC |
| SETENV-ASESLATDIR001 |
End set latitude (SET_END_LAT) is in the northern hemisphere. |
TOC |
| SETENV-ASSETNUM001 |
The set number (SET_NUM) may be out of range (not between 1 and 75) |
TOC |
| SETENV-BEAUF001 |
SET_BEGIN_BEAUFORT is NOT BETWEEN 0 AND 10 |
TOC |
| SETENV-BEAUF002 |
WARNING: SET_END_BEAUFORT is NOT BETWEEN 0 AND 10 |
TOC |
| SETENV-BEAUF003 |
HAUL_BEGIN_BEAUFORT is NOT BETWEEN 0 AND 10 |
TOC |
| SETENV-BEAUF004 |
HAUL_END_BEAUFORT is NOT BETWEEN 0 AND 10 |
TOC |
| SETENV-BEAUF005 |
The Beaufort code (SET_BEGIN_BEAUF) is blank |
TOC |
| SETENV-BEAUF006 |
The Beaufort code (SET_END_BEAUF) is blank |
TOC |
| SETENV-BEAUF007 |
The Beaufort code (HAUL_BEGIN_BEAUF) is blank |
TOC |
| SETENV-BEAUF008 |
The Beaufort code (HAUL_END_BEAUF) is blank |
TOC |
| SETENV-BHEHLAT001 |
WARNING: Begin haul latitude (HAUL_BEGIN_LAT) vs end haul latitude (HAUL_END_LAT) distance is greater than 40 nautical miles. Please very that it is correct. |
TOC |
| SETENV-BHEHLON001 |
WARNING: Begin haul longitude (HAUL_BEGIN_LON) vs end haul longitude (HAUL_END_LON) distance is greater than 40 nautical miles. Please very that it is correct. |
TOC |
| SETENV-BHLATDIR001 |
Begin haul latitude (HAUL_BEGIN_LAT) is in the southern hemisphere. |
TOC |
| SETENV-BHLONDIR001 |
Begin haul longitude (HAUL_BEGIN_LON) is in the eastern hemisphere. |
TOC |
| SETENV-BSBHLAT001 |
Begin set latitude (SET_BEGIN_LAT) vs begin haul latitude (HAUL_BEGIN_LAT) drift is greater than 20 nautical miles. |
TOC |
| SETENV-BSBHLON001 |
Begin set longitude (SET_BEGIN_LON) vs begin haul longitude (HAUL_BEGIN_LON) drift is greater than 20 nautical miles. |
TOC |
| SETENV-BSEHLAT001 |
Begin set latitude (SET_BEGIN_LAT) vs end haul latitude (HAUL_END_LAT) drift is greater than 20 nautical miles. |
TOC |
| SETENV-BSEHLON001 |
Begin set longitude (SET_BEGIN_LON) vs end haul longitude (HAUL_END_LON) drift is greater than 20 nautical miles. |
TOC |
| SETENV-BSESLAT001 |
WARNING: Begin set latitude (SET_BEGIN_LAT) vs end set latitude (SET_END_LAT) distance is greater than 40 nautical miles. Please very that it is correct. |
TOC |
| SETENV-BSESLON001 |
WARNING: Begin set longitude (SET_BEGIN_LON) vs end set longitude (SET_END_LON) distance is greater than 40 nautical miles. Please very that it is correct. |
TOC |
| SETENV-BSLATDIR001 |
Begin set latitude (SET_BEGIN_LAT) is in the southern hemisphere. |
TOC |
| SETENV-BSLONDIR001 |
Begin set longitude (SET_BEGIN_LON) is in the eastern hemisphere. |
TOC |
| SETENV-COLLFRMV001 |
COLLECT_FORM_VERS is blank (SET/HAUL form) |
TOC |
| SETENV-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (SET/HAUL form) |
TOC |
| SETENV-DT001 |
HAUL_BEGIN_DATETIME is earlier than SET_BEGIN_DATETIME |
TOC |
| SETENV-DT002 |
HAUL_END_DATETIME is earlier than SET_END_DATETIME |
TOC |
| SETENV-DT003 |
HAUL_BEGIN_DATETIME is earlier than SET_END_DATETIME |
TOC |
| SETENV-DT004 |
SET_END_DATETIME is earlier than SET_BEGIN_DATETIME |
TOC |
| SETENV-DT005 |
HAUL_END_DATETIME is earlier than HAUL_BEGIN_DATETIME |
TOC |
| SETENV-DT006 |
HAUL_END_DATETIME is earlier than SET_BEGIN_DATETIME |
TOC |
| SETENV-DT007 |
The YEAR in SET_BEGIN_DATETIME is not within range (1994 to arrival year) |
TOC |
| SETENV-DT008 |
The YEAR in SET_END_DATETIME is not within range (1994 to arrival year) |
TOC |
| SETENV-DT009 |
The YEAR in HAUL_BEGIN_DATETIME is not within range (1994 to arrival year) |
TOC |
| SETENV-DT010 |
The YEAR in HAUL_END_DATETIME is not within range (1994 to arrival year) |
TOC |
| SETENV-EHLATDIR001 |
End haul latitude (HAUL_END_LAT) is in the southern hemisphere. |
TOC |
| SETENV-EHLONDIR001 |
End haul longitude (HAUL_END_LON) is in the eastern hemisphere. |
TOC |
| SETENV-ESBHLAT001 |
End set latitude (SET_END_LAT) vs begin haul latitude (HAUL_BEGIN_LAT) drift is greater than 20 nautical miles. |
TOC |
| SETENV-ESBHLON001 |
End set longitude (SET_END_LON) vs begin haul longitude (HAUL_BEGIN_LON) drift is greater than 20 nautical miles. |
TOC |
| SETENV-ESEHLAT001 |
End set latitude (SET_END_LAT) vs end haul latitude (HAUL_END_LAT) drift is greater than 20 nautical miles. |
TOC |
| SETENV-ESEHLON001 |
End set longitude (SET_END_LON) vs end haul longitude (HAUL_END_LON) drift is greater than 20 nautical miles. |
TOC |
| SETENV-ESLATDIR001 |
End set latitude (SET_END_LAT) is in the southern hemisphere. |
TOC |
| SETENV-ESLONDIR001 |
End set longitude (SET_END_LON) is in the eastern hemisphere. |
TOC |
| SETENV-HAULBEGDT001 |
HAUL_BEGIN_DATETIME is not between the trip dates |
TOC |
| SETENV-HAULENDDT001 |
HAUL_END_DATETIME falls outside the trip start and end dates |
TOC |
| SETENV-HIBHBEAUF001 |
The Beaufort code (HAUL_BEGIN_BEAUF) is blank |
TOC |
| SETENV-HIBHLATDIR001 |
Begin haul latitude (HAUL_BEGIN_LAT) is in the southern hemisphere. |
TOC |
| SETENV-HIBHLONDIR001 |
Begin haul longitude (HAUL_BEGIN_LON) is in the eastern hemisphere. |
TOC |
| SETENV-HIBSBEAUF001 |
The Beaufort code (SET_BEGIN_BEAUF) is blank |
TOC |
| SETENV-HIBSLATDIR001 |
Begin set latitude (SET_BEGIN_LAT) is in the southern hemisphere. |
TOC |
| SETENV-HIBSLONDIR001 |
Begin set longitude (SET_BEGIN_LON) is in the eastern hemisphere. |
TOC |
| SETENV-HIEHBEAUF001 |
The Beaufort code (HAUL_END_BEAUF) is blank |
TOC |
| SETENV-HIEHLATDIR001 |
End haul latitude (HAUL_END_LAT) is in the southern hemisphere. |
TOC |
| SETENV-HIEHLONDIR001 |
End haul longitude (HAUL_END_LON) is in the eastern hemisphere. |
TOC |
| SETENV-HIESBEAUF001 |
The Beaufort code (SET_END_BEAUF) is blank |
TOC |
| SETENV-HIESLATDIR001 |
End set latitude (SET_END_LAT) is in the southern hemisphere. |
TOC |
| SETENV-HIESLONDIR001 |
End set longitude (SET_END_LON) is in the eastern hemisphere. |
TOC |
| SETENV-HISETNUM001 |
The set number (SET_NUM) may be out of range (not between 1 and 40) |
TOC |
| SETENV-LAT23SUNRISE001 |
!!! POSSIBLE ENFORCEMENT ISSUE: Shallow set declared. Setting operations may not have ended by sunrise. Go to http://aa.usno.navy.mil/data/docs/RS_OneDay.html to make sure set not completed by sunrise |
TOC |
| SETENV-LAT23SUNSET001 |
!!! POSSIBLE ENFORCEMENT ISSUE: Shallow set declared. Set may not have started at least 1 hour after sunset. Go to http://aa.usno.navy.mil/data/docs/RS_OneDay.html to make sure it was not a night set. |
TOC |
| SETENV-LNPART001 |
The line on this set was marked as parted, but the number of sections retrieved is blank |
TOC |
| SETENV-LNPART002 |
WARNING: The line on this set was marked as parted, but only one section was retrieved |
TOC |
| SETENV-LOGBK001 |
Logbook page number (LOGBK_PG_NUM) is blank |
TOC |
| SETENV-LOGBK002 |
Logbook_page_number (LOGBK_PG_NUM) is not uppercase |
TOC |
| SETENV-LOGBK003 |
Logbook_page_number (LOGBK_PG_NUM) already exists in the database (in another trip) |
TOC |
| SETENV-LOGBK004 |
Logbook_page_number (LOGBK_PG_NUM) already exists within this trip |
TOC |
| SETENV-PROTSPEC001 |
A protected species is recorded on the catch but not checked off as a haul interaction on the set and haul. |
TOC |
| SETENV-PROTSPEC002 |
A protected species is recorded on the protected species event log with a contact but not checked off as a haul interaction on the set and haul. |
TOC |
| SETENV-PROTSPEC003 |
A protected species is recorded on the protected species event log with a contact but not checked off as a set interaction on the set and haul. |
TOC |
| SETENV-SECRTRVD001 |
If line parted then number of sections retrieved cannot be 1 |
TOC |
| SETENV-SECRTRVD002 |
Line parted but number of sections retrieved is 1 |
TOC |
| SETENV-SETBEGDT001 |
SET_BEGIN_DATETIME falls outside the trip start and end dates |
TOC |
| SETENV-SETDT001 |
SET_BEGIN_DATETIME is not within a day of the HAUL_BEGIN_DATETIME |
TOC |
| SETENV-SETDT002 |
SET_END_DATETIME is not within a day of the HAUL_END_DATETIME |
TOC |
| SETENV-SETDT003 |
SET_BEGIN_DATETIME for SET #2 is the same or before the SET_BEGIN_DATETIME for Set #1 |
TOC |
| SETENV-SETDT004 |
SET_BEGIN_DATETIME for SET #3 is the same or before the SET_BEGIN_DATETIME for Set #2 |
TOC |
| SETENV-SETDT005 |
SET_BEGIN_DATETIME for SET #4 is the same or before the SET_BEGIN_DATETIME for Set #3 |
TOC |
| SETENV-SETDT006 |
The SET_BEGIN_DATETIME for SET #5 is the same or before the SET_BEGIN_DATETIME for Set #4 |
TOC |
| SETENV-SETDT007 |
SET_BEGIN_DATETIME for SET #6 is the same or before the SET_BEGIN_DATETIME for Set #5 |
TOC |
| SETENV-SETDT008 |
SET_BEGIN_DATETIME for SET #7 is the same or before the SET_BEGIN_DATETIME for Set #6 |
TOC |
| SETENV-SETDT009 |
SET_BEGIN_DATETIME for SET #8 is the same or before the SET_BEGIN_DATETIME for Set #7 |
TOC |
| SETENV-SETDT010 |
SET_BEGIN_DATETIME for SET #9 is the same or before the SET_BEGIN_DATETIME for Set #8 |
TOC |
| SETENV-SETDT011 |
SET_BEGIN_DATETIME for SET #10 is the same or before the SET_BEGIN_DATETIME for Set #9 |
TOC |
| SETENV-SETDT012 |
SET_BEGIN_DATETIME for SET #11 is the same or before the SET_BEGIN_DATETIME for Set #10 |
TOC |
| SETENV-SETDT013 |
SET_BEGIN_DATETIME for SET #12 is the same or before the SET_BEGIN_DATETIME for Set #11 |
TOC |
| SETENV-SETDT014 |
SET_BEGIN_DATETIME for SET #13 is the same or before the SET_BEGIN_DATETIME for Set #12 |
TOC |
| SETENV-SETDT015 |
SET_BEGIN_DATETIME for SET #14 is the same or before the SET_BEGIN_DATETIME for Set #13 |
TOC |
| SETENV-SETDT016 |
SET_BEGIN_DATETIME for SET #15 is the same or before the SET_BEGIN_DATETIME for Set #14 |
TOC |
| SETENV-SETDT017 |
SET_BEGIN_DATETIME for SET #16 is the same or before the SET_BEGIN_DATETIME for Set #15 |
TOC |
| SETENV-SETDT018 |
SET_BEGIN_DATETIME for SET #17 is the same or before the SET_BEGIN_DATETIME for Set #16 |
TOC |
| SETENV-SETDT019 |
SET_BEGIN_DATETIME for SET #18 is the same or before the SET_BEGIN_DATETIME for Set #17 |
TOC |
| SETENV-SETDT020 |
SET_BEGIN_DATETIME for SET #19 is the same or before the SET_BEGIN_DATETIME for Set #18 |
TOC |
| SETENV-SETDT021 |
SET_BEGIN_DATETIME for SET #20 is the same or before the SET_BEGIN_DATETIME for Set #19 |
TOC |
| SETENV-SETDT022 |
SET_BEGIN_DATETIME for SET #21 is the same or before the SET_BEGIN_DATETIME for Set #20 |
TOC |
| SETENV-SETDT023 |
SET_BEGIN_DATETIME for SET #22 is the same or before the SET_BEGIN_DATETIME for Set #21 |
TOC |
| SETENV-SETDT024 |
SET_BEGIN_DATETIME for SET #23 is the same or before the SET_BEGIN_DATETIME for Set #22 |
TOC |
| SETENV-SETDT025 |
SET_BEGIN_DATETIME for SET #24 is the same or before the SET_BEGIN_DATETIME for Set #23 |
TOC |
| SETENV-SETDT026 |
SET_BEGIN_DATETIME for SET #25 is the same or before the SET_BEGIN_DATETIME for Set #24 |
TOC |
| SETENV-SETDT027 |
SET_BEGIN_DATETIME for SET #26 is the same or before the SET_BEGIN_DATETIME for Set #25 |
TOC |
| SETENV-SETDT028 |
SET_BEGIN_DATETIME for SET #27 is the same or before the SET_BEGIN_DATETIME for Set #26 |
TOC |
| SETENV-SETDT029 |
SET_BEGIN_DATETIME for SET #28 is the same or before the SET_BEGIN_DATETIME for Set #27 |
TOC |
| SETENV-SETDT030 |
SET_BEGIN_DATETIME for SET #29 is the same or before the SET_BEGIN_DATETIME for Set #28 |
TOC |
| SETENV-SETDT031 |
SET_BEGIN_DATETIME for SET #30 is the same or before the SET_BEGIN_DATETIME for Set #29 |
TOC |
| SETENV-SETENDDT001 |
SET_END_DATETIME falls outside the trip start and end dates |
TOC |
| SETENV-SETNUM001 |
The set number (SET_NUM) is blank |
TOC |
| SETENV-SETNUM002 |
The set number (SET_NUM) may be out of range (not between 1 and 40) |
TOC |
| SETENV-SHALSUNRISE001 |
!!! POSSIBLE ENFORCEMENT ISSUE: Shallow set trip that was not side-setting. Setting operations may not have ended by sunrise. Go to http://aa.usno.navy.mil/data/docs/RS_OneDay.html to make sure set no |
TOC |
| SETENV-SHALSUNSET001 |
!!! POSSIBLE ENFORCEMENT ISSUE: Shallow set trip that was not side-setting. Set may not have started at least 1 hour after sunset. Go to http://aa.usno.navy.mil/data/docs/RS_OneDay.html to make sure i |
TOC |
| SETENV-SOAK001 |
SOAK_TIME is blank |
TOC |
| SETENV-SOAK002 |
SOAK_TIME outside database normal range |
TOC |
| SETENV-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (SET/HAUL table) |
TOC |
| SETENV-TABVERS002 |
TAB_VERS_ID is not in the LOPADM_TAB_VERS table |
TOC |
| SETENV-TEMP001 |
SET_BEGIN_TEMP may be OUT OF RANGE (not between 55 and 95) |
TOC |
| SETENV-TEMP002 |
SET_END_TEMP may be OUT OF RANGE (not between 55 and 95) |
TOC |
| SETENV-TEMP003 |
HAUL_BEGIN_TEMP may be OUT OF RANGE (not between 55 and 95) |
TOC |
| SETENV-TEMP004 |
HAUL_END_TEMP may be OUT OF RANGE (not between 55 and 95) |
TOC |
| SETENV-TEMP005 |
TEMPERATURE range between SET_BEGIN_TEMP and SET_END_TEMP is more than 5 degrees |
TOC |
| SETENV-TEMP006 |
TEMPERATURE range between SET_END_TEMP and SET_BEGIN_TEMP is more than 5 degrees |
TOC |
| SETENV-TEMP007 |
TEMPERATURE range between HAUL_BEGIN_TEMP and HAUL_END_TEMP is more than 5 degrees |
TOC |
| SETENV-TEMP008 |
TEMPERATURE range between HAUL_END_TEMP and HAUL_BEGIN_TEMP is more than 5 degrees |
TOC |
| SETENV-TEMP009 |
TEMPERATURE range between SET_BEGIN_TEMP and HAUL_BEGIN_TEMP is more than 5 degrees |
TOC |
| SETENV-TEMP010 |
TEMPERATURE range between HAUL_BEGIN_TEMP and SET_BEGIN_TEMP is more than 5 degrees |
TOC |
| SETENV-TEMP011 |
TEMPERATURE range between SET_END_TEMP and HAUL_END_TEMP is more than 5 degrees |
TOC |
| SETENV-TEMP012 |
TEMPERATURE range between HAUL_END_TEMP and SET_END_TEMP is more than 5 degrees |
TOC |
| SETENV-TEMP013 |
SET_BEGIN_TEMP is blank |
TOC |
| SETENV-TEMP014 |
SET_END_TEMP is blank |
TOC |
| SETENV-TEMP015 |
HAUL_BEGIN_TEMP is blank |
TOC |
| SETENV-TEMP016 |
HAUL_END_TEMP is blank |
TOC |
| SHRK-SEX001 |
GENDER is not M, F, or U |
TOC |
| SHRK-SPEC001 |
SPECIES_CODE is not a valid shark species |
TOC |
| SPEC-COLLFRMV001 |
COLLECT_FORM_VERS is blank (SPECIMEN form) |
TOC |
| SPEC-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (SPECIMEN form) |
TOC |
| SPEC-SPCMNTYPID001 |
SPECIMEN_TYPE_ID is missing |
TOC |
| SPEC-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (SPECIMEN table) |
TOC |
| SPEC-TABVERS002 |
The TAB_VERS_ID was not found in the LOPADM_TAB_VERS table (the table version id does not exist) |
TOC |
| TAG-BIRDTAGAPPLD001 |
A tag was applied to a seabird. |
TOC |
| TAG-COLLFRMV001 |
COLLECT_FORM_VERS is blank (TAG_EVENTS form) |
TOC |
| TAG-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (TAG EVENTS form) |
TOC |
| TAG-MAMTAGAPPLD001 |
A tag was applied to a marine mammal. |
TOC |
| TAG-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (TAG_EVENTS table) |
TOC |
| TAG-TABVERS002 |
The TAB_VERS_ID was not found in the LOPADM_TAB_VERS table (the table version id does not exist) |
TOC |
| TEST-001 |
Cleithrum-to-keel length (CLEITH_KEEL_LEN) is outside database range |
TOC |
| TRIP-APPRVBY001 |
TRIP_APPROVAL_STATUS is APPROVED and APPROVED_BY is blank |
TOC |
| TRIP-APPRVDT001 |
APPROVAL_DATETIME IS blank and trip_approval status is APPROVED |
TOC |
| TRIP-APPRVMETH001 |
APPROVAL_METHOD IS blank and trip_approval status is APPROVED |
TOC |
| TRIP-APPRVSTAT001 |
TRIP_APPROVAL_STATUS is blank |
TOC |
| TRIP-APPRVSTAT002 |
TRIP_APPROVAL_STATUS is not uppercase |
TOC |
| TRIP-ARRIVPORT001 |
ARRIVAL_PORT is blank |
TOC |
| TRIP-ARRIVPORT002 |
ARRIVAL_PORT is not uppercase |
TOC |
| TRIP-ARRIVPORT003 |
ARRIVAL_PORT not found as previous arrival port in database |
TOC |
| TRIP-CODEVID001 |
The code version id CODE_VERS_ID is blank |
TOC |
| TRIP-CODEVID002 |
The CODE_VERS_ID was not found in the LOPADM_REFCODE_VERS table |
TOC |
| TRIP-COLLFORM001 |
COLLECT_FORM_VERS is blank (TRIPS form) |
TOC |
| TRIP-COLLFORM002 |
COLLECT_FORM_VERS is not valid (TRIPS form) |
TOC |
| TRIP-DCLTRPTYP001 |
WARNING: The declared trip type needs to be either 'S' for shallow or 'D' for deep. |
TOC |
| TRIP-DEAPPV001 |
DATA_ENTRY_APPLIC_VERS is blank |
TOC |
| TRIP-DEPPORT001 |
DEPART_PORT is blank |
TOC |
| TRIP-DEPPORT002 |
ARRIVAL_PORT or DEPART_PORT is not uppercase |
TOC |
| TRIP-DEPPORT003 |
DEPART_PORT not found as previous departure port in database |
TOC |
| TRIP-DT001 |
DEPART_DATETIME is later than ARRIVAL_DATETIME |
TOC |
| TRIP-DT002 |
ARRIVAL_DATETIME is later than APPROVAL_DATE |
TOC |
| TRIP-DT003 |
Trip length is less than 1 day |
TOC |
| TRIP-OBSMANV001 |
OBSERVER_MANUAL_VERS is blank |
TOC |
| TRIP-OBSNUM001 |
The observer number (O_OBSERVER_NUM) is blank |
TOC |
| TRIP-OBSNUM002 |
The observer number (O_OBSERVER_NUM) does not exist in the personnel table (LOP_PIAO_PERSONS) |
TOC |
| TRIP-OPERFNAM001 |
The operator's first name (OPERATOR_FNAME_MI) is blank |
TOC |
| TRIP-OPERFNAM002 |
OPERATOR_FNAME_MI (operator's first name) is not uppercase |
TOC |
| TRIP-OPERLNAM001 |
The operator's last name (OPERATOR_LNAME) is blank |
TOC |
| TRIP-OPERLNAM002 |
OPERATOR_LNAME (operator's last name) is not uppercase |
TOC |
| TRIP-OPERLNAM003 |
This vessel has not had this operator (OPERATOR_LNAME and OPERATOR_FNAME_MI) on any past trips |
TOC |
| TRIP-PERMIT001 |
PERMIT_NUM is blank |
TOC |
| TRIP-PERMIT002 |
PERMIT_NUM is not uppercase |
TOC |
| TRIP-PERMIT003 |
The permit number (PERMIT_NUM) has not been associated with this vessel name on any previous trips |
TOC |
| TRIP-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (TRIPS table) |
TOC |
| TRIP-TABVERS002 |
The TAB_VERS_ID was not found in the LOPADM_TAB_VERS table (the table version id does not exist) |
TOC |
| TRIP-TRIPNUM001 |
Trip number does not start with 'LL' or 'AS' |
TOC |
| TRIP-TRIPNUMLL001 |
Trip number does not start with 'LL' |
TOC |
| TRIP-TRIPNUMUP001 |
TRIP_NUM is not uppercase |
TOC |
| TRIP-TYPEUP001 |
TRIP_TYPE is not uppercase |
TOC |
| TRIP-VESSLEN001 |
Vessel length (VESSEL_LEN_FT) may be out of range (not between 40 and 109) |
TOC |
| TRIP-VESSNUL001 |
VESSEL_NAME is blank |
TOC |
| TRIP-VESSUP001 |
VESSEL_NAME is not uppercase |
TOC |
| TUNA-SEX001 |
GENDER is not M, F, or U |
TOC |
| TUNA-SPEC001 |
SPECIES_CODE is not a valid TUNA species |
TOC |
| TURT-ASCAPLATDIR001 |
Captured latitude (captured_lat) is in the northern hemisphere. |
TOC |
| TURT-ASRELLATDIR001 |
Released latitude (released_lat) is in the northern hemisphere. |
TOC |
| TURT-CAPLATDIR001 |
Captured latitude (captured_lat) is in the southern hemisphere. |
TOC |
| TURT-CAPLONDIR001 |
Captured longitude (captured_lon) is in the eastern hemisphere. |
TOC |
| TURT-CAPREL001 |
Release date/time cannot occur before capture date/time |
TOC |
| TURT-CAPTUREDT001 |
CAPTURED DATETIME is not between departure and arrival dates |
TOC |
| TURT-CAPTUREDT002 |
WARNING: The CAPTURED_DATETIME is not within a day of the RELEASED_DATETIME |
TOC |
| TURT-CAPTUREDT003 |
WARNING: The CAPTURED_DATETIME is after the RELEASED_DATETIME |
TOC |
| TURT-CARAPLENCRV001 |
CARAPACE_LEN_CURVED is outside database range |
TOC |
| TURT-CARAPLENSTR001 |
CARAPACE_LEN_STRAIGHT is outside database range |
TOC |
| TURT-CARAPWIDCRV001 |
CARAPACE_WID_CURVED is outside database range |
TOC |
| TURT-CARAPWIDSTR001 |
CARAPACE_WID_STRAIGHT is outside database range |
TOC |
| TURT-COLLFRMV001 |
COLLECT_FORM_VERS is blank (TURTLES form) |
TOC |
| TURT-COLLFRMV002 |
COLLECT_FORM_VERS is not valid (TURTLES form) |
TOC |
| TURT-DISP001 |
ENFORCEMENT ISSUE!!! Sea turtle was treated as catch (kept) |
TOC |
| TURT-DISPOSID001 |
DISPOSITION_ID for this turtle is blank |
TOC |
| TURT-DISPOSID002 |
DISPOSITION_ID is not present in the LOP_ANIMAL_DISPOSITION table |
TOC |
| TURT-DORSCLR001 |
TURT_DORSAL_COLOR_ID is not present in the LOP_TURT_DORSAL_COLOR table |
TOC |
| TURT-ENTANG001 |
ENTANGLED_YNU is not Y, N or U |
TOC |
| TURT-ENTANGLOC001 |
ENTANGLED_LOC_ID is not present in the LOP_ENTANGLED_LOC table |
TOC |
| TURT-GRATTCH001 |
GEAR_ATTACHED_TYPE_ID is not present in the LOP_GEAR_ATTACHED_TYPE table |
TOC |
| TURT-GRRMVL001 |
GEAR_REMVL_TYPE_ID is not present in the LOP_GEAR_REMVL_TYPE table |
TOC |
| TURT-HICAPLATDIR001 |
Captured latitude (captured_lat) is in the southern hemisphere. |
TOC |
| TURT-HICAPLONDIR001 |
Captured longitude (captured_lon) is in the eastern hemisphere. |
TOC |
| TURT-HIRELLATDIR001 |
Released latitude (released_lat) is in the southern hemisphere. |
TOC |
| TURT-HIRELLONDIR001 |
Released longitude (released_lon) is in the eastern hemisphere. |
TOC |
| TURT-HKD001 |
HOOKED_YNU is not Y, N or U |
TOC |
| TURT-HKDLOC001 |
HOOKED_LOC_ID is not present in the LOP_HOOKED_LOC table |
TOC |
| TURT-INFMARGSCU001 |
NUM_INFRAMARG_SCUTES is outside current database range |
TOC |
| TURT-INFRAPOR001 |
INFRA_W_PORES_YNU value is not Y, N or U |
TOC |
| TURT-INJUR001 |
INJURIES_YN is not Y or N |
TOC |
| TURT-LANDED001 |
LANDED_YN is not Y or N |
TOC |
| TURT-LTCOSTSCU001 |
Number of left costal scutes (NUM_LT_COSTAL_SCUTES) is outside current database range |
TOC |
| TURT-LTDVCCLR001 |
LITE_DEVICE_COLOR_ID is not present in the LOP_COLOR table |
TOC |
| TURT-LTDVCPROX001 |
LITE_DEVICE_PROX_ID is not present in the LOP_LITE_DEVICE_PROX table |
TOC |
| TURT-OVRLAPSCU001 |
OVERLAPNG_SCUTES_YNU value is not Y, N or U |
TOC |
| TURT-PLASTLENSTR001 |
PLASTRON_LEN_STRAIGHT is outside database range |
TOC |
| TURT-PRPREFRNTL001 |
PAIR_PREFRNTL_SCALES_YNU value is not Y, N or U |
TOC |
| TURT-RELLATDIR001 |
Released latitude (released_lat) is in the southern hemisphere. |
TOC |
| TURT-RELLONDIR001 |
Released longitude (released_lon) is in the eastern hemisphere. |
TOC |
| TURT-RLSDDT001 |
RELEASED DATETIME is not between departure and arrival dates |
TOC |
| TURT-RTCOSTSCU001 |
Number of right costal scutes (NUM_RT_COSTAL_SCUTES) is outside current database range |
TOC |
| TURT-RUBCARAP001 |
RUBBERY_CARAPACE_YNU value is not Y, N or U |
TOC |
| TURT-SPECIDNUM001 |
The legacy specimen id number (SPECIMEN_IDNUM) is not uppercase |
TOC |
| TURT-SPECIES001 |
SPECIES_CODE is not a valid TURTLE species (if this is an unusual species, please report it to a debriefer) |
TOC |
| TURT-TABVERS001 |
The table version id (TAB_VERS_ID) is blank (TURTLES table) |
TOC |
| TURT-TABVERS002 |
TAB_VERS_ID for this table does not exist in the LOPADM_TAB_VERS table |
TOC |
| TURT-TAGAPPLD001 |
TAGS_APPLIED_YN is not Y or N |
TOC |
| TURT-TAGPRES001 |
TAGS_PRESENT_YNU is not Y, N or U |
TOC |
| TURT-TAGRMVD001 |
TAG_REMOVED_YN is not Y or N |
TOC |
| TURT-TAILLEN001 |
TAIL_LEN is outside database range |
TOC |
| TURT-VERTEBSCU001 |
NUM_VERTEB_SCUTES is outside current database range |
TOC |
| VESS-BUNK001 |
Number of bunks may be out of range |
TOC |
| VESS-GPSUP001 |
Field contents must be upper case |
TOC |
| VESS-HEADSUP001 |
Field contents must be upper case |
TOC |
| VESS-NUMREEL001 |
Number of reels may be out of range |
TOC |
| VESS-RADARUP001 |
Field contents must be upper case |
TOC |
| VESS-REELDIAM001 |
Diameter of reel1 may be out of range |
TOC |
| VESS-REELDIAM002 |
Diameter of reel2 may be out of range |
TOC |
| VESS-SHOOTUP001 |
Field contents must be upper case |
TOC |
| VESS-SSBUP001 |
Field contents must be upper case |
TOC |
| VESS-VESSLEN001 |
VESSEL_LEN may be out of range (not between 40 and 109) |
TOC |