MM_OBS_TRIP_REPORT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75188 | Updated: May 21, 2025 | Published / External
Entity Information
| Description: |
Captures much of the hard copy Trip Information Form. |
|---|
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
BEGIN_DATE | DATE | Day trip began | |
|
100
|
BEGIN_TIME | NUMBER(4,0) | Time trip began | |
|
100
|
CAPTAIN_EXPERIENCE | NUMBER(3,0) | Captains experience (years) | |
|
100
|
COMMENTS | VARCHAR2(2000 BYTE) | Comments on trip | |
|
100
|
CONTRACT_AREA_CODE | VARCHAR2(6 BYTE) | AMMOP code for AMMOP statistical sample area | |
|
100
|
CONTRACT_AREA_ID | NUMBER(6,0) | Unique identifier of the AMMOP statistical sampling area | |
|
100
|
COUNTRY_CODE | VARCHAR2(10 BYTE) | Captains country | |
|
100
|
DEALER_ID | NUMBER(6,0) | The unique identifier of a dealer | |
|
100
|
DEALER_NAME | VARCHAR2(60 BYTE) | Dealer name | |
|
100
|
DEBRIEFED_BY_INITIALS | VARCHAR2(3 BYTE) | Debriefer initials | |
|
100
|
DEBRIEFED_DATE | DATE | Day trip was debriefed in field | |
|
100
|
EDITED_BY_INITIALS | VARCHAR2(3 BYTE) | Reviewer initials | |
|
100
|
EDITED_DATE | DATE | Day trip was edited (reviewed) by NMFS | |
|
100
|
END_DATE | DATE | Day trip ended | |
|
100
|
END_TIME | NUMBER(4,0) | Time trip ended | |
|
100
|
ENTERED_BY_INITIALS | VARCHAR2(3 BYTE) | Initials of data clerk | |
|
100
|
ENTERED_DATE | DATE | Day trip data entered | |
|
100
|
EXPECTED_NUMBER_PICKS | NUMBER(3,0) | Number of picks fisher estimated at begining of trip. | |
|
100
|
FISHERY_ID | NUMBER(6,0) | Unique database identifier for fishery | |
|
100
|
FISHERY_NAME | VARCHAR2(30 BYTE) | Name of fishery | |
|
100
|
FISHERY_SEQ | NUMBER(3,0) | Unqiue database identifier for sub fishery | |
|
100
|
HOMEPORT_CITY | VARCHAR2(40 BYTE) | Vessel homeport city | |
|
100
|
HOMEPORT_STATE | VARCHAR2(5 BYTE) | Vessel homeport state | |
|
100
|
HOMETOWN_NAME | VARCHAR2(40 BYTE) | Captains hometown name | |
|
100
|
HOME_STATE_CODE | VARCHAR2(5 BYTE) | Captains homestate name | |
|
100
|
ID | NUMBER(6,0) | Unqiue database identifier for trip | |
|
100
|
MONTH | NUMBER(2,0) | Month | |
|
100
|
NUMBER_OF_BIRDS_TAKEN | NUMBER(3,0) | Number of seabirds taken | |
|
100
|
NUMBER_OF_HAULS_ESTIMATED | NUMBER(4,0) | Estimated number of hauls prior to departure. | |
|
100
|
NUMBER_OF_HAULS_OBSERVED | NUMBER(4,0) | Number of hauls observed this trip | |
|
100
|
NUMBER_OF_HAULS_UNOBSERVED | NUMBER(4,0) | Number of hauls that were not observed. | |
|
100
|
NUMBER_OF_MAMMALS_TAKEN | NUMBER(3,0) | Number of mammals taken | |
|
100
|
NUMBER_OF_NETS_FISHING | NUMBER(3,0) | Number of nets fishing | |
|
100
|
NUMBER_OF_NETS_OBSERVED | NUMBER(3,0) | Number of nets observed this trip | |
|
100
|
NUMBER_OF_SKIFFS | NUMBER(2,0) | Number of skiffs invovled in fishing | |
|
100
|
NUM_PRIMARY_SPECIES_LANDED | NUMBER(5,0) | Number primary species landed | |
|
100
|
OBSERVER_CODE | VARCHAR2(3 BYTE) | AMMOP code for observer recording data | |
|
100
|
OBSERVER_ID | NUMBER(6,0) | The unique identifier of a person. | |
|
100
|
OPERATION_TYPE_CODE | VARCHAR2(2 BYTE) | AMMOP code for type of fishing operation observed | |
|
100
|
PRIMARY_SPECIES_CODE | VARCHAR2(5 BYTE) | AMMOP species code | |
|
100
|
PRIMARY_SPECIES_ID | NUMBER(6,0) | The unique identifier of the Specie Group. | |
|
100
|
PRIMARY_SPECIES_NAME | VARCHAR2(40 BYTE) | Common name | |
|
100
|
RECEIVED_DATE | DATE | Day trip recieved in Juneau | |
|
100
|
RECEIVED_INITIALS | VARCHAR2(3 BYTE) | Initials of individual who recieved trip in Juneau | |
|
100
|
SELECTION_METHOD_CODE | VARCHAR2(2 BYTE) | AMMOP code for method used to select permit holder. | |
|
100
|
STEAM_TIME | NUMBER(4,2) | Steam time to fishing site | |
|
100
|
STEAM_TIME_IN_MINUTES | NUMBER(6,0) | Steam time to fishing site in minutes | |
|
100
|
TRANSFER_LOCATION_NAME | VARCHAR2(150 BYTE) | Location of transfer to dealer | |
|
100
|
TRIP_CODE | VARCHAR2(6 BYTE) | Unqiue AMMOP code for trip | |
|
100
|
TRIP_TYPE_CODE | VARCHAR2(2 BYTE) | AMMOP code for type of trip | |
|
100
|
VESSEL_ADFG_NUMBER | VARCHAR2(8 BYTE) | Vessel ADGF number | |
|
100
|
VESSEL_ID | NUMBER(6,0) | The unique identifier of a vessel. | |
|
100
|
VESSEL_NAME | VARCHAR2(60 BYTE) | Vessel name | |
|
100
|
VESSEL_USCG_NUMBER | VARCHAR2(7 BYTE) | Vessel USCG number | |
|
100
|
YEAR | NUMBER(4,0) | Year |
Attribute Details
BEGIN_DATE
CC ID: 1374600
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day trip began |
BEGIN_TIME
CC ID: 1374601
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Time trip began |
CAPTAIN_EXPERIENCE
CC ID: 1374602
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captains experience (years) |
COMMENTS
CC ID: 1374603
| Data Storage Type: | VARCHAR2(2000 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Comments on trip |
CONTRACT_AREA_CODE
CC ID: 1374604
| Data Storage Type: | VARCHAR2(6 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for AMMOP statistical sample area |
CONTRACT_AREA_ID
CC ID: 1374605
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique identifier of the AMMOP statistical sampling area |
COUNTRY_CODE
CC ID: 1374606
| Data Storage Type: | VARCHAR2(10 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captains country |
DEALER_ID
CC ID: 1374607
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The unique identifier of a dealer |
DEALER_NAME
CC ID: 1374608
| Data Storage Type: | VARCHAR2(60 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Dealer name |
DEBRIEFED_BY_INITIALS
CC ID: 1374609
| Data Storage Type: | VARCHAR2(3 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Debriefer initials |
DEBRIEFED_DATE
CC ID: 1374610
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day trip was debriefed in field |
EDITED_BY_INITIALS
CC ID: 1374611
| Data Storage Type: | VARCHAR2(3 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Reviewer initials |
EDITED_DATE
CC ID: 1374612
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day trip was edited (reviewed) by NMFS |
END_DATE
CC ID: 1374613
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day trip ended |
END_TIME
CC ID: 1374614
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Time trip ended |
ENTERED_BY_INITIALS
CC ID: 1374615
| Data Storage Type: | VARCHAR2(3 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials of data clerk |
ENTERED_DATE
CC ID: 1374616
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day trip data entered |
EXPECTED_NUMBER_PICKS
CC ID: 1374617
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of picks fisher estimated at begining of trip. |
FISHERY_ID
CC ID: 1374618
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique database identifier for fishery |
FISHERY_NAME
CC ID: 1374619
| Data Storage Type: | VARCHAR2(30 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of fishery |
FISHERY_SEQ
CC ID: 1374620
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unqiue database identifier for sub fishery |
HOMEPORT_CITY
CC ID: 1374621
| Data Storage Type: | VARCHAR2(40 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel homeport city |
HOMEPORT_STATE
CC ID: 1374622
| Data Storage Type: | VARCHAR2(5 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel homeport state |
HOMETOWN_NAME
CC ID: 1374623
| Data Storage Type: | VARCHAR2(40 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captains hometown name |
HOME_STATE_CODE
CC ID: 1374624
| Data Storage Type: | VARCHAR2(5 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captains homestate name |
ID
CC ID: 1374625
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unqiue database identifier for trip |
MONTH
CC ID: 1374626
| Data Storage Type: | NUMBER(2,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Month |
NUMBER_OF_BIRDS_TAKEN
CC ID: 1374627
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of seabirds taken |
NUMBER_OF_HAULS_ESTIMATED
CC ID: 1374628
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Estimated number of hauls prior to departure. |
NUMBER_OF_HAULS_OBSERVED
CC ID: 1374629
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of hauls observed this trip |
NUMBER_OF_HAULS_UNOBSERVED
CC ID: 1374630
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of hauls that were not observed. |
NUMBER_OF_MAMMALS_TAKEN
CC ID: 1374631
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of mammals taken |
NUMBER_OF_NETS_FISHING
CC ID: 1374632
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of nets fishing |
NUMBER_OF_NETS_OBSERVED
CC ID: 1374633
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of nets observed this trip |
NUMBER_OF_SKIFFS
CC ID: 1374634
| Data Storage Type: | NUMBER(2,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of skiffs invovled in fishing |
NUM_PRIMARY_SPECIES_LANDED
CC ID: 1374635
| Data Storage Type: | NUMBER(5,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number primary species landed |
OBSERVER_CODE
CC ID: 1374636
| Data Storage Type: | VARCHAR2(3 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for observer recording data |
OBSERVER_ID
CC ID: 1374637
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The unique identifier of a person. |
OPERATION_TYPE_CODE
CC ID: 1374638
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for type of fishing operation observed |
PRIMARY_SPECIES_CODE
CC ID: 1374639
| Data Storage Type: | VARCHAR2(5 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP species code |
PRIMARY_SPECIES_ID
CC ID: 1374640
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The unique identifier of the Specie Group. |
PRIMARY_SPECIES_NAME
CC ID: 1374641
| Data Storage Type: | VARCHAR2(40 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Common name |
RECEIVED_DATE
CC ID: 1374642
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day trip recieved in Juneau |
RECEIVED_INITIALS
CC ID: 1374643
| Data Storage Type: | VARCHAR2(3 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials of individual who recieved trip in Juneau |
SELECTION_METHOD_CODE
CC ID: 1374644
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for method used to select permit holder. |
STEAM_TIME
CC ID: 1374645
| Data Storage Type: | NUMBER(4,2) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Steam time to fishing site |
STEAM_TIME_IN_MINUTES
CC ID: 1374646
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Steam time to fishing site in minutes |
TRANSFER_LOCATION_NAME
CC ID: 1374647
| Data Storage Type: | VARCHAR2(150 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Location of transfer to dealer |
TRIP_CODE
CC ID: 1374648
| Data Storage Type: | VARCHAR2(6 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unqiue AMMOP code for trip |
TRIP_TYPE_CODE
CC ID: 1374649
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for type of trip |
VESSEL_ADFG_NUMBER
CC ID: 1374650
| Data Storage Type: | VARCHAR2(8 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel ADGF number |
VESSEL_ID
CC ID: 1374651
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The unique identifier of a vessel. |
VESSEL_NAME
CC ID: 1374652
| Data Storage Type: | VARCHAR2(60 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel name |
VESSEL_USCG_NUMBER
CC ID: 1374653
| Data Storage Type: | VARCHAR2(7 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel USCG number |
YEAR
CC ID: 1374654
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year |
Catalog Details
| Catalog Item ID: | 75188 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:75188 |
| Metadata Record Created By: | Rachel Wuest |
| Metadata Record Created: | 2025-03-06 22:45+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 |