Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table holding data from 1990 to 1995

Description

Table holding data from 1990 to 1995

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PORT
NUMBER
Port of landing.
VESSEL_NUMBER
NUMBER
Official Coast Guard Vessel Number. This column may also contain a number other than a vessel id, in which case the record represents consolidated trips. For consolidated trips, the first four characters of the VESSEL_NUMBER are 9s, the fifth character
STATE_VESSEL_ID
VARCHAR2
Official State Boat Registration Number for boats that are registered as a state boat
DEPARTURE_MONTH
NUMBER
Trip Departure Month
DEPARTURE_DAY
NUMBER
Trip Departure Day
DEPARTURE_YEAR
NUMBER
Trip Departure Year. (4 character)
DEPARTURE_DATE_CONV
DATE
Departure Date as a Date value when it is possible to contsruct the date value.
UNLOAD_MONTH
NUMBER
Trip Unload Month
UNLOAD_DAY
NUMBER
Trip Unload Day
UNLOAD_YEAR
NUMBER
Trip Unload Year. (4 character)
UNLOAD_DATE_CONV
DATE
UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.
RIVER_CODE
NUMBER
Corresponds to first digit of the Water Body Code
GRID_CODE
NUMBER
Corresponds to the second and third positions of the Water Body Code
SHORE_CODE
NUMBER
Corresponds to the fourth position of the Water Body Code
DEPTH
NUMBER
Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH.
DAYS_FISHED
NUMBER
Number of days fished measured in 24 hours of fishing.
NUMBER_OF_TRIPS
NUMBER
Number of trips associated with the shrimp catch.
TYPE_OF_GRADING
NUMBER
Type of grading, whether done by box or machine.
SPECIES_CODE
NUMBER
Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS.
SIZE_CLASS_RANGE_BEGIN
NUMBER
Beginning of the size range.
SIZE_CLASS_RANGE_END
NUMBER
Ending of the size range.
POUNDS
NUMBER
Pounds of shrimp landed.
VALUE
NUMBER
Dollar value of shrimp landed.
AVERAGE_PRICE_PER_POUND
NUMBER
Average price per pound of shrimp.
CONDITION_OF_LANDING
NUMBER
Indicates whether the shrimp were landed with their heads on, off or a combination of the two.
RECORD_TYPE
VARCHAR2
Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)
SCHEDULE_NUMBER
NUMBER
Number appearing on the GSS form.
DEALER_CODE
VARCHAR2
Dealer code.
DEPARTURE_PORT
NUMBER
Port of departure. Valid codes for this column can be found in the table GSS_PORTS_SE.
TRAWL_SIZE
NUMBER
Size of trawl head rope in feet.
NUMBER_OF_TRAWLS
NUMBER
Number of trawls pulled by vessel.
RETURN_DATE
VARCHAR2
Date on which the vessel returned in character type, format MMDDYY.
RETURN_DATE_CONV
DATE
Date on which the vessel returned in DATE format.
NIGHT_EFFORT_HOURS
NUMBER
Hours of fishing effort at night (1830-0630)
NIGHT_EFFORT_BROWN
NUMBER
Night effort for brown shrimp.
NIGHT_EFFORT_PINK
NUMBER
Night effort for pink shrimp.
NIGHT_EFFORT_WHITE
NUMBER
Night effort for white shrimp.
NIGHT_EFFORT_OTHER
NUMBER
Night effort for all other species.
DAY_EFFORT_HOURS
NUMBER
Hours of fishing effort during the day (0630 - 1830.)
DAY_EFFORT_BROWN
NUMBER
Day effort for brown shrimp.
DAY_EFFORT_PINK
NUMBER
Day effort for pink shrimp.
DAY_EFFORT_WHITE
NUMBER
Day effort for white shrimp.
DAY_EFFORT_OTHER
NUMBER
Night effort for all other species.
NIGHT_DAY_EFFORT_HOURS
NUMBER
Fishing effort during night and day.
NIGHT_DAY_EFFORT_BROWN
NUMBER
Fishing effort during night and day for brown shrimp.
NIGHT_DAY_EFFORT_PINK
NUMBER
Fishing effort during night and day for pink shrimp.
NIGHT_DAY_EFFORT_WHITE
NUMBER
Fishing effort during night and day for white shrimp.
NIGHT_DAY_EFFORT_OTHER
NUMBER
Fishing effort during night and day for other species.
GEAR_CODE
NUMBER
Type of gear used during fishing trip. A list of valid gear codes can be found in GEAR_CODE_GSS (GSS_GEARS.)
ADD_DELETE_CODE
VARCHAR2
Code used to indicate whether rows should be added or deleted. This column is no longer used and is being kept for historical reasons. It will be removed in the future.
CREW
NUMBER
Number of crew members reported for the trip.
TEDS
NUMBER
Used to indicate whether TEDs where observed. This column is currently not used.
BLANK
VARCHAR2
A column that represents a blank space in the historical records. These "blank" columns will be kept until the historical data have been reviewed because there have been cases were unidentified information were found.
SOURCE_FILE
VARCHAR2
The data file containing this record that was loaded
TRIP_TICKET_NUMBER
VARCHAR2
The state trip ticket number associated with this record. This was added in 2004
OLD_DEALER_CODE
VARCHAR2
Keeps The old Dealer Code that was on the record prior to the changing of Dealer Codes which was done in 2001
FORM_VERSION
VARCHAR2
needed for trip identification (added 9/15/06)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

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

