Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Special Projects > Alternative catch monitoring of Alaskan groundf... > AFSC/FMA/NPRB Alternative Catch Monitoring Tabl... >

Table: ATL_LOV_GEAR_TYPE

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:19012  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: ATL_LOV_GEAR_TYPE
Short Name: ATL_LOV_GEAR_TYPE
Status: Completed
Abstract:

This table maps to the Norpac Domestic_Gear table and contains the valid gear types for both observed hauls and observed offloads.
Notes:

Loaded by batch 4574, 05-03-2013 17:18

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NPRB_1017
Description:

This table maps to the Norpac Domestic_Gear table and contains the valid gear types for both observed hauls and observed offloads.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key GEAR_TYPE_CODE NUMBER Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
100
 Primary Key GEARTYPE_FORM VARCHAR2 Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.
100
 DESCRIPTION VARCHAR2 Descriptive text for a gear

Attribute Details

GEAR_TYPE_CODE

CC ID: 112058
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
General Data Type: NUMBER

GEARTYPE_FORM

CC ID: 112059
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: Yes
Status: Active
Description:

Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.
General Data Type: VARCHAR2

DESCRIPTION

CC ID: 112060
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 25
Required: Yes
Primary Key: No
Status: Active
Description:

Descriptive text for a gear
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 19012
GUID: gov.noaa.nmfs.inport:19012
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-05-03 17:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18