MM_HAUL_SPECIES
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75177 | Updated: May 21, 2025 | Published / External
Entity Information
| Description: |
Captures catch information as recorded on hard copy Set Gillnet Haul Form. |
|---|
Data Attributes
Attribute Summary
|
|
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 |