Table holding data from 1990 to 1995

Notes:

Loaded by batch 1744, 10-17-2007 10:30

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None pounds
None shrimp date
None value

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 1990-1995

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Alabama
None Florida
None Gulf Coast
None Louisiana
None Mississippi
None Texas

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None dealer
None gear
None grade
None species
None year.month

Entity Information

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

Table holding data from 1990 to 1995

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
PORT NUMBER Port of landing.
100
VESSEL_NUMBER NUMBER Official Coast Guard Vessel Number. This column may also contain a number other than a vessel id, in which case the record represents consolidated trips. For consolidated trips, the first four characters of the VESSEL_NUMBER are 9s, the fifth character
100
STATE_VESSEL_ID VARCHAR2 Official State Boat Registration Number for boats that are registered as a state boat
100
DEPARTURE_MONTH NUMBER Trip Departure Month
100
DEPARTURE_DAY NUMBER Trip Departure Day
100
DEPARTURE_YEAR NUMBER Trip Departure Year. (4 character)
100
DEPARTURE_DATE_CONV DATE Departure Date as a Date value when it is possible to contsruct the date value.
100
UNLOAD_MONTH NUMBER Trip Unload Month
100
UNLOAD_DAY NUMBER Trip Unload Day
100
UNLOAD_YEAR NUMBER Trip Unload Year. (4 character)
100
UNLOAD_DATE_CONV DATE UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.
100
RIVER_CODE NUMBER Corresponds to first digit of the Water Body Code
100
GRID_CODE NUMBER Corresponds to the second and third positions of the Water Body Code
100
SHORE_CODE NUMBER Corresponds to the fourth position of the Water Body Code
100
DEPTH NUMBER Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH.
100
DAYS_FISHED NUMBER Number of days fished measured in 24 hours of fishing.
100
NUMBER_OF_TRIPS NUMBER Number of trips associated with the shrimp catch.
100
TYPE_OF_GRADING NUMBER Type of grading, whether done by box or machine.
100
SPECIES_CODE NUMBER Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS.
100
SIZE_CLASS_RANGE_BEGIN NUMBER Beginning of the size range.
100
SIZE_CLASS_RANGE_END NUMBER Ending of the size range.
100
POUNDS NUMBER Pounds of shrimp landed.
100
VALUE NUMBER Dollar value of shrimp landed.
100
AVERAGE_PRICE_PER_POUND NUMBER Average price per pound of shrimp.
100
CONDITION_OF_LANDING NUMBER Indicates whether the shrimp were landed with their heads on, off or a combination of the two.
100
RECORD_TYPE VARCHAR2 Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)
100
SCHEDULE_NUMBER NUMBER Number appearing on the GSS form.
100
DEALER_CODE VARCHAR2 Dealer code.
100
DEPARTURE_PORT NUMBER Port of departure. Valid codes for this column can be found in the table GSS_PORTS_SE.
100
TRAWL_SIZE NUMBER Size of trawl head rope in feet.
100
NUMBER_OF_TRAWLS NUMBER Number of trawls pulled by vessel.
100
RETURN_DATE VARCHAR2 Date on which the vessel returned in character type, format MMDDYY.
100
RETURN_DATE_CONV DATE Date on which the vessel returned in DATE format.
100
NIGHT_EFFORT_HOURS NUMBER Hours of fishing effort at night (1830-0630)
100
NIGHT_EFFORT_BROWN NUMBER Night effort for brown shrimp.
100
NIGHT_EFFORT_PINK NUMBER Night effort for pink shrimp.
100
NIGHT_EFFORT_WHITE NUMBER Night effort for white shrimp.
100
NIGHT_EFFORT_OTHER NUMBER Night effort for all other species.
100
DAY_EFFORT_HOURS NUMBER Hours of fishing effort during the day (0630 - 1830.)
100
DAY_EFFORT_BROWN NUMBER Day effort for brown shrimp.
100
DAY_EFFORT_PINK NUMBER Day effort for pink shrimp.
100
DAY_EFFORT_WHITE NUMBER Day effort for white shrimp.
100
DAY_EFFORT_OTHER NUMBER Night effort for all other species.
100
NIGHT_DAY_EFFORT_HOURS NUMBER Fishing effort during night and day.
100
NIGHT_DAY_EFFORT_BROWN NUMBER Fishing effort during night and day for brown shrimp.
100
NIGHT_DAY_EFFORT_PINK NUMBER Fishing effort during night and day for pink shrimp.
100
NIGHT_DAY_EFFORT_WHITE NUMBER Fishing effort during night and day for white shrimp.
100
NIGHT_DAY_EFFORT_OTHER NUMBER Fishing effort during night and day for other species.
100
GEAR_CODE NUMBER Type of gear used during fishing trip. A list of valid gear codes can be found in GEAR_CODE_GSS (GSS_GEARS.)
100
ADD_DELETE_CODE VARCHAR2 Code used to indicate whether rows should be added or deleted. This column is no longer used and is being kept for historical reasons. It will be removed in the future.
100
CREW NUMBER Number of crew members reported for the trip.
100
TEDS NUMBER Used to indicate whether TEDs where observed. This column is currently not used.
100
BLANK VARCHAR2 A column that represents a blank space in the historical records. These "blank" columns will be kept until the historical data have been reviewed because there have been cases were unidentified information were found.
100
SOURCE_FILE VARCHAR2 The data file containing this record that was loaded
100
TRIP_TICKET_NUMBER VARCHAR2 The state trip ticket number associated with this record. This was added in 2004
100
OLD_DEALER_CODE VARCHAR2 Keeps The old Dealer Code that was on the record prior to the changing of Dealer Codes which was done in 2001
100
FORM_VERSION VARCHAR2 needed for trip identification (added 9/15/06)

