Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBSTG

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33574  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Scallop Trawl Gear Characteristics from standard observer trips

Description

Observer Scallop Trawl Gear Characteristics from standard observer trips

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LINK4
VARCHAR2 		Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
LINK1
VARCHAR2 		15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
PROGRAM
VARCHAR2 		First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR
VARCHAR2 		Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH
VARCHAR2 		Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID
VARCHAR2 		May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
GEARNUM
VARCHAR2 		Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
DEPLOYED
VARCHAR2 		Position where gear deployed: port, starboard, both or aft
NETSCON
VARCHAR2 		If nets connected where two nets deployed on scallop or twin trawl; 1 = yes, 0 = no Collected for ASM where applicable.
NETNAMEP
VARCHAR2 		Coded identifier for name of port or aft deployed net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
NETNAMES
VARCHAR2 		Coded identifier for name of starboard deployed net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
NETTYPEP
VARCHAR2 		Coded identifier for type of port or aft deployed trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
NETTYPES
VARCHAR2 		Coded identifier for type of starboard deployed trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
NETBUILDERP
VARCHAR2 		Coded identifier for builder net for port or aft gear See OBNETBUILDER table.(collected stg beginning 01/2008)
NETBUILDERS
VARCHAR2 		Coded identifier for builder net for starboard gear See OBNETBUILDER table.(stg beginning 01/2008)
DOORUSDP
VARCHAR2 		Door used on port net 0=no, 1=yes, 9 = unknown.
DOORUSDS
VARCHAR2 		Door used on starboard net: 0=no, 1=yes, 9 = unknown.
DOORWGTP
NUMBER 		Weight of one door used on port net in whole kilograms. null if unknown or not used
DOORWGTS
NUMBER 		Weight of one door used on starboard net in whole kilograms. Null if unknown or not used
NEGEAR
VARCHAR2 		Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
NETMATP
VARCHAR2 		Material used in body of port side scallop net not including codend. See OBNETMAT table.
NETMATS
VARCHAR2 		Material used in body of starboard side scallp net not including codend. See OBNETMAT table.
CODMATP
VARCHAR2 		Type of construction material used in codend port side. See OBNETMAT table.
CODMATS
VARCHAR2 		Type of construction material used in codend starboard side. See OBNETMAT table.
BRDTPLENP
NUMBER 		Length of top bridle, in whole fathoms, port or aft deployed
BRDTPLENS
NUMBER 		Length of top bridle, in whole fathoms, starboard deployed
HDROPLENP
NUMBER 		Length of head rope on port net, in feet
HDROPLENS
NUMBER 		Length of head rope on starboard net, in feet
FTROPLENP
NUMBER 		Length of rope along bottom of port net in whole feet.
FTROPLENS
NUMBER 		Length of rope along bottom of starboard net in whole feet.
GRCABLENP
NUMBER 		Length of wire connecting the bridles and back strap on port net in whole feet.
GRCABLENS
NUMBER 		Length of wire connecting the bridles and back strap on starboard net in whole feet.
CIRCLEMCP
NUMBER 		Number of meshes in fishing circle on port net.
CIRCLEMCS
NUMBER 		Number of meshes in fishing circle on starboard net.
CIRCLEMSP
NUMBER 		Inside mesh measurement from port net fishing circle; nearest 1/10 inch.
CIRCLEMSS
NUMBER 		Inside mesh measurement from starboard net fishing circle; nearest 1/10.
GRCABTYPP
VARCHAR2 		Gear type on port ground cable 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
GRCABTYPS
VARCHAR2 		Gear type on starboard ground cable 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
BRDLGTYPP
VARCHAR2 		Gear type making up port bridles/legs 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
BRDLGTYPS
VARCHAR2 		Gear type on starboard bridles/legs, and footrope. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
FTROPTYPP
VARCHAR2 		Gear type on port footrope/sweep. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
FTROPTYPS
VARCHAR2 		Gear type on starboard footrope/sweepp. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
NSWEEPSP
NUMBER 		Total number of the largest piecce of gear present on the port net sweep /footrope (rollers, rock hoppers). Null if sweep is chain or cable/wire or or aft
SWEEPDIAP
NUMBER 		The diameter in whole inches of the largest piece of gear present on the sweep / footrope on the port or aft net; null if sweep is chain or cable/wire or wrapped
NSWEEPSS
NUMBER 		Total number of the largest piecce of gear present on the starboard net sweep / footrope(rollers, rock hoppers). Null if sweep is chain or cable/wire
SWEEPDIAS
NUMBER 		The diameter in whole inches of the largest piece of gear present on the sweep /footrope on the starboard net; null if sweep is chain or cable/wire or wrapped
NFLOATSP
NUMBER 		Number of floats on port gear
NFLOATSS
NUMBER 		Number of floats on starboard gear
FLOATDIAP
NUMBER 		Diameter in whole inches of majority of floats attached to port net headrope.
FLOATDIAS
NUMBER 		Diameter in whole inches of majority of floats attached to starboard net headrope.
CODHUNGP
VARCHAR2 		Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable.
CODHUNGS
VARCHAR2 		Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable.
CODTWINETYPP
VARCHAR2 		Single or double twine used in port codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable.
CODTWINETYPS
VARCHAR2 		Single or double twine used in starboard codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable.
CODMSIZEP
NUMBER 		Ten randomly selected inside mesh measurements from port net codend; whole millimeters Collected for ASM where applicable.
CODMSIZES
NUMBER 		Ten randomly selected inside mesh measurements from starboard net codend; whole millimeters Collected for ASM where applicable.
CODLINERUSDP
VARCHAR2 		Liner used on port net codend: 0=no, 1=yes, 9=unknown Collected for ASM where applicable.
CODLINERUSDS
VARCHAR2 		Liner used on starboard net codene: 0=no, 1=yes, 9= unknown Collected for ASM where applicable.
CODSTRENUSDP
VARCHAR2 		Strengthener meterial used in codend of port net; 0=no, 1=yes, 9=unknown
LINERMSIZEP
NUMBER 		Truncated average of ten randomly selected inside liner whole millimeter measurements for port net location. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
LINERMSIZES
NUMBER 		Truncated average of ten randomly selected inside liner whole millimeter measurements for starboard net location. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
LINERMATP
VARCHAR2 		Type of construction material used in liner for port net location. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
LINERMATS
VARCHAR2 		Type of construction material used in liner for starboard net location. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
LINERHUNGP
VARCHAR2 		Hanging configuration of liner for port net location. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
LINERHUNGS
VARCHAR2 		Hanging configuration of liner for starboard net location. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
LINERTWTYPP
VARCHAR2 		Single or double twine used in liner for port net location. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
LINERTWTYPS
VARCHAR2 		Single or double twine used in liner for starboard net location. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
KITPNUSDP
VARCHAR2 		Indicator of whether kite panel used on port or aft depoyed gear added 1-08
KITPNUSDS
VARCHAR2 		Indicator of whether kite panel used on starboard depoyed gear added 1-08
NKITPNP
NUMBER 		Total number of panels used in kite in port or aft deployed net.| added 1-08
NKITPNS
NUMBER 		Total number of panels used in kite in starboard net.| added 1-08
KITPNLENP
NUMBER 		Average length of panels used in kite in port or aft deployed net, in whole inches.
KITPNLENS
NUMBER 		Average length of panels used in kite in starboard deployed net, in whole inches.
KITPNWIDP
NUMBER 		Average width of panels used in kite in port or aft deployed net, in whole inches.| added 1-08
KITPNWIDS
NUMBER 		Average width of panels used in kite in starboard deployed net, in whole inches.| added 1-08
CODSTRENUSDS
VARCHAR2 		Strengthener material used in codend of starboard net; 0=no, 1=yes, 9=unknown
CODCHAFFUSDP
VARCHAR2 		Chaffing gear used on port codend. 0=no, 1=yes, 9=unknown.
CODCHAFFUSDS
VARCHAR2 		Chaffing gear used on starboard codend. 0=no, 1=yes, 9=unknown.
GMELECTSUSDP
VARCHAR2 		Whether transducers used on port net: 0=no, 1=yes, 9=unknown
GMELECTSUSDS
VARCHAR2 		Whether transducers used on starboard net: 0=no, 1=yes, 9=unknown
NTRANSP
NUMBER 		Number of transducers used on port gear. unknown: null; null if not used
NTRANSS
NUMBER 		Number of transducers on starboard gear. Unknown: null; null if not used
TRANSTYPP
VARCHAR2 		Type of transducers used. 0=unknown, 1=wired, 2=wireless,3 = Both
TRANSTYPS
VARCHAR2 		Type of transducers used: 0=unknown, 1=wired, 2=wireless, 3 = Both
TRANSBRDP
VARCHAR2 		Code for brand of port side transducers: 0=unknown, 1=Furuno, 2=Simrad 9=other , 3 = Furuno/Simrad combination 9 = other
TRANSBRDS
VARCHAR2 		Code for brand of starboard side transducers: 0= unkno1n, 1=Furuno, 2=Simrad , 3 = Furuno/Simrad combination , 9=other
TRANSLOCSTRP
VARCHAR2 		Location of transducers used on port gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
TRANSLOCSTRS
VARCHAR2 		Location of transducers used on starboard gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
EXCLUSDP
VARCHAR2 		Excluder or separators ddevice used on port net: 0=no, 1=yes, 9=unknown. Collected for ASM where applicable.
EXCLUSDS
VARCHAR2 		Excluder or separators devide used on starboard net: 0=no, 1=yes, 9= unknown. Collected for ASM where applicable.
EXCLTYPP
VARCHAR2 		Type of excluder or separator device used on gear. 0=unknown, 1 = nordmore grate, 2 = T.E.D., 3 = separtor panel, 4 = guiding device, 8 = combo, 9 = other.
EXCLTYPS
VARCHAR2 		Type of excluder or separator device used on gear. 0=unknown, 1 = nordmore grate, 2 = T.E.D., 3 = separtor panel, 4 = guiding device, 8 = combo, 9 = other.
ESCAPOUTUSDP
VARCHAR2 		Indicator of whether fish outlet was used on gear. 0 = no, 1 = yes, 9 = unknown. Not entered prior to 5/1994;set to unknown. FSOUTUSD before 3/2007 Collected for ASM where applicable.
ESCAPOUTUSDS
VARCHAR2 		Indicator of whether fish outlet was used on gear. 0 = no, 1 = yes, 9 = unknown. Not entered prior to 5/1994;set to unknown. FSOUTUSD before 3/2007 Collected for ASM where applicable.
ESCAPOUTLENP
NUMBER 		Length of fish outlet from front to back of net, in whole inches. Not collected before 5/1994; set to unknown. Previous 3/2007: fsoutlen
ESCAPOUTLENS
NUMBER 		Length of fish outlet from front to back of net, in whole inches. Not collected before 5/1994; set to unknown. Previous 3/2007: fsoutlen
ESCAPOUTWIDP
NUMBER 		Width of fish outlet, from side to side of net, in whole inches. Not collected prior to 5/1994; set to unknown. Pre 2/2007: fsoutwid
ESCAPOUTWIDS
NUMBER 		Width of fish outlet, from side to side of net, in whole inches. Not collected prior to 5/1994; set to unknown. Pre 2/2007: fsoutwid
ESCAPOUTSHPP
VARCHAR2 		Shape of escape outlet used on gear. 00 = unknown, 01 = rectangle, 06 = square , 07 = diamond, 08 = diamond, 99 = other. Not entered prior to 5/1994; set to unknown.fsoutshp prior 3/2007
ESCAPOUTSHPS
VARCHAR2 		Shape of escape outlet used on gear. 00 = unknown, 01 = rectangle, 06 = square , 07 = diamond, 08 = diamond, 99 = other. Not entered prior to 5/1994; set to unknown.fsoutshp prior 3/2007
ESCAPOUTLOCP
VARCHAR2 		Location of escape outlet on gear. 0 = unknown, 1 = top, 2 = bottom, 3 = side, 8 = combo, 9 = other. Not entered before 5/1994; set to unknown.FSOUTLOC PRIOR 3/2007
ESCAPOUTLOCS
VARCHAR2 		Location of escape outlet on gear. 0 = unknown, 1 = top, 2 = bottom, 3 = side, 8 = combo, 9 = other. Not entered before 5/1994; set to unknown.FSOUTLOC PRIOR 3/2007
ESCAPOUTTYPP
VARCHAR2 		Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
ESCAPOUTTYPS
VARCHAR2 		Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
ESCAPOUTMSP
NUMBER 		Mesh size of the escape outlet in whole inches.
ESCAPOUTMSS
NUMBER 		Mesh size of the escape outlet in whole inches.
TEDEXTMSP
NUMBER 		Turtle exclusion device extension mesh size port or aft gear in tenths of inches (begun 1/2008)
TEDEXTMSS
NUMBER 		Turtle exclusion device extension mesh size starboard gear in tenths of inches (begun 3/2007)
TEDEXTMSTYPP
VARCHAR2 		Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE for port net location is an actual or estimated value A = actual, E = estimated. Collected beginning with obdbs Version 10 (01/01/2011).
TEDEXTMSTYPS
VARCHAR2 		Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE for starboard net locationis an actual or estimated value A = actual, E = estimated. Collected beginning with obdbs Version 10 (01/01/2011).
ESCAPOUTLENMCP
NUMBER 		Number of meshes in length of the escape outlet (front -> codend)
ESCAPOUTLENMCS
NUMBER 		Number of meshes in length of the escape outlet (front -> codend)
ESCAPOUTWIDMCP
NUMBER 		Number of meshes in width of the escape outlet (side -> side)
ESCAPOUTWIDMCS
NUMBER 		Number of meshes in width of the escape outlet (side -> side)
STGCOMMENTSS
VARCHAR2 		Comments on scallop trawl gear deployed to starboard
STGCOMMENTSP
VARCHAR2 		Comments on scallop trawl gear deployed to port or aft
DOE
DATE 		Date of Entry of the associated record.
UOE
VARCHAR2 		Oracle user ID of the person who entered the data.
DOC
DATE 		Date associated record was updated.
UOC
VARCHAR2 		Oracle ID of user who made the (most recent ) change on the record.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: View: OBSTG
Short Name: OBSTG
Status: Completed
Abstract:

Observer Scallop Trawl Gear Characteristics from standard observer trips
Notes:

Loaded by batch 9053, 07-27-2016 19:10

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: OBDBS
Description:

Observer Scallop Trawl Gear Characteristics from standard observer trips

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 LINK4 VARCHAR2 Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
100
 LINK1 VARCHAR2 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
100
 PROGRAM VARCHAR2 First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100
 YEAR VARCHAR2 Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100
 MONTH VARCHAR2 Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100
 TRIPID VARCHAR2 May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
100
 GEARNUM VARCHAR2 Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100
 DEPLOYED VARCHAR2 Position where gear deployed: port, starboard, both or aft
100
 NETSCON VARCHAR2 If nets connected where two nets deployed on scallop or twin trawl; 1 = yes, 0 = no Collected for ASM where applicable.
100
 NETNAMEP VARCHAR2 Coded identifier for name of port or aft deployed net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
100
 NETNAMES VARCHAR2 Coded identifier for name of starboard deployed net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
100
 NETTYPEP VARCHAR2 Coded identifier for type of port or aft deployed trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
100
 NETTYPES VARCHAR2 Coded identifier for type of starboard deployed trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
100
 NETBUILDERP VARCHAR2 Coded identifier for builder net for port or aft gear See OBNETBUILDER table.(collected stg beginning 01/2008)
