Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Holds data about Incidental catches in golden crab trips

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None golden crab
None inceidental take

Entity Information

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

Holds data about Incidental catches 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 to fish
100
Primary Key HAUL_DATE DATE Date Of Haul
100
Primary Key SPECIES_CODE_NMFS VARCHAR2 Species code of the Incidental catch
100
KEPT NUMBER Incidental Catch Kept ( an estimation in pounds)
100
DISCARDED NUMBER Incidental catch discarded (an estimation in pound)

Attribute Details

SCHEDULE_NUMBER

CC ID: 25152
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: 25153
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 2
Scale: 0
Status: Active
Description:

String used to fish

General Data Type: NUMBER

HAUL_DATE

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

Date Of Haul

General Data Type: DATE

SPECIES_CODE_NMFS

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

Species code of the Incidental catch

General Data Type: VARCHAR2

KEPT

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

Incidental Catch Kept ( an estimation in pounds)

General Data Type: NUMBER

DISCARDED

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

Incidental catch discarded (an estimation in pound)

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6881
GUID: gov.noaa.nmfs.inport:6881
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 Next Review Date: 2022-05-07