Attribute Details

PORT

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

Port of landing.

General Data Type: NUMBER

VESSEL_NUMBER

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

Official Coast Guard Vessel Number. This column may also contain a number other than a vessel id, in which case the record represents consolidated trips. For consolidated trips, the first four characters of the VESSEL_NUMBER are 9s, the fifth character

General Data Type: NUMBER

STATE_VESSEL_ID

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

Official State Boat Registration Number for boats that are registered as a state boat

General Data Type: VARCHAR2

DEPARTURE_MONTH

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

Trip Departure Month

General Data Type: NUMBER

DEPARTURE_DAY

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

Trip Departure Day

General Data Type: NUMBER

DEPARTURE_YEAR

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

Trip Departure Year. (4 character)

General Data Type: NUMBER

DEPARTURE_DATE_CONV

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

Departure Date as a Date value when it is possible to contsruct the date value.

General Data Type: DATE

UNLOAD_MONTH

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

Trip Unload Month

General Data Type: NUMBER

UNLOAD_DAY

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

Trip Unload Day

General Data Type: NUMBER

UNLOAD_YEAR

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

Trip Unload Year. (4 character)

General Data Type: NUMBER

UNLOAD_DATE_CONV

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

UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.

General Data Type: DATE

RIVER_CODE

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

Corresponds to first digit of the Water Body Code

General Data Type: NUMBER

GRID_CODE

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

Corresponds to the second and third positions of the Water Body Code

General Data Type: NUMBER

SHORE_CODE

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

Corresponds to the fourth position of the Water Body Code

General Data Type: NUMBER

DEPTH

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

Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH.

General Data Type: NUMBER

DAYS_FISHED

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

Number of days fished measured in 24 hours of fishing.

General Data Type: NUMBER

NUMBER_OF_TRIPS

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

