Downtime Notice: Thursday, May 29 @ 2:00pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 6.0.2. Downtime Schedule May 29, 2025 2:00pm - 3:00pm Eastern / 11:00am - 12:00pm Pacific / 8:00am - 9:00am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheri...
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_LEAD

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

Summary

Description

Captures the lead characteristics recorded on hard copy Set Gillnet Gear Characteristics Form.

Entity Information

Data Attribute / Type Description
AKRGEAR_ID
NUMBER(6,0) 		References Agency Gear Where Agency = MMOBS
COLOR_CODE
VARCHAR2(2 BYTE) 		AMMOP code identifier of a color.
COLOR_ID
NUMBER(6,0) 		Unique database identifier for the color code
COLOR_NAME
VARCHAR2(20 BYTE) 		Descriptive name of a color.
LENGTH
NUMBER(4,0) 		The length of the lead in fathoms
MATERIAL_CODE
VARCHAR2(2 BYTE) 		AMMOP code linked to a description of the fiber characteristics of the lead.
MATERIAL_DESCRIPTION
VARCHAR2(60 BYTE) 		Descriptive text of lead fiber characteristics.
MATERIAL_ID
NUMBER(6,0) 		Unique database identifier for net material code
MAX_MESHES_DEEP
NUMBER(3,0) 		The maximum number of meshes deep on the lead.
MAX_MESH_SIZE
NUMBER(3,1) 		The maximum mesh size present in the lead (inches)
MESHES_DEEP
NUMBER(3,0) 		The number of meshes deep as a single number instead of minimum and maximum
MIN_MESHES_DEEP
NUMBER(3,0) 		The minimum number of meshes deep on the lead.
MIN_MESH_SIZE
NUMBER(3,1) 		The minimum mesh size present in the lead (inches)
MMGEAR_ID
NUMBER(6,0) 		Unique database identifier for associated gear record
SEQUENCE_NUMBER
NUMBER(3,0) 		Should be one lead per net, this number is always one
TWINE_SIZE
VARCHAR2(3 BYTE) 		The twine size, typically an industry standard number (as opposed to english or metric unit)

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_LEAD

Entity Information

Description:

Captures the lead characteristics recorded on hard copy Set Gillnet Gear Characteristics Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AKRGEAR_ID NUMBER(6,0) References Agency Gear Where Agency = MMOBS
100
 COLOR_CODE VARCHAR2(2 BYTE) AMMOP code identifier of a color.
100
 COLOR_ID NUMBER(6,0) Unique database identifier for the color code
100
 COLOR_NAME VARCHAR2(20 BYTE) Descriptive name of a color.
100
 LENGTH NUMBER(4,0) The length of the lead in fathoms
100
 MATERIAL_CODE VARCHAR2(2 BYTE) AMMOP code linked to a description of the fiber characteristics of the lead.
100
 MATERIAL_DESCRIPTION VARCHAR2(60 BYTE) Descriptive text of lead fiber characteristics.
100
 MATERIAL_ID NUMBER(6,0) Unique database identifier for net material code
100
 MAX_MESHES_DEEP NUMBER(3,0) The maximum number of meshes deep on the lead.
100
 MAX_MESH_SIZE NUMBER(3,1) The maximum mesh size present in the lead (inches)
100
 MESHES_DEEP NUMBER(3,0) The number of meshes deep as a single number instead of minimum and maximum
100
 MIN_MESHES_DEEP NUMBER(3,0) The minimum number of meshes deep on the lead.
100
 MIN_MESH_SIZE NUMBER(3,1) The minimum mesh size present in the lead (inches)
100
 MMGEAR_ID NUMBER(6,0) Unique database identifier for associated gear record
100
 SEQUENCE_NUMBER NUMBER(3,0) Should be one lead per net, this number is always one
100
 TWINE_SIZE VARCHAR2(3 BYTE) The twine size, typically an industry standard number (as opposed to english or metric unit)

Attribute Details

AKRGEAR_ID

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

References Agency Gear Where Agency = MMOBS

COLOR_CODE

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

AMMOP code identifier of a color.

COLOR_ID

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

Unique database identifier for the color code

COLOR_NAME

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

Descriptive name of a color.

LENGTH

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

The length of the lead in fathoms

MATERIAL_CODE

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

AMMOP code linked to a description of the fiber characteristics of the lead.

MATERIAL_DESCRIPTION

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

Descriptive text of lead fiber characteristics.

MATERIAL_ID

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

Unique database identifier for net material code

MAX_MESHES_DEEP

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

The maximum number of meshes deep on the lead.

MAX_MESH_SIZE

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

The maximum mesh size present in the lead (inches)

MESHES_DEEP

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

The number of meshes deep as a single number instead of minimum and maximum

MIN_MESHES_DEEP

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

The minimum number of meshes deep on the lead.

MIN_MESH_SIZE

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

The minimum mesh size present in the lead (inches)

MMGEAR_ID

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

Unique database identifier for associated gear record

SEQUENCE_NUMBER

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

Should be one lead per net, this number is always one

TWINE_SIZE

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

The twine size, typically an industry standard number (as opposed to english or metric unit)

Catalog Details

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