Table: GSS_GULF_SHRIMP_06_09

Southeast Fisheries Science Center
Entity (ENT) | ID: 5514 | Published / External
Created: 2007-10-17   |   Last Modified: 2024-06-14

Parent: Gulf Shrimp System
Data Set (DS) | ID: 22119

ID: 5514
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: GSS_GULF_SHRIMP_06_09
Short Name GSS_GULF_SHRIMP_06_09
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

Table holding data from 2006 to 2009
* Purpose
Notes

Loaded by batch 1744, 10-17-2007 10:30
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
None pounds
None shrimp date
None value
   
   
   

Temporal Keywords

Thesaurus Keyword
None 2006-2009
   
   
   

* Spatial Keywords

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

Stratum Keywords

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

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name GSS
» Description

Table holding data from 2006 to 2009
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 No No PORT NUMBER Port of landing.
100 No No 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 No No STATE_VESSEL_ID VARCHAR2 Official State Boat Registration Number for boats that are registered as a state boat
100 No No DEPARTURE_MONTH NUMBER Trip Departure Month
100 No No DEPARTURE_DAY NUMBER Trip Departure Day
100 No No DEPARTURE_YEAR NUMBER Trip Departure Year. (4 character)
100 No No DEPARTURE_DATE_CONV DATE Departure Date as a Date value when it is possible to contsruct the date value.
100 No No UNLOAD_MONTH NUMBER Trip Unload Month
100 No No UNLOAD_DAY NUMBER Trip Unload Day
100 No No UNLOAD_YEAR NUMBER Trip Unload Year. (4 character)
100 No No UNLOAD_DATE_CONV DATE UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.
100 No No RIVER_CODE NUMBER Corresponds to first digit of the Water Body Code
100 No No GRID_CODE NUMBER Corresponds to the second and third positions of the Water Body Code
100 No No SHORE_CODE NUMBER Corresponds to the fourth position of the Water Body Code
100 No No DEPTH NUMBER Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH.
100 No No DAYS_FISHED NUMBER Number of days fished measured in 24 hours of fishing.
100 No No NUMBER_OF_TRIPS NUMBER Number of trips associated with the shrimp catch.
100 No No TYPE_OF_GRADING NUMBER Type of grading, whether done by box or machine.
100 No No SPECIES_CODE NUMBER Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS.
100 No No SIZE_CLASS_RANGE_BEGIN NUMBER Beginning of the size range.
100 No No SIZE_CLASS_RANGE_END NUMBER Ending of the size range.
100 No No POUNDS NUMBER Pounds of shrimp landed.
100 No No VALUE NUMBER Dollar value of shrimp landed.
100 No No AVERAGE_PRICE_PER_POUND NUMBER Average price per pound of shrimp.
100 No No CONDITION_OF_LANDING NUMBER Indicates whether the shrimp were landed with their heads on, off or a combination of the two.
100 No No RECORD_TYPE VARCHAR2 Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)
100 No No SCHEDULE_NUMBER NUMBER Number appearing on the GSS form.
100 No No DEALER_CODE VARCHAR2 Dealer code.
100 No No 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 No No DEPARTURE_PORT NUMBER Port of departure. Valid codes for this column can be found in the table GSS_PORTS_SE.
100 No No TRAWL_SIZE NUMBER Size of trawl head rope in feet.
100 No No NUMBER_OF_TRAWLS NUMBER Number of trawls pulled by vessel.
100 No No RETURN_DATE VARCHAR2 Date on which the vessel returned in character type, format MMDDYY.
100 No No RETURN_DATE_CONV DATE Date on which the vessel returned in DATE format.
100 No No NIGHT_EFFORT_HOURS NUMBER Hours of fishing effort at night (1830-0630)
100 No No NIGHT_EFFORT_BROWN NUMBER Night effort for brown shrimp.
100 No No NIGHT_EFFORT_PINK NUMBER Night effort for pink shrimp.
100 No No NIGHT_EFFORT_WHITE NUMBER Night effort for white shrimp.
100 No No NIGHT_EFFORT_OTHER NUMBER Night effort for all other species.
100 No No DAY_EFFORT_HOURS NUMBER Hours of fishing effort during the day (0630 - 1830.)
100 No No DAY_EFFORT_BROWN NUMBER Day effort for brown shrimp.
100 No No DAY_EFFORT_PINK NUMBER Day effort for pink shrimp.
100 No No DAY_EFFORT_WHITE NUMBER Day effort for white shrimp.
100 No No DAY_EFFORT_OTHER NUMBER Night effort for all other species.
100 No No NIGHT_DAY_EFFORT_HOURS NUMBER Fishing effort during night and day.
100 No No NIGHT_DAY_EFFORT_BROWN NUMBER Fishing effort during night and day for brown shrimp.
100 No No NIGHT_DAY_EFFORT_PINK NUMBER Fishing effort during night and day for pink shrimp.
100 No No NIGHT_DAY_EFFORT_WHITE NUMBER Fishing effort during night and day for white shrimp.
100 No No NIGHT_DAY_EFFORT_OTHER NUMBER Fishing effort during night and day for other species.
100 No No 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 No No 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 No No CREW NUMBER Number of crew members reported for the trip.
100 No No TEDS NUMBER Used to indicate whether TEDs where observed. This column is currently not used.
100 No No 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 No No SOURCE_FILE VARCHAR2 The data file containing this record that was loaded
100 No No TRIP_TICKET_NUMBER VARCHAR2 The state trip ticket number associated with this record. This was added in 2004
100 No No FORM_VERSION VARCHAR2 needed for trip identification (added 9/15/06)