Number of trips associated with the shrimp catch.

General Data Type: NUMBER

TYPE_OF_GRADING

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

Type of grading, whether done by box or machine.

General Data Type: NUMBER

SPECIES_CODE

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

Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS.

General Data Type: NUMBER

SIZE_CLASS_RANGE_BEGIN

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

Beginning of the size range.

General Data Type: NUMBER

SIZE_CLASS_RANGE_END

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

Ending of the size range.

General Data Type: NUMBER

POUNDS

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

Pounds of shrimp landed.

General Data Type: NUMBER

VALUE

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

Dollar value of shrimp landed.

General Data Type: NUMBER

AVERAGE_PRICE_PER_POUND

CC ID: 17906
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Average price per pound of shrimp.

General Data Type: NUMBER

CONDITION_OF_LANDING

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

Indicates whether the shrimp were landed with their heads on, off or a combination of the two.

General Data Type: NUMBER

RECORD_TYPE

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

Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)

General Data Type: VARCHAR2

SCHEDULE_NUMBER

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

Number appearing on the GSS form.

General Data Type: NUMBER

DEALER_CODE

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

Dealer code.

General Data Type: VARCHAR2

DEPARTURE_PORT

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

Port of departure. Valid codes for this column can be found in the table GSS_PORTS_SE.

General Data Type: NUMBER

TRAWL_SIZE

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

Size of trawl head rope in feet.

General Data Type: NUMBER

NUMBER_OF_TRAWLS

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

Number of trawls pulled by vessel.

General Data Type: NUMBER

RETURN_DATE

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

Date on which the vessel returned in character type, format MMDDYY.

General Data Type: VARCHAR2

RETURN_DATE_CONV

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

Date on which the vessel returned in DATE format.

General Data Type: DATE

NIGHT_EFFORT_HOURS

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

Hours of fishing effort at night (1830-0630)

General Data Type: NUMBER

NIGHT_EFFORT_BROWN

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

Night effort for brown shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_PINK

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

Night effort for pink shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_WHITE

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

Night effort for white shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_OTHER

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

Night effort for all other species.

General Data Type: NUMBER

DAY_EFFORT_HOURS

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

Hours of fishing effort during the day (0630 - 1830.)

General Data Type: NUMBER

DAY_EFFORT_BROWN

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

Day effort for brown shrimp.

General Data Type: NUMBER

DAY_EFFORT_PINK

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

Day effort for pink shrimp.

General Data Type: NUMBER

DAY_EFFORT_WHITE

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

Day effort for white shrimp.

General Data Type: NUMBER

DAY_EFFORT_OTHER

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

Night effort for all other species.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_HOURS

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

Fishing effort during night and day.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_BROWN

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

Fishing effort during night and day for brown shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_PINK

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

Fishing effort during night and day for pink shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_WHITE

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

Fishing effort during night and day for white shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_OTHER

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

Fishing effort during night and day for other species.

General Data Type: NUMBER

GEAR_CODE

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

Type of gear used during fishing trip. A list of valid gear codes can be found in GEAR_CODE_GSS (GSS_GEARS.)

General Data Type: NUMBER

ADD_DELETE_CODE

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

Code used to indicate whether rows should be added or deleted. This column is no longer used and is being kept for historical reasons. It will be removed in the future.

General Data Type: VARCHAR2

CREW

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

Number of crew members reported for the trip.

General Data Type: NUMBER

TEDS

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

Used to indicate whether TEDs where observed. This column is currently not used.

General Data Type: NUMBER

BLANK

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

A column that represents a blank space in the historical records. These "blank" columns will be kept until the historical data have been reviewed because there have been cases were unidentified information were found.

General Data Type: VARCHAR2

SOURCE_FILE

CC ID: 17876
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The data file containing this record that was loaded

General Data Type: VARCHAR2

TRIP_TICKET_NUMBER

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

The state trip ticket number associated with this record. This was added in 2004

General Data Type: VARCHAR2

OLD_DEALER_CODE

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

Keeps The old Dealer Code that was on the record prior to the changing of Dealer Codes which was done in 2001

General Data Type: VARCHAR2

FORM_VERSION

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

needed for trip identification (added 9/15/06)

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5517
GUID: gov.noaa.nmfs.inport:5517
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 10:30+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2024-06-14 14:05+0000
Metadata Record Published: 2024-06-14
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07