100
 NETBUILDERS VARCHAR2 Coded identifier for builder net for starboard gear See OBNETBUILDER table.(stg beginning 01/2008)
100
 DOORUSDP VARCHAR2 Door used on port net 0=no, 1=yes, 9 = unknown.
100
 DOORUSDS VARCHAR2 Door used on starboard net: 0=no, 1=yes, 9 = unknown.
100
 DOORWGTP NUMBER Weight of one door used on port net in whole kilograms. null if unknown or not used
100
 DOORWGTS NUMBER Weight of one door used on starboard net in whole kilograms. Null if unknown or not used
100
 NEGEAR VARCHAR2 Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100
 NETMATP VARCHAR2 Material used in body of port side scallop net not including codend. See OBNETMAT table.
100
 NETMATS VARCHAR2 Material used in body of starboard side scallp net not including codend. See OBNETMAT table.
100
 CODMATP VARCHAR2 Type of construction material used in codend port side. See OBNETMAT table.
100
 CODMATS VARCHAR2 Type of construction material used in codend starboard side. See OBNETMAT table.
100
 BRDTPLENP NUMBER Length of top bridle, in whole fathoms, port or aft deployed
100
 BRDTPLENS NUMBER Length of top bridle, in whole fathoms, starboard deployed
100
 HDROPLENP NUMBER Length of head rope on port net, in feet