Attribute Details

Attribute Name PORT
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 2
Scale 0
Status Active
Description

Port of landing.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name VESSEL_NUMBER
Seq. Order 2
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name STATE_VESSEL_ID
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Official State Boat Registration Number for boats that are registered as a state boat
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEPARTURE_MONTH
Seq. Order 4
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 2
Scale 0
Status Active
Description

Trip Departure Month
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEPARTURE_DAY
Seq. Order 5
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 2
Scale 0
Status Active
Description

Trip Departure Day
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEPARTURE_YEAR
Seq. Order 6
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 4
Scale 0
Status Active
Description

Trip Departure Year. (4 character)
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEPARTURE_DATE_CONV
Seq. Order 7
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Departure Date as a Date value when it is possible to contsruct the date value.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name UNLOAD_MONTH
Seq. Order 8
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 2
Scale 0
Status Active
Description

Trip Unload Month
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name UNLOAD_DAY
Seq. Order 9
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 2
Scale 0
Status Active
Description

Trip Unload Day
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name UNLOAD_YEAR
Seq. Order 10
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 4
Scale 0
Status Active
Description

Trip Unload Year. (4 character)
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name UNLOAD_DATE_CONV
Seq. Order 11
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RIVER_CODE
Seq. Order 12
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GRID_CODE
Seq. Order 13
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SHORE_CODE
Seq. Order 14
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEPTH
Seq. Order 15
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAYS_FISHED
Seq. Order 16
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMBER_OF_TRIPS
Seq. Order 17
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 3
Scale 0
Status Active
Description

Number of trips associated with the shrimp catch.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TYPE_OF_GRADING
Seq. Order 18
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SPECIES_CODE
Seq. Order 19
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_CLASS_RANGE_BEGIN
Seq. Order 20
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 3
Scale 0
Status Active
Description

Beginning of the size range.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_CLASS_RANGE_END
Seq. Order 21
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 3
Scale 0
Status Active
Description

Ending of the size range.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name POUNDS
Seq. Order 22
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 8
Scale 0
Status Active
Description

Pounds of shrimp landed.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name VALUE
Seq. Order 23
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 8
Scale 0
Status Active
Description

Dollar value of shrimp landed.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name AVERAGE_PRICE_PER_POUND
Seq. Order 24
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 6
Scale 2
Status Active
Description

Average price per pound of shrimp.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CONDITION_OF_LANDING
Seq. Order 25
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RECORD_TYPE
Seq. Order 26
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SCHEDULE_NUMBER
Seq. Order 27
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 4
Scale 0
Status Active
Description

Number appearing on the GSS form.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEALER_CODE
Seq. Order 28
Data Storage Type VARCHAR2
Max Length 9
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Dealer code.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OLD_DEALER_CODE
Seq. Order 29
Data Storage Type VARCHAR2
Max Length 9
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEPARTURE_PORT
Seq. Order 30
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRAWL_SIZE
Seq. Order 31
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 2
Scale 0
Status Active
Description

Size of trawl head rope in feet.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMBER_OF_TRAWLS
Seq. Order 32
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Number of trawls pulled by vessel.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RETURN_DATE
Seq. Order 33
Data Storage Type VARCHAR2
Max Length 8
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Date on which the vessel returned in character type, format MMDDYY.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RETURN_DATE_CONV
Seq. Order 34
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Date on which the vessel returned in DATE format.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_EFFORT_HOURS
Seq. Order 35
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 3
Scale 0
Status Active
Description

Hours of fishing effort at night (1830-0630)
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_EFFORT_BROWN
Seq. Order 36
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Night effort for brown shrimp.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_EFFORT_PINK
Seq. Order 37
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Night effort for pink shrimp.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_EFFORT_WHITE
Seq. Order 38
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Night effort for white shrimp.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_EFFORT_OTHER
Seq. Order 39
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Night effort for all other species.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAY_EFFORT_HOURS
Seq. Order 40
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAY_EFFORT_BROWN
Seq. Order 41
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Day effort for brown shrimp.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAY_EFFORT_PINK
Seq. Order 42
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Day effort for pink shrimp.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAY_EFFORT_WHITE
Seq. Order 43
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Day effort for white shrimp.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAY_EFFORT_OTHER
Seq. Order 44
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Night effort for all other species.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_DAY_EFFORT_HOURS
Seq. Order 45
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 3
Scale 0
Status Active
Description

Fishing effort during night and day.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_DAY_EFFORT_BROWN
Seq. Order 46
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_DAY_EFFORT_PINK
Seq. Order 47
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_DAY_EFFORT_WHITE
Seq. Order 48
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NIGHT_DAY_EFFORT_OTHER
Seq. Order 49
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GEAR_CODE
Seq. Order 50
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ADD_DELETE_CODE
Seq. Order 51
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREW
Seq. Order 52
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 1
Scale 0
Status Active
Description

Number of crew members reported for the trip.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TEDS
Seq. Order 53
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BLANK
Seq. Order 54
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SOURCE_FILE
Seq. Order 55
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The data file containing this record that was loaded
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRIP_TICKET_NUMBER
Seq. Order 56
Data Storage Type VARCHAR2
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The state trip ticket number associated with this record. This was added in 2004
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FORM_VERSION
Seq. Order 57
Data Storage Type VARCHAR2
Max Length 8
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

needed for trip identification (added 9/15/06)
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 5514
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 Workflow State Published / External
Metadata Last Review Date 2021-05-07
Metadata Review Frequency 1 Year
Metadata Next Review Date 2022-05-07
Tags