75188
MM_OBS_TRIP_REPORT
Entity
Published / External
75024
AMMOP Oracle database 1999 - 2013
Data Set
Captures much of the hard copy Trip Information Form.
BEGIN_DATE
DATE
No
No
Active
Day trip began
YEAR
NUMBER(4,0)
No
No
Active
Year
CAPTAIN_EXPERIENCE
NUMBER(3,0)
No
No
Active
Captains experience (years)
COMMENTS
VARCHAR2(2000 BYTE)
No
No
Active
Comments on trip
CONTRACT_AREA_CODE
VARCHAR2(6 BYTE)
No
No
Active
AMMOP code for AMMOP statistical sample area
CONTRACT_AREA_ID
NUMBER(6,0)
No
No
Active
Unique identifier of the AMMOP statistical sampling area
COUNTRY_CODE
VARCHAR2(10 BYTE)
No
No
Active
Captains country
DEALER_ID
NUMBER(6,0)
No
No
Active
The unique identifier of a dealer
DEALER_NAME
VARCHAR2(60 BYTE)
No
No
Active
Dealer name
DEBRIEFED_BY_INITIALS
VARCHAR2(3 BYTE)
No
No
Active
Debriefer initials
DEBRIEFED_DATE
DATE
No
No
Active
Day trip was debriefed in field
EDITED_BY_INITIALS
VARCHAR2(3 BYTE)
No
No
Active
Reviewer initials
EDITED_DATE
DATE
No
No
Active
Day trip was edited (reviewed) by NMFS
END_DATE
DATE
No
No
Active
Day trip ended
END_TIME
NUMBER(4,0)
No
No
Active
Time trip ended
ENTERED_BY_INITIALS
VARCHAR2(3 BYTE)
No
No
Active
Initials of data clerk
ENTERED_DATE
DATE
No
No
Active
Day trip data entered
EXPECTED_NUMBER_PICKS
NUMBER(3,0)
No
No
Active
Number of picks fisher estimated at begining of trip.
FISHERY_ID
NUMBER(6,0)
No
No
Active
Unique database identifier for fishery
FISHERY_NAME
VARCHAR2(30 BYTE)
No
No
Active
Name of fishery
FISHERY_SEQ
NUMBER(3,0)
No
No
Active
Unqiue database identifier for sub fishery
HOMEPORT_CITY
VARCHAR2(40 BYTE)
No
No
Active
Vessel homeport city
HOMEPORT_STATE
VARCHAR2(5 BYTE)
No
No
Active
Vessel homeport state
HOMETOWN_NAME
VARCHAR2(40 BYTE)
No
No
Active
Captains hometown name
HOME_STATE_CODE
VARCHAR2(5 BYTE)
No
No
Active
Captains homestate name
ID
NUMBER(6,0)
No
No
Active
Unqiue database identifier for trip
MONTH
NUMBER(2,0)
No
No
Active
Month
NUMBER_OF_BIRDS_TAKEN
NUMBER(3,0)
No
No
Active
Number of seabirds taken
NUMBER_OF_HAULS_ESTIMATED
NUMBER(4,0)
No
No
Active
Estimated number of hauls prior to departure.
NUMBER_OF_HAULS_OBSERVED
NUMBER(4,0)
No
No
Active
Number of hauls observed this trip
NUMBER_OF_HAULS_UNOBSERVED
NUMBER(4,0)
No
No
Active
Number of hauls that were not observed.
NUMBER_OF_MAMMALS_TAKEN
NUMBER(3,0)
No
No
Active
Number of mammals taken
NUMBER_OF_NETS_FISHING
NUMBER(3,0)
No
No
Active
Number of nets fishing
NUMBER_OF_NETS_OBSERVED
NUMBER(3,0)
No
No
Active
Number of nets observed this trip
NUMBER_OF_SKIFFS
NUMBER(2,0)
No
No
Active
Number of skiffs invovled in fishing
NUM_PRIMARY_SPECIES_LANDED
NUMBER(5,0)
No
No
Active
Number primary species landed
OBSERVER_CODE
VARCHAR2(3 BYTE)
No
No
Active
AMMOP code for observer recording data
OBSERVER_ID
NUMBER(6,0)
No
No
Active
The unique identifier of a person.
OPERATION_TYPE_CODE
VARCHAR2(2 BYTE)
No
No
Active
AMMOP code for type of fishing operation observed
PRIMARY_SPECIES_CODE
VARCHAR2(5 BYTE)
No
No
Active
AMMOP species code
RECEIVED_INITIALS
VARCHAR2(3 BYTE)
No
No
Active
Initials of individual who recieved trip in Juneau
PRIMARY_SPECIES_ID
NUMBER(6,0)
No
No
Active
The unique identifier of the Specie Group.
PRIMARY_SPECIES_NAME
VARCHAR2(40 BYTE)
No
No
Active
Common name
RECEIVED_DATE
DATE
No
No
Active
Day trip recieved in Juneau
SELECTION_METHOD_CODE
VARCHAR2(2 BYTE)
No
No
Active
AMMOP code for method used to select permit holder.
STEAM_TIME
NUMBER(4,2)
No
No
Active
Steam time to fishing site
STEAM_TIME_IN_MINUTES
NUMBER(6,0)
No
No
Active
Steam time to fishing site in minutes
TRANSFER_LOCATION_NAME
VARCHAR2(150 BYTE)
No
No
Active
Location of transfer to dealer
TRIP_CODE
VARCHAR2(6 BYTE)
No
No
Active
Unqiue AMMOP code for trip
TRIP_TYPE_CODE
VARCHAR2(2 BYTE)
No
No
Active
AMMOP code for type of trip
VESSEL_ADFG_NUMBER
VARCHAR2(8 BYTE)
No
No
Active
Vessel ADGF number
VESSEL_ID
NUMBER(6,0)
No
No
Active
The unique identifier of a vessel.
VESSEL_NAME
VARCHAR2(60 BYTE)
No
No
Active
Vessel name
VESSEL_USCG_NUMBER
VARCHAR2(7 BYTE)
No
No
Active
Vessel USCG number
BEGIN_TIME
NUMBER(4,0)
No
No
Active
Time trip began
gov.noaa.nmfs.inport:75188
Rachel Wuest
2025-03-06T22:45:39
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