100
 HDROPLENS NUMBER Length of head rope on starboard net, in feet
100
 FTROPLENP NUMBER Length of rope along bottom of port net in whole feet.
100
 FTROPLENS NUMBER Length of rope along bottom of starboard net in whole feet.
100
 GRCABLENP NUMBER Length of wire connecting the bridles and back strap on port net in whole feet.
100
 GRCABLENS NUMBER Length of wire connecting the bridles and back strap on starboard net in whole feet.
100
 CIRCLEMCP NUMBER Number of meshes in fishing circle on port net.
100
 CIRCLEMCS NUMBER Number of meshes in fishing circle on starboard net.
100
 CIRCLEMSP NUMBER Inside mesh measurement from port net fishing circle; nearest 1/10 inch.
100
 CIRCLEMSS NUMBER Inside mesh measurement from starboard net fishing circle; nearest 1/10.
100
 GRCABTYPP VARCHAR2 Gear type on port ground cable 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
100
 GRCABTYPS VARCHAR2 Gear type on starboard ground cable 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
100
 BRDLGTYPP VARCHAR2 Gear type making up port bridles/legs 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
100
 BRDLGTYPS VARCHAR2 Gear type on starboard bridles/legs, and footrope. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
100
 FTROPTYPP VARCHAR2 Gear type on port footrope/sweep. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
100
 FTROPTYPS VARCHAR2 Gear type on starboard footrope/sweepp. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
100
 NSWEEPSP NUMBER Total number of the largest piecce of gear present on the port net sweep /footrope (rollers, rock hoppers). Null if sweep is chain or cable/wire or or aft
100
 SWEEPDIAP NUMBER The diameter in whole inches of the largest piece of gear present on the sweep / footrope on the port or aft net; null if sweep is chain or cable/wire or wrapped
100
 NSWEEPSS NUMBER Total number of the largest piecce of gear present on the starboard net sweep / footrope(rollers, rock hoppers). Null if sweep is chain or cable/wire
100
 SWEEPDIAS NUMBER The diameter in whole inches of the largest piece of gear present on the sweep /footrope on the starboard net; null if sweep is chain or cable/wire or wrapped
100
 NFLOATSP NUMBER Number of floats on port gear
100
 NFLOATSS NUMBER Number of floats on starboard gear
100
 FLOATDIAP NUMBER Diameter in whole inches of majority of floats attached to port net headrope.
100
 FLOATDIAS NUMBER Diameter in whole inches of majority of floats attached to starboard net headrope.
100
 CODHUNGP VARCHAR2 Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable.
100
 CODHUNGS VARCHAR2 Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable.
100
 CODTWINETYPP VARCHAR2 Single or double twine used in port codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable.
100
 CODTWINETYPS VARCHAR2 Single or double twine used in starboard codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable.
100
 CODMSIZEP NUMBER Ten randomly selected inside mesh measurements from port net codend; whole millimeters Collected for ASM where applicable.
100
 CODMSIZES NUMBER Ten randomly selected inside mesh measurements from starboard net codend; whole millimeters Collected for ASM where applicable.
100
 CODLINERUSDP VARCHAR2 Liner used on port net codend: 0=no, 1=yes, 9=unknown Collected for ASM where applicable.
100
 CODLINERUSDS VARCHAR2 Liner used on starboard net codene: 0=no, 1=yes, 9= unknown Collected for ASM where applicable.
100
 CODSTRENUSDP VARCHAR2 Strengthener meterial used in codend of port net; 0=no, 1=yes, 9=unknown
100
 LINERMSIZEP NUMBER Truncated average of ten randomly selected inside liner whole millimeter measurements for port net location. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100
 LINERMSIZES NUMBER Truncated average of ten randomly selected inside liner whole millimeter measurements for starboard net location. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100
 LINERMATP VARCHAR2 Type of construction material used in liner for port net location. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
100
 LINERMATS VARCHAR2 Type of construction material used in liner for starboard net location. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
100
 LINERHUNGP VARCHAR2 Hanging configuration of liner for port net location. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100
 LINERHUNGS VARCHAR2 Hanging configuration of liner for starboard net location. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100
 LINERTWTYPP VARCHAR2 Single or double twine used in liner for port net location. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100
 LINERTWTYPS VARCHAR2 Single or double twine used in liner for starboard net location. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100
 KITPNUSDP VARCHAR2 Indicator of whether kite panel used on port or aft depoyed gear added 1-08
100
 KITPNUSDS VARCHAR2 Indicator of whether kite panel used on starboard depoyed gear added 1-08
100
 NKITPNP NUMBER Total number of panels used in kite in port or aft deployed net.| added 1-08
100
 NKITPNS NUMBER Total number of panels used in kite in starboard net.| added 1-08
100
 KITPNLENP NUMBER Average length of panels used in kite in port or aft deployed net, in whole inches.
100
 KITPNLENS NUMBER Average length of panels used in kite in starboard deployed net, in whole inches.
100
 KITPNWIDP NUMBER Average width of panels used in kite in port or aft deployed net, in whole inches.| added 1-08
100
 KITPNWIDS NUMBER Average width of panels used in kite in starboard deployed net, in whole inches.| added 1-08
100
 CODSTRENUSDS VARCHAR2 Strengthener material used in codend of starboard net; 0=no, 1=yes, 9=unknown
100
 CODCHAFFUSDP VARCHAR2 Chaffing gear used on port codend. 0=no, 1=yes, 9=unknown.
100
 CODCHAFFUSDS VARCHAR2 Chaffing gear used on starboard codend. 0=no, 1=yes, 9=unknown.
