Table: LOV_GEAR_TYPE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7451 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table maps to the Norpac Domestic_Gear table and contains the valid gear types for both observed hauls and observed offloads.
DescriptionThis table maps to the Norpac Domestic_Gear table and contains the valid gear types for both observed hauls and observed offloads.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
GEAR_TYPE_CODE
NUMBER |
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record |
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. |
DESCRIPTION
VARCHAR2 |
Descriptive text for a gear |
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: | Table: LOV_GEAR_TYPE |
---|---|
Short Name: | 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 2183, 03-27-2008 11:52 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | TURNBULLD |
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
GEAR_TYPE_CODE | NUMBER | Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record | |
100
|
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
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 38 |
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
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
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: | 7451 |
---|---|
GUID: | gov.noaa.nmfs.inport:7451 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2008-03-27 11:52+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 |