Downtime Notice: Thursday, May 29 @ 2:00pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 6.0.2. Downtime Schedule May 29, 2025 2:00pm - 3:00pm Eastern / 11:00am - 12:00pm Pacific / 8:00am - 9:00am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheri...
View All
Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_HAUL_SPECIES

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75177  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Captures catch information as recorded on hard copy Set Gillnet Haul Form.

Entity Information

Data Attribute / Type Description
COMMENTS
VARCHAR2(2000 BYTE) 		This field is not used because no recording space is available on hard copy forms; see mm_obs_haul for haul_ species comments.
CONDITION_CODE
VARCHAR2(2 BYTE) 		The AMMOP condition code from the haul form
CONDITION_DESCRIPTION
VARCHAR2(2 BYTE) 		The condition description
CONDITION_ID
NUMBER(6,0) 		Unique database identifier for condition
COUNT_DETERMINED_CODE
VARCHAR2(1 BYTE) 		Method for obtaining the individual count
DISPOSITION_CODE
VARCHAR2(1 BYTE) 		The AMMOP disposition code from the haul form
DISPOSITION_REASON_CODE
VARCHAR2(2 BYTE) 		The AMMOP disposition reason code from the haul form
DISPOSITION_REASON_DESCRIPTION
VARCHAR2(100 BYTE) 		The AMMOP disposition reason code discription
DISPOSITION_REASON_ID
NUMBER(6,0) 		The unique database identifier for the the disposition reason id
INDIVIDUAL_COUNT
NUMBER(5,0) 		The number of species per condition and disposition
MONTH
VARCHAR2(2 BYTE) 		The month the trip began in
SEQUENCE_NUMBER
NUMBER(4,0) 		The corresponding haul number for the trip
SPECIES_CODE
VARCHAR2(5 BYTE) 		The AMMOP code for the species
SPECIES_ID
NUMBER(6,0) 		The unique identifier of the Specie Group.
SPECIES_NAME
VARCHAR2(40 BYTE) 		The common name for the species
SPECIES_SEQUENCE
NUMBER(3,0) 		The number of records per species per haul (ie to account for differences in conditions and dispositions)
TRIP_ID
NUMBER(6,0) 		Unique database identifier for trip
WEIGHT
NUMBER(6,1) 		The weight for the species by per condition and disposition
WEIGHT_DETERMINED_CODE
VARCHAR2(2 BYTE) 		The method for the determining the the weight
YEAR
NUMBER(4,0) 		The year the trip occured in

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: MM_HAUL_SPECIES

Entity Information

Description:

Captures catch information as recorded on hard copy Set Gillnet Haul Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 COMMENTS VARCHAR2(2000 BYTE) This field is not used because no recording space is available on hard copy forms; see mm_obs_haul for haul_ species comments.
100
 CONDITION_CODE VARCHAR2(2 BYTE) The AMMOP condition code from the haul form
100
 CONDITION_DESCRIPTION VARCHAR2(2 BYTE) The condition description
100
 CONDITION_ID NUMBER(6,0) Unique database identifier for condition
100
 COUNT_DETERMINED_CODE VARCHAR2(1 BYTE) Method for obtaining the individual count
100
 DISPOSITION_CODE VARCHAR2(1 BYTE) The AMMOP disposition code from the haul form
100
 DISPOSITION_REASON_CODE VARCHAR2(2 BYTE) The AMMOP disposition reason code from the haul form
100
 DISPOSITION_REASON_DESCRIPTION VARCHAR2(100 BYTE) The AMMOP disposition reason code discription
100
 DISPOSITION_REASON_ID NUMBER(6,0) The unique database identifier for the the disposition reason id
100
 INDIVIDUAL_COUNT NUMBER(5,0) The number of species per condition and disposition
100
 MONTH VARCHAR2(2 BYTE) The month the trip began in
100
 SEQUENCE_NUMBER NUMBER(4,0) The corresponding haul number for the trip
100
 SPECIES_CODE VARCHAR2(5 BYTE) The AMMOP code for the species
100
 SPECIES_ID NUMBER(6,0) The unique identifier of the Specie Group.
100
 SPECIES_NAME VARCHAR2(40 BYTE) The common name for the species
100
 SPECIES_SEQUENCE NUMBER(3,0) The number of records per species per haul (ie to account for differences in conditions and dispositions)
100
 TRIP_ID NUMBER(6,0) Unique database identifier for trip
100
 WEIGHT NUMBER(6,1) The weight for the species by per condition and disposition
100
 WEIGHT_DETERMINED_CODE VARCHAR2(2 BYTE) The method for the determining the the weight
100
 YEAR NUMBER(4,0) The year the trip occured in

Attribute Details

COMMENTS

CC ID: 1374363
Data Storage Type: VARCHAR2(2000 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

This field is not used because no recording space is available on hard copy forms; see mm_obs_haul for haul_ species comments.

CONDITION_CODE

CC ID: 1374364
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP condition code from the haul form

CONDITION_DESCRIPTION

CC ID: 1374365
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The condition description

CONDITION_ID

CC ID: 1374366
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique database identifier for condition

COUNT_DETERMINED_CODE

CC ID: 1374367
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Method for obtaining the individual count

DISPOSITION_CODE

CC ID: 1374368
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP disposition code from the haul form

DISPOSITION_REASON_CODE

CC ID: 1374369
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP disposition reason code from the haul form

DISPOSITION_REASON_DESCRIPTION

CC ID: 1374370
Data Storage Type: VARCHAR2(100 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP disposition reason code discription

DISPOSITION_REASON_ID

CC ID: 1374371
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

The unique database identifier for the the disposition reason id

INDIVIDUAL_COUNT

CC ID: 1374372
Data Storage Type: NUMBER(5,0)
Required: No
Primary Key: No
Status: Active
Description:

The number of species per condition and disposition

MONTH

CC ID: 1374373
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The month the trip began in

SEQUENCE_NUMBER

CC ID: 1374374
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

The corresponding haul number for the trip

SPECIES_CODE

CC ID: 1374375
Data Storage Type: VARCHAR2(5 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for the species

SPECIES_ID

CC ID: 1374376
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

The unique identifier of the Specie Group.

SPECIES_NAME

CC ID: 1374377
Data Storage Type: VARCHAR2(40 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The common name for the species

SPECIES_SEQUENCE

CC ID: 1374378
Data Storage Type: NUMBER(3,0)
Required: No
Primary Key: No
Status: Active
Description:

The number of records per species per haul (ie to account for differences in conditions and dispositions)

TRIP_ID

CC ID: 1374379
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique database identifier for trip

WEIGHT

CC ID: 1374380
Data Storage Type: NUMBER(6,1)
Required: No
Primary Key: No
Status: Active
Description:

The weight for the species by per condition and disposition

WEIGHT_DETERMINED_CODE

CC ID: 1374381
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The method for the determining the the weight

YEAR

CC ID: 1374382
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

The year the trip occured in

Catalog Details

Catalog Item ID: 75177
GUID: gov.noaa.nmfs.inport:75177
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 21:41+0000
Metadata Record Last Modified By: Daniel Woodrich
Metadata Record Last Modified: 2025-05-21 19:12+0000
Metadata Record Published: 2025-05-21
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year