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_FISHER_COMMENT

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

Summary

Description

Table captures hard copy Fisher's Comment Form

Entity Information

Data Attribute / Type Description
AK_FISHERY_CODE
VARCHAR2(10 BYTE) 		ADFG fishery code
AK_NUMBER
VARCHAR2(8 BYTE) 		The AK registration number, if applicable
COMMENTS
VARCHAR2(2000 BYTE) 		Text field for entering fisher comments
COMMENT_DATE
DATE 		Date from completed
FIRST_NAME
VARCHAR2(20 BYTE) 		First name of Fisher providing comments
FISHERY_ID
NUMBER(6,0) 		Unqiue database number from mm_fishery
FISHERY_SEQ
NUMBER(3,0) 		This number plus the fishery_id forms the unqiue database identifier for the fishery_code as found in mm_fishery_content
ID
NUMBER(6,0) 		Unique database identifier
LAST_NAME
VARCHAR2(30 BYTE) 		Last name of Fisher providing comments
MONTH
NUMBER(2,0) 		Month form completed
PERMIT_ID
NUMBER(6,0) 		Unique database identifier for permit number
PERMIT_NUMBER
VARCHAR2(6 BYTE) 		ADFG fishery permit number of fisher submitting comments
TRIP_CODE
VARCHAR2(9 BYTE) 		AMMOP trip code for trip during which form was completed
TRIP_ID
NUMBER(6,0) 		Unique database identifier for trip during which form completed
USCG_NUMBER
VARCHAR2(8 BYTE) 		A look up list based on the non-AMMOP table akfish.vessel
VESSEL_ID
NUMBER(6,0) 		The vessel unique identifier in the non-AMMOP table akfish.vessel
VESSEL_NAME
VARCHAR2(60 BYTE) 		The vessel name if applicable
YEAR
NUMBER(4,0) 		Year form completed

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_FISHER_COMMENT

Entity Information

Description:

Table captures hard copy Fisher's Comment Form

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AK_FISHERY_CODE VARCHAR2(10 BYTE) ADFG fishery code
100
 AK_NUMBER VARCHAR2(8 BYTE) The AK registration number, if applicable
100
 COMMENTS VARCHAR2(2000 BYTE) Text field for entering fisher comments
100
 COMMENT_DATE DATE Date from completed
100
 FIRST_NAME VARCHAR2(20 BYTE) First name of Fisher providing comments
100
 FISHERY_ID NUMBER(6,0) Unqiue database number from mm_fishery
100
 FISHERY_SEQ NUMBER(3,0) This number plus the fishery_id forms the unqiue database identifier for the fishery_code as found in mm_fishery_content
100
 ID NUMBER(6,0) Unique database identifier
100
 LAST_NAME VARCHAR2(30 BYTE) Last name of Fisher providing comments
100
 MONTH NUMBER(2,0) Month form completed
100
 PERMIT_ID NUMBER(6,0) Unique database identifier for permit number
100
 PERMIT_NUMBER VARCHAR2(6 BYTE) ADFG fishery permit number of fisher submitting comments
100
 TRIP_CODE VARCHAR2(9 BYTE) AMMOP trip code for trip during which form was completed
100
 TRIP_ID NUMBER(6,0) Unique database identifier for trip during which form completed
100
 USCG_NUMBER VARCHAR2(8 BYTE) A look up list based on the non-AMMOP table akfish.vessel
100
 VESSEL_ID NUMBER(6,0) The vessel unique identifier in the non-AMMOP table akfish.vessel
100
 VESSEL_NAME VARCHAR2(60 BYTE) The vessel name if applicable
100
 YEAR NUMBER(4,0) Year form completed

Attribute Details

AK_FISHERY_CODE

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

ADFG fishery code

AK_NUMBER

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

The AK registration number, if applicable

COMMENTS

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

Text field for entering fisher comments

COMMENT_DATE

CC ID: 1374290
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date from completed

FIRST_NAME

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

First name of Fisher providing comments

FISHERY_ID

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

Unqiue database number from mm_fishery

FISHERY_SEQ

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

This number plus the fishery_id forms the unqiue database identifier for the fishery_code as found in mm_fishery_content

ID

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

Unique database identifier

LAST_NAME

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

Last name of Fisher providing comments

MONTH

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

Month form completed

PERMIT_ID

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

Unique database identifier for permit number

PERMIT_NUMBER

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

ADFG fishery permit number of fisher submitting comments

TRIP_CODE

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

AMMOP trip code for trip during which form was completed

TRIP_ID

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

Unique database identifier for trip during which form completed

USCG_NUMBER

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

A look up list based on the non-AMMOP table akfish.vessel

VESSEL_ID

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

The vessel unique identifier in the non-AMMOP table akfish.vessel

VESSEL_NAME

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

The vessel name if applicable

YEAR

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

Year form completed

Catalog Details

Catalog Item ID: 75170
GUID: gov.noaa.nmfs.inport:75170
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 18:30+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