100
 GMELECTSUSDP VARCHAR2 Whether transducers used on port net: 0=no, 1=yes, 9=unknown
100
 GMELECTSUSDS VARCHAR2 Whether transducers used on starboard net: 0=no, 1=yes, 9=unknown
100
 NTRANSP NUMBER Number of transducers used on port gear. unknown: null; null if not used
100
 NTRANSS NUMBER Number of transducers on starboard gear. Unknown: null; null if not used
100
 TRANSTYPP VARCHAR2 Type of transducers used. 0=unknown, 1=wired, 2=wireless,3 = Both
100
 TRANSTYPS VARCHAR2 Type of transducers used: 0=unknown, 1=wired, 2=wireless, 3 = Both
100
 TRANSBRDP VARCHAR2 Code for brand of port side transducers: 0=unknown, 1=Furuno, 2=Simrad 9=other , 3 = Furuno/Simrad combination 9 = other
100
 TRANSBRDS VARCHAR2 Code for brand of starboard side transducers: 0= unkno1n, 1=Furuno, 2=Simrad , 3 = Furuno/Simrad combination , 9=other
100
 TRANSLOCSTRP VARCHAR2 Location of transducers used on port gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
100
 TRANSLOCSTRS VARCHAR2 Location of transducers used on starboard gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
100
 EXCLUSDP VARCHAR2 Excluder or separators ddevice used on port net: 0=no, 1=yes, 9=unknown. Collected for ASM where applicable.
100
 EXCLUSDS VARCHAR2 Excluder or separators devide used on starboard net: 0=no, 1=yes, 9= unknown. Collected for ASM where applicable.
100
 EXCLTYPP VARCHAR2 Type of excluder or separator device used on gear. 0=unknown, 1 = nordmore grate, 2 = T.E.D., 3 = separtor panel, 4 = guiding device, 8 = combo, 9 = other.
100
 EXCLTYPS VARCHAR2 Type of excluder or separator device used on gear. 0=unknown, 1 = nordmore grate, 2 = T.E.D., 3 = separtor panel, 4 = guiding device, 8 = combo, 9 = other.
100
 ESCAPOUTUSDP VARCHAR2 Indicator of whether fish outlet was used on gear. 0 = no, 1 = yes, 9 = unknown. Not entered prior to 5/1994;set to unknown. FSOUTUSD before 3/2007 Collected for ASM where applicable.
100
 ESCAPOUTUSDS VARCHAR2 Indicator of whether fish outlet was used on gear. 0 = no, 1 = yes, 9 = unknown. Not entered prior to 5/1994;set to unknown. FSOUTUSD before 3/2007 Collected for ASM where applicable.
100
 ESCAPOUTLENP NUMBER Length of fish outlet from front to back of net, in whole inches. Not collected before 5/1994; set to unknown. Previous 3/2007: fsoutlen
100
 ESCAPOUTLENS NUMBER Length of fish outlet from front to back of net, in whole inches. Not collected before 5/1994; set to unknown. Previous 3/2007: fsoutlen
100
 ESCAPOUTWIDP NUMBER Width of fish outlet, from side to side of net, in whole inches. Not collected prior to 5/1994; set to unknown. Pre 2/2007: fsoutwid
100
 ESCAPOUTWIDS NUMBER Width of fish outlet, from side to side of net, in whole inches. Not collected prior to 5/1994; set to unknown. Pre 2/2007: fsoutwid
100
 ESCAPOUTSHPP VARCHAR2 Shape of escape outlet used on gear. 00 = unknown, 01 = rectangle, 06 = square , 07 = diamond, 08 = diamond, 99 = other. Not entered prior to 5/1994; set to unknown.fsoutshp prior 3/2007
100
 ESCAPOUTSHPS VARCHAR2 Shape of escape outlet used on gear. 00 = unknown, 01 = rectangle, 06 = square , 07 = diamond, 08 = diamond, 99 = other. Not entered prior to 5/1994; set to unknown.fsoutshp prior 3/2007
100
 ESCAPOUTLOCP VARCHAR2 Location of escape outlet on gear. 0 = unknown, 1 = top, 2 = bottom, 3 = side, 8 = combo, 9 = other. Not entered before 5/1994; set to unknown.FSOUTLOC PRIOR 3/2007
100
 ESCAPOUTLOCS VARCHAR2 Location of escape outlet on gear. 0 = unknown, 1 = top, 2 = bottom, 3 = side, 8 = combo, 9 = other. Not entered before 5/1994; set to unknown.FSOUTLOC PRIOR 3/2007
100
 ESCAPOUTTYPP VARCHAR2 Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
100
 ESCAPOUTTYPS VARCHAR2 Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
100
 ESCAPOUTMSP NUMBER Mesh size of the escape outlet in whole inches.
100
 ESCAPOUTMSS NUMBER Mesh size of the escape outlet in whole inches.
100
 TEDEXTMSP NUMBER Turtle exclusion device extension mesh size port or aft gear in tenths of inches (begun 1/2008)
100
 TEDEXTMSS NUMBER Turtle exclusion device extension mesh size starboard gear in tenths of inches (begun 3/2007)
100
 TEDEXTMSTYPP VARCHAR2 Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE for port net location is an actual or estimated value A = actual, E = estimated. Collected beginning with obdbs Version 10 (01/01/2011).
100
 TEDEXTMSTYPS VARCHAR2 Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE for starboard net locationis an actual or estimated value A = actual, E = estimated. Collected beginning with obdbs Version 10 (01/01/2011).
100
 ESCAPOUTLENMCP NUMBER Number of meshes in length of the escape outlet (front -> codend)
100
 ESCAPOUTLENMCS NUMBER Number of meshes in length of the escape outlet (front -> codend)
100
 ESCAPOUTWIDMCP NUMBER Number of meshes in width of the escape outlet (side -> side)
100
 ESCAPOUTWIDMCS NUMBER Number of meshes in width of the escape outlet (side -> side)
100
 STGCOMMENTSS VARCHAR2 Comments on scallop trawl gear deployed to starboard
100
 STGCOMMENTSP VARCHAR2 Comments on scallop trawl gear deployed to port or aft
100
 DOE DATE Date of Entry of the associated record.
100
 UOE VARCHAR2 Oracle user ID of the person who entered the data.
100
 DOC DATE Date associated record was updated.
100
 UOC VARCHAR2 Oracle ID of user who made the (most recent ) change on the record.

Attribute Details

LINK4

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

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
General Data Type: VARCHAR2

LINK1

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

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
General Data Type: VARCHAR2

PROGRAM

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

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type: VARCHAR2

YEAR

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

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type: VARCHAR2

MONTH

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

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type: VARCHAR2

TRIPID

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

May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
General Data Type: VARCHAR2

GEARNUM

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

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
General Data Type: VARCHAR2

DEPLOYED

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

Position where gear deployed: port, starboard, both or aft
General Data Type: VARCHAR2

NETSCON

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

If nets connected where two nets deployed on scallop or twin trawl; 1 = yes, 0 = no Collected for ASM where applicable.
General Data Type: VARCHAR2

NETNAMEP

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

Coded identifier for name of port or aft deployed net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
General Data Type: VARCHAR2

NETNAMES

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

Coded identifier for name of starboard deployed net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
General Data Type: VARCHAR2

NETTYPEP

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

Coded identifier for type of port or aft deployed trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
General Data Type: VARCHAR2

NETTYPES

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

Coded identifier for type of starboard deployed trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable.
General Data Type: VARCHAR2

NETBUILDERP

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

Coded identifier for builder net for port or aft gear See OBNETBUILDER table.(collected stg beginning 01/2008)
General Data Type: VARCHAR2

NETBUILDERS

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

Coded identifier for builder net for starboard gear See OBNETBUILDER table.(stg beginning 01/2008)
General Data Type: VARCHAR2

DOORUSDP

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

Door used on port net 0=no, 1=yes, 9 = unknown.
General Data Type: VARCHAR2

DOORUSDS

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

Door used on starboard net: 0=no, 1=yes, 9 = unknown.
General Data Type: VARCHAR2

DOORWGTP

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

Weight of one door used on port net in whole kilograms. null if unknown or not used
General Data Type: NUMBER

DOORWGTS

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

Weight of one door used on starboard net in whole kilograms. Null if unknown or not used
General Data Type: NUMBER

NEGEAR

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

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
General Data Type: VARCHAR2

NETMATP

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

Material used in body of port side scallop net not including codend. See OBNETMAT table.
General Data Type: VARCHAR2

NETMATS

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

Material used in body of starboard side scallp net not including codend. See OBNETMAT table.
General Data Type: VARCHAR2

CODMATP

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

Type of construction material used in codend port side. See OBNETMAT table.
General Data Type: VARCHAR2

CODMATS

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

Type of construction material used in codend starboard side. See OBNETMAT table.
General Data Type: VARCHAR2

BRDTPLENP

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

Length of top bridle, in whole fathoms, port or aft deployed
General Data Type: NUMBER

BRDTPLENS

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

Length of top bridle, in whole fathoms, starboard deployed
General Data Type: NUMBER

HDROPLENP

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

Length of head rope on port net, in feet
General Data Type: NUMBER

HDROPLENS

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

Length of head rope on starboard net, in feet
General Data Type: NUMBER

FTROPLENP

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

Length of rope along bottom of port net in whole feet.
General Data Type: NUMBER

FTROPLENS

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

Length of rope along bottom of starboard net in whole feet.
General Data Type: NUMBER

GRCABLENP

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

Length of wire connecting the bridles and back strap on port net in whole feet.
General Data Type: NUMBER

GRCABLENS

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

Length of wire connecting the bridles and back strap on starboard net in whole feet.
General Data Type: NUMBER

CIRCLEMCP

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

Number of meshes in fishing circle on port net.
General Data Type: NUMBER

CIRCLEMCS

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

Number of meshes in fishing circle on starboard net.
General Data Type: NUMBER

CIRCLEMSP

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

Inside mesh measurement from port net fishing circle; nearest 1/10 inch.
General Data Type: NUMBER

CIRCLEMSS

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

Inside mesh measurement from starboard net fishing circle; nearest 1/10.
General Data Type: NUMBER

GRCABTYPP

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

Gear type on port ground cable 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
General Data Type: VARCHAR2

GRCABTYPS

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

Gear type on starboard ground cable 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
General Data Type: VARCHAR2

BRDLGTYPP

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

Gear type making up port bridles/legs 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
General Data Type: VARCHAR2

BRDLGTYPS

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

Gear type on starboard bridles/legs, and footrope. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
General Data Type: VARCHAR2

FTROPTYPP

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

Gear type on port footrope/sweep. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
General Data Type: VARCHAR2

FTROPTYPS

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

Gear type on starboard footrope/sweepp. 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other
General Data Type: VARCHAR2

NSWEEPSP

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

Total number of the largest piecce of gear present on the port net sweep /footrope (rollers, rock hoppers). Null if sweep is chain or cable/wire or or aft
General Data Type: NUMBER

SWEEPDIAP

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

The diameter in whole inches of the largest piece of gear present on the sweep / footrope on the port or aft net; null if sweep is chain or cable/wire or wrapped
General Data Type: NUMBER

NSWEEPSS

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

Total number of the largest piecce of gear present on the starboard net sweep / footrope(rollers, rock hoppers). Null if sweep is chain or cable/wire
General Data Type: NUMBER

SWEEPDIAS

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

The diameter in whole inches of the largest piece of gear present on the sweep /footrope on the starboard net; null if sweep is chain or cable/wire or wrapped
General Data Type: NUMBER

NFLOATSP

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

Number of floats on port gear
General Data Type: NUMBER

NFLOATSS

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

Number of floats on starboard gear
General Data Type: NUMBER

FLOATDIAP

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

Diameter in whole inches of majority of floats attached to port net headrope.
General Data Type: NUMBER

FLOATDIAS

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

Diameter in whole inches of majority of floats attached to starboard net headrope.
General Data Type: NUMBER

CODHUNGP

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

Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable.
General Data Type: VARCHAR2

CODHUNGS

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

Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable.
General Data Type: VARCHAR2

CODTWINETYPP

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

Single or double twine used in port codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable.
General Data Type: VARCHAR2

CODTWINETYPS

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

Single or double twine used in starboard codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable.
General Data Type: VARCHAR2

CODMSIZEP

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

Ten randomly selected inside mesh measurements from port net codend; whole millimeters Collected for ASM where applicable.
General Data Type: NUMBER

CODMSIZES

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

Ten randomly selected inside mesh measurements from starboard net codend; whole millimeters Collected for ASM where applicable.
General Data Type: NUMBER

CODLINERUSDP

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

Liner used on port net codend: 0=no, 1=yes, 9=unknown Collected for ASM where applicable.
General Data Type: VARCHAR2

CODLINERUSDS

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

Liner used on starboard net codene: 0=no, 1=yes, 9= unknown Collected for ASM where applicable.
General Data Type: VARCHAR2

CODSTRENUSDP

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

Strengthener meterial used in codend of port net; 0=no, 1=yes, 9=unknown
General Data Type: VARCHAR2

LINERMSIZEP

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

Truncated average of ten randomly selected inside liner whole millimeter measurements for port net location. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type: NUMBER

LINERMSIZES

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

Truncated average of ten randomly selected inside liner whole millimeter measurements for starboard net location. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type: NUMBER

LINERMATP

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

Type of construction material used in liner for port net location. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type: VARCHAR2

LINERMATS

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

Type of construction material used in liner for starboard net location. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type: VARCHAR2

LINERHUNGP

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

Hanging configuration of liner for port net location. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type: VARCHAR2

LINERHUNGS

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

Hanging configuration of liner for starboard net location. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type: VARCHAR2

LINERTWTYPP

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

Single or double twine used in liner for port net location. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type: VARCHAR2

LINERTWTYPS

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

Single or double twine used in liner for starboard net location. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type: VARCHAR2

KITPNUSDP

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

Indicator of whether kite panel used on port or aft depoyed gear added 1-08
General Data Type: VARCHAR2

KITPNUSDS

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

Indicator of whether kite panel used on starboard depoyed gear added 1-08
General Data Type: VARCHAR2

NKITPNP

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

Total number of panels used in kite in port or aft deployed net.| added 1-08
General Data Type: NUMBER

NKITPNS

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

Total number of panels used in kite in starboard net.| added 1-08
General Data Type: NUMBER

KITPNLENP

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

Average length of panels used in kite in port or aft deployed net, in whole inches.
General Data Type: NUMBER

KITPNLENS

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

Average length of panels used in kite in starboard deployed net, in whole inches.
General Data Type: NUMBER

KITPNWIDP

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

Average width of panels used in kite in port or aft deployed net, in whole inches.| added 1-08
General Data Type: NUMBER

KITPNWIDS

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

Average width of panels used in kite in starboard deployed net, in whole inches.| added 1-08
General Data Type: NUMBER

CODSTRENUSDS

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

Strengthener material used in codend of starboard net; 0=no, 1=yes, 9=unknown
General Data Type: VARCHAR2

CODCHAFFUSDP

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

Chaffing gear used on port codend. 0=no, 1=yes, 9=unknown.
General Data Type: VARCHAR2

CODCHAFFUSDS

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

Chaffing gear used on starboard codend. 0=no, 1=yes, 9=unknown.
General Data Type: VARCHAR2

GMELECTSUSDP

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

Whether transducers used on port net: 0=no, 1=yes, 9=unknown
General Data Type: VARCHAR2

GMELECTSUSDS

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

Whether transducers used on starboard net: 0=no, 1=yes, 9=unknown
General Data Type: VARCHAR2

NTRANSP

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

Number of transducers used on port gear. unknown: null; null if not used
General Data Type: NUMBER

NTRANSS

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

Number of transducers on starboard gear. Unknown: null; null if not used
General Data Type: NUMBER

TRANSTYPP

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

Type of transducers used. 0=unknown, 1=wired, 2=wireless,3 = Both
General Data Type: VARCHAR2

TRANSTYPS

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

Type of transducers used: 0=unknown, 1=wired, 2=wireless, 3 = Both
General Data Type: VARCHAR2

TRANSBRDP

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

Code for brand of port side transducers: 0=unknown, 1=Furuno, 2=Simrad 9=other , 3 = Furuno/Simrad combination 9 = other
General Data Type: VARCHAR2

TRANSBRDS

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

Code for brand of starboard side transducers: 0= unkno1n, 1=Furuno, 2=Simrad , 3 = Furuno/Simrad combination , 9=other
General Data Type: VARCHAR2

TRANSLOCSTRP

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

Location of transducers used on port gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
General Data Type: VARCHAR2

TRANSLOCSTRS

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

Location of transducers used on starboard gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
General Data Type: VARCHAR2

EXCLUSDP

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

Excluder or separators ddevice used on port net: 0=no, 1=yes, 9=unknown. Collected for ASM where applicable.
General Data Type: VARCHAR2

EXCLUSDS

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

Excluder or separators devide used on starboard net: 0=no, 1=yes, 9= unknown. Collected for ASM where applicable.
General Data Type: VARCHAR2

EXCLTYPP

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

Type of excluder or separator device used on gear. 0=unknown, 1 = nordmore grate, 2 = T.E.D., 3 = separtor panel, 4 = guiding device, 8 = combo, 9 = other.
General Data Type: VARCHAR2

EXCLTYPS

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

Type of excluder or separator device used on gear. 0=unknown, 1 = nordmore grate, 2 = T.E.D., 3 = separtor panel, 4 = guiding device, 8 = combo, 9 = other.
General Data Type: VARCHAR2

ESCAPOUTUSDP

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

Indicator of whether fish outlet was used on gear. 0 = no, 1 = yes, 9 = unknown. Not entered prior to 5/1994;set to unknown. FSOUTUSD before 3/2007 Collected for ASM where applicable.
General Data Type: VARCHAR2

ESCAPOUTUSDS

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

Indicator of whether fish outlet was used on gear. 0 = no, 1 = yes, 9 = unknown. Not entered prior to 5/1994;set to unknown. FSOUTUSD before 3/2007 Collected for ASM where applicable.
General Data Type: VARCHAR2

ESCAPOUTLENP

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

Length of fish outlet from front to back of net, in whole inches. Not collected before 5/1994; set to unknown. Previous 3/2007: fsoutlen
General Data Type: NUMBER

ESCAPOUTLENS

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

Length of fish outlet from front to back of net, in whole inches. Not collected before 5/1994; set to unknown. Previous 3/2007: fsoutlen
General Data Type: NUMBER

ESCAPOUTWIDP

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

Width of fish outlet, from side to side of net, in whole inches. Not collected prior to 5/1994; set to unknown. Pre 2/2007: fsoutwid
General Data Type: NUMBER

ESCAPOUTWIDS

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

Width of fish outlet, from side to side of net, in whole inches. Not collected prior to 5/1994; set to unknown. Pre 2/2007: fsoutwid
General Data Type: NUMBER

ESCAPOUTSHPP

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

Shape of escape outlet used on gear. 00 = unknown, 01 = rectangle, 06 = square , 07 = diamond, 08 = diamond, 99 = other. Not entered prior to 5/1994; set to unknown.fsoutshp prior 3/2007
General Data Type: VARCHAR2

ESCAPOUTSHPS

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

Shape of escape outlet used on gear. 00 = unknown, 01 = rectangle, 06 = square , 07 = diamond, 08 = diamond, 99 = other. Not entered prior to 5/1994; set to unknown.fsoutshp prior 3/2007
General Data Type: VARCHAR2

ESCAPOUTLOCP

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

Location of escape outlet on gear. 0 = unknown, 1 = top, 2 = bottom, 3 = side, 8 = combo, 9 = other. Not entered before 5/1994; set to unknown.FSOUTLOC PRIOR 3/2007
General Data Type: VARCHAR2

ESCAPOUTLOCS

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

Location of escape outlet on gear. 0 = unknown, 1 = top, 2 = bottom, 3 = side, 8 = combo, 9 = other. Not entered before 5/1994; set to unknown.FSOUTLOC PRIOR 3/2007
General Data Type: VARCHAR2

ESCAPOUTTYPP

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

Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
General Data Type: VARCHAR2

ESCAPOUTTYPS

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

Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
General Data Type: VARCHAR2

ESCAPOUTMSP

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

Mesh size of the escape outlet in whole inches.
General Data Type: NUMBER

ESCAPOUTMSS

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

Mesh size of the escape outlet in whole inches.
General Data Type: NUMBER

TEDEXTMSP

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

Turtle exclusion device extension mesh size port or aft gear in tenths of inches (begun 1/2008)
General Data Type: NUMBER

TEDEXTMSS

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

Turtle exclusion device extension mesh size starboard gear in tenths of inches (begun 3/2007)
General Data Type: NUMBER

TEDEXTMSTYPP

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

Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE for port net location is an actual or estimated value A = actual, E = estimated. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type: VARCHAR2

TEDEXTMSTYPS

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

Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE for starboard net locationis an actual or estimated value A = actual, E = estimated. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type: VARCHAR2

ESCAPOUTLENMCP

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

Number of meshes in length of the escape outlet (front -> codend)
General Data Type: NUMBER

ESCAPOUTLENMCS

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

Number of meshes in length of the escape outlet (front -> codend)
General Data Type: NUMBER

ESCAPOUTWIDMCP

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

Number of meshes in width of the escape outlet (side -> side)
General Data Type: NUMBER

ESCAPOUTWIDMCS

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

Number of meshes in width of the escape outlet (side -> side)
General Data Type: NUMBER

STGCOMMENTSS

CC ID: 334929
Seq. Order: 115
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Comments on scallop trawl gear deployed to starboard
General Data Type: VARCHAR2

STGCOMMENTSP

CC ID: 334930
Seq. Order: 116
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Comments on scallop trawl gear deployed to port or aft
General Data Type: VARCHAR2

DOE

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

Date of Entry of the associated record.
General Data Type: DATE

UOE

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

Oracle user ID of the person who entered the data.
General Data Type: VARCHAR2

DOC

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

Date associated record was updated.
General Data Type: DATE

UOC

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

Oracle ID of user who made the (most recent ) change on the record.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33574
GUID: gov.noaa.nmfs.inport:33574
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-27 19:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28