MM_LEAD
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75184 | Updated: May 21, 2025 | Published / External
Entity Information
| Description: |
Captures the lead characteristics recorded on hard copy Set Gillnet Gear Characteristics Form. |
|---|
Data Attributes
Attribute Summary
|
|
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 |