Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: FLS_ORIGINAL_GEARS_V
Short Name: FLS_ORIGINAL_GEARS_V
Status: Completed
Abstract:

To recreate the gears table as it appears in the legacy logbook system from the SEFIN8 data.04/01/2002 Mike Judge requested that Time/Diver using Spear Guns be moved from the effort column to the fished column.

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None gears
None legacy view

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: FLS
Description:

To recreate the gears table as it appears in the legacy logbook system from the SEFIN8 data.04/01/2002 Mike Judge requested that Time/Diver using Spear Guns be moved from the effort column to the fished column.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SCHEDULE VARCHAR2 Schedule Number
100
GEAR VARCHAR2 Snapper Grouper Geat Code
100
NUMGEAR NUMBER Number Of Gear
100
EFFORT NUMBER Fishing Effort
100
FISHED NUMBER Time Fished
100
LENGTH NUMBER Length If Gear
100
MESH1 NUMBER Mesh Measurement 1
100
MESH2 NUMBER Mesh Measurement 2
100
MESH3 NUMBER Mesh Measurement 3
100
MESH4 NUMBER Mesh Measurement 4

Attribute Details

SCHEDULE

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

Schedule Number

General Data Type: VARCHAR2

GEAR

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

Snapper Grouper Geat Code

General Data Type: VARCHAR2

NUMGEAR

CC ID: 27282
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number Of Gear

General Data Type: NUMBER

EFFORT

CC ID: 27291
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Fishing Effort

General Data Type: NUMBER

FISHED

CC ID: 27283
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Time Fished

General Data Type: NUMBER

LENGTH

CC ID: 27286
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Length If Gear

General Data Type: NUMBER

MESH1

CC ID: 27290
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Mesh Measurement 1

General Data Type: NUMBER

MESH2

CC ID: 27289
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Mesh Measurement 2

General Data Type: NUMBER

MESH3

CC ID: 27285
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Mesh Measurement 3

General Data Type: NUMBER

MESH4

CC ID: 27284
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Mesh Measurement 4

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7162
GUID: gov.noaa.nmfs.inport:7162
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07