Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > Fisheries Sampling Branch > Gulf shrimp system > Gulf Shrimp System >

Table: GSS_GULF_SHRIMP_90_95

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5517  |  Updated: June 14, 2024  |  Published / External 
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