Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: GOLDEN_CRAB_V
Short Name: GOLDEN_CRAB_V
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 golden crab
None trip data
None view

Entity Information

Entity Type: Data View
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
SCHEDULE VARCHAR2 Identifies the Trip
100
VESID VARCHAR2 Vessel ID
100
START_DATE DATE Start Date
100
END_DATE DATE End Date
100
NOFISH DATE First day of a month this vessel did not fish
100
DEAL1 VARCHAR2 Dealer Code
100
DEAL2 VARCHAR2 Dealer Code
100
DEAL3 VARCHAR2 Dealer Code
100
DEAL4 VARCHAR2 Dealer Code
100
DEAL5 VARCHAR2 Dealer Code
100
DEAL6 VARCHAR2 Dealer Code
100
COUNTY VARCHAR2 NMFS County Code
100
STATE VARCHAR2 NMFS State Code
100
STRING NUMBER String used in the catch
100
SPECIES CHAR NMFS Species Code
100
SHAPE VARCHAR2 Shape, Material, and Volume used in this catch
100
MATERIAL VARCHAR2 Material
100
VOLUME VARCHAR2 Volume
100
MAIN VARCHAR2 Mainline Length
100
TRAPS NUMBER Number Of Traps
100
HAUL DATE Date Of Haul
100
AREA NUMBER Area of the catch
100
DEPTH NUMBER Depth of catch.
100
SOAK NUMBER Soak Time
100
WEIGHT NUMBER Estimated Catch Weight (in pounds)
100
INC_SPC VARCHAR2 Incidental Sprcies Code
100
INC_KEPT NUMBER Number Of Incidental Animal Kept
100
INC_DISC NUMBER Number Of Incidental Animal Discarded

Attribute Details

SCHEDULE

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

Identifies the Trip

General Data Type: VARCHAR2

VESID

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

Vessel ID

General Data Type: VARCHAR2

START_DATE

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

Start Date

General Data Type: DATE

END_DATE

CC ID: 25218
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

End Date

General Data Type: DATE

NOFISH

CC ID: 25220
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

First day of a month this vessel did not fish

General Data Type: DATE

DEAL1

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

Dealer Code

General Data Type: VARCHAR2

DEAL2

CC ID: 25203
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Dealer Code

General Data Type: VARCHAR2

DEAL3

CC ID: 25205
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Dealer Code

General Data Type: VARCHAR2

DEAL4

CC ID: 25206
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Dealer Code

General Data Type: VARCHAR2

DEAL5

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

Dealer Code

General Data Type: VARCHAR2

DEAL6

CC ID: 25201
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Dealer Code

General Data Type: VARCHAR2

COUNTY

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

NMFS County Code

General Data Type: VARCHAR2

STATE

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

NMFS State Code

General Data Type: VARCHAR2

STRING

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

String used in the catch

General Data Type: NUMBER

SPECIES

CC ID: 25199
Seq. Order: 15
Data Storage Type: CHAR
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

NMFS Species Code

General Data Type: CHAR

SHAPE

CC ID: 25212
Seq. Order: 16
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: 25217
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Material

General Data Type: VARCHAR2

VOLUME

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

Volume

General Data Type: VARCHAR2

MAIN

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

Mainline Length

General Data Type: VARCHAR2

TRAPS

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

Number Of Traps

General Data Type: NUMBER

HAUL

CC ID: 25207
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Of Haul

General Data Type: DATE

AREA

CC ID: 25197
Seq. Order: 22
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: 25202
Seq. Order: 23
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

CC ID: 25221
Seq. Order: 24
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: 25200
Seq. Order: 25
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

INC_SPC

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

Incidental Sprcies Code

General Data Type: VARCHAR2

INC_KEPT

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

Number Of Incidental Animal Kept

General Data Type: NUMBER

INC_DISC

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

Number Of Incidental Animal Discarded

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6883
GUID: gov.noaa.nmfs.inport:6883
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