Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Historical Golden Crab Log Data Table

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None goldeb crab
None legacy data
None logbook

Entity Information

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

Historical Golden Crab Log Data Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SCHEDULE VARCHAR2 Identify a 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 NUMBER Dealer Code
100
DEAL2 NUMBER Dealer Code
100
DEAL3 NUMBER Dealer Code
100
DEAL4 NUMBER Dealer Code
100
DEAL5 NUMBER Dealer Code
100
DEAL6 NUMBER Dealer Code
100
COUNTY NUMBER County where it was unloaded
100
STATE NUMBER State where it was unloaded
100
SHAPE VARCHAR2 Values: R and B
100
MATERIAL VARCHAR2 Values R,B,W
100
VOLUME NUMBER An integer, but what is it and where it comes from
100
STRING NUMBER Is that a kind of consecutive?
100
MAIN VARCHAR2 Mainline C/R
100
GEAR VARCHAR2 Type of Trap used?
100
TRAPS NUMBER Number of Traps Used
100
HAUL DATE Haul Date
100
AREA NUMBER Area of what?
100
DEPTH NUMBER Depth of What?
100
SOAK NUMBER Soak Time
100
SPECIES NUMBER Species Code
100
WEIGHT NUMBER Catch Weight
100
INC_SPC NUMBER Incidental Species Code
100
INC_KEPT NUMBER Incidental Catch Kept (in Pounds)
100
INC_DISC NUMBER Incidental Catch Discarded (in Pounds)
100
REC DATE A certain date...
100
UP VARCHAR2 ????
100
COMMENTS VARCHAR2 Comments
100
DEALER1 VARCHAR2 First Dealer Who Bought Catch
100
DEALER2 VARCHAR2 Second Dealer Who Bought Catch
100
DEALER3 VARCHAR2 Thrid Dea;er Who bought catch
100
DEALER4 VARCHAR2 Fourth Dealer Who Bought Catch
100
DEALER5 VARCHAR2 Fifth Dealer Who bought catch
100
DEALER6 VARCHAR2 Sixth Dealer Who Bought Catch

Attribute Details

SCHEDULE

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

Identify a trip

General Data Type: VARCHAR2

VESID

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

Vessel ID

General Data Type: VARCHAR2

START_DATE

CC ID: 25160
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: 25161
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: 25162
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: 25163
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Dealer Code

General Data Type: NUMBER

DEAL2

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

Dealer Code

General Data Type: NUMBER

DEAL3

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

Dealer Code

General Data Type: NUMBER

DEAL4

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

Dealer Code

General Data Type: NUMBER

DEAL5

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

Dealer Code

General Data Type: NUMBER

DEAL6

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

Dealer Code

General Data Type: NUMBER

COUNTY

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

County where it was unloaded

General Data Type: NUMBER

STATE

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

State where it was unloaded

General Data Type: NUMBER

SHAPE

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

Values: R and B

General Data Type: VARCHAR2

MATERIAL

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

Values R,B,W

General Data Type: VARCHAR2

VOLUME

CC ID: 25173
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

An integer, but what is it and where it comes from

General Data Type: NUMBER

STRING

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

Is that a kind of consecutive?

General Data Type: NUMBER

MAIN

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

Mainline C/R

General Data Type: VARCHAR2

GEAR

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

Type of Trap used?

General Data Type: VARCHAR2

TRAPS

CC ID: 25177
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 Used

General Data Type: NUMBER

HAUL

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

Haul Date

General Data Type: DATE

AREA

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

Area of what?

General Data Type: NUMBER

DEPTH

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

Depth of What?

General Data Type: NUMBER

SOAK

CC ID: 25181
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

SPECIES

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

Species Code

General Data Type: NUMBER

WEIGHT

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

Catch Weight

General Data Type: NUMBER

INC_SPC

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

Incidental Species Code

General Data Type: NUMBER

INC_KEPT

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

Incidental Catch Kept (in Pounds)

General Data Type: NUMBER

INC_DISC

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

Incidental Catch Discarded (in Pounds)

General Data Type: NUMBER

REC

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

A certain date...

General Data Type: DATE

UP

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

????

General Data Type: VARCHAR2

COMMENTS

CC ID: 25189
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 36
Required: No
Primary Key: No
Status: Active
Description:

Comments

General Data Type: VARCHAR2

DEALER1

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

First Dealer Who Bought Catch

General Data Type: VARCHAR2

DEALER2

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

Second Dealer Who Bought Catch

General Data Type: VARCHAR2

DEALER3

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

Thrid Dea;er Who bought catch

General Data Type: VARCHAR2

DEALER4

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

Fourth Dealer Who Bought Catch

General Data Type: VARCHAR2

DEALER5

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

Fifth Dealer Who bought catch

General Data Type: VARCHAR2

DEALER6

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

Sixth Dealer Who Bought Catch

General Data Type: VARCHAR2

Catalog Details

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