75178 Entity Published / External 75024 AMMOP Oracle database 1999 - 2013 Data Set Captures hard copy Fish/ Shark Sample Form. COMMENTS VARCHAR2(2000 BYTE) No No Active Comments on sample WEIGHT_TYPE_CODE VARCHAR2(2 BYTE) No No Active The AMMOP code for method of obtaining weight. CONDITION_DESCRIPTION VARCHAR2(50 BYTE) No No Active The condition description CONDITION_ID NUMBER(6,0) No No Active The unique database id for the condition code FORK_LENGTH NUMBER(4,0) No No Active The fork length (cm) GIRTH NUMBER(4,0) No No Active The girth (cm) ID NUMBER(6,0) No No Active Unique database identifier INJURY_CODE VARCHAR2(2 BYTE) No No Active The AMMOP code for the fish/shark sample form injury code INJURY_DESCRIPTION VARCHAR2(50 BYTE) No No Active The injury code description INJURY_ID NUMBER(6,0) No No Active The unique database identifier for the injury code SAMPLE_NUMBER NUMBER(3,0) No No Active Unique sequence value within an observer trip. SAMPLE_WEIGHT NUMBER(5,1) No No Active The sample weight (kg.0) SEQUENCE_NUMBER NUMBER(4,0) No No Active Corresponds to haul number SEX VARCHAR2(1 BYTE) No No Active The sex as pick list SPECIES_CODE VARCHAR2(5 BYTE) No No Active The AMMOP code for the species SPECIES_CONDITION NUMBER(6,0) No No Active SPECIES_DISPOSITION NUMBER(6,0) No No Active SPECIES_ID NUMBER(6,0) No No Active The unique identifier for the spcies SPECIES_NAME VARCHAR2(40 BYTE) No No Active The common name for the species TAG_ONE VARCHAR2(12 BYTE) No No Active The Tag Number 1 field on the fish/shark sample form TAG_ONE_STATUS_CODE VARCHAR2(2 BYTE) No No Active The AMMOP code for the tag 1 tag status TAG_ONE_TYPE_CODE VARCHAR2(2 BYTE) No No Active The AMMOP code for the tag 1 tag type TAG_ONE_TYPE_ID NUMBER(6,0) No No Active The unique database id for the tag 1 tag type TAG_TWO VARCHAR2(12 BYTE) No No Active The Tag Number 2 field on the fish/shark sample form TAG_TWO_STATUS_CODE VARCHAR2(2 BYTE) No No Active The AMMOP code for the tag 2 tag status TAG_TWO_TYPE_CODE VARCHAR2(2 BYTE) No No Active The AMMOP code for the tag 2 tag type TAG_TWO_TYPE_ID NUMBER(6,0) No No Active The unique database id for the tag 2 tag type TISSUE_SAMPLE_TAKEN_FLAG VARCHAR2(1 BYTE) No No Active Was a tissue sample collected? TOTAL_LENGTH NUMBER(4,0) No No Active The total length (cm) TRIP_ID NUMBER(6,0) No No Active Unique database identifier for AMMOP trip CONDITION_CODE VARCHAR2(2 BYTE) No No Active The AMMOP code for the condition gov.noaa.nmfs.inport:75178 Rachel Wuest 2025-03-06T21:48:03 Daniel Woodrich 2025-05-21T19:12:04 2025-05-21 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 1 Year