Slide Menu
System Maintenance Notice, Sunday, May 22, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

Holds what was catched in golden crab trips

Notes:

Loaded by batch 2045, 12-20-2007 10:28

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None gears
None golden crabs
None trip data

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 1995-present

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Florida
None Georgia
None North Carolina
None South Carolina

Entity Information

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

Holds what was catched in golden crab trips

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SCHEDULE_NUMBER VARCHAR2 Identifies the Trip
100
Primary Key STRING NUMBER String used in the catch
100
SHAPE VARCHAR2 Shape, Material, and Volume used in this catch
100
MATERIAL VARCHAR2 Material
100
VOLUME VARCHAR2 Volume
100
MAINLINE VARCHAR2 Main Line: C, E, R
100
NUMBER_OF_TRAPS NUMBER Number of Traps used
100
Primary Key HAUL_DATE DATE Haul Date
100
AREA NUMBER Area of the catch
100
DEPTH NUMBER Depth of catch.
100
SOAK_TIME NUMBER Soak Time
100
WEIGHT NUMBER Estimated Catch Weight (in pounds)
100
SPECIES_CODE_NMFS VARCHAR2 NMFS Species Code

Attribute Details

SCHEDULE_NUMBER

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

Identifies the Trip

General Data Type: VARCHAR2

STRING

CC ID: 25110
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 2
Scale: 0
Status: Active
Description:

String used in the catch

General Data Type: NUMBER

SHAPE

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

Shape, Material, and Volume used in this catch

General Data Type: VARCHAR2

MATERIAL

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

Material

General Data Type: VARCHAR2

VOLUME

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

Volume

General Data Type: VARCHAR2

MAINLINE

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

Main Line: C, E, R

General Data Type: VARCHAR2

NUMBER_OF_TRAPS

CC ID: 25115
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of Traps used

General Data Type: NUMBER

HAUL_DATE

CC ID: 25116
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

Haul Date

General Data Type: DATE

AREA

CC ID: 25117
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Area of the catch

General Data Type: NUMBER

DEPTH

CC ID: 25118
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Depth of catch.

General Data Type: NUMBER

SOAK_TIME

CC ID: 25119
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Soak Time

General Data Type: NUMBER

WEIGHT

CC ID: 25120
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

Estimated Catch Weight (in pounds)

General Data Type: NUMBER

SPECIES_CODE_NMFS

CC ID: 25121
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

NMFS Species Code

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6877
GUID: gov.noaa.nmfs.inport:6877
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-20 10:28+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 Review Frequency: 1 Year