Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
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_OBS_TRIP_REPORT

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

Summary

Description

Captures much of the hard copy Trip Information Form.

Entity Information

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

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_OBS_TRIP_REPORT

Entity Information

Description:

Captures much of the hard copy Trip Information Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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