Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fishery Monitoring Operations Branch (FMOB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBTTG

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33578  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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

Observer Twin Trawl Gear Characteristics
Notes:

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

Entity Information

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

Observer Twin Trawl Gear Characteristics

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
 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
 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
 TTGCOMMENTSS VARCHAR2 Additional comments regarding the starboard side gear on a twin trawl gear record. Collected for ASM where applicable.
100
 TTGCOMMENTSP VARCHAR2 Additional comments regarding the port side gear on a twin trawl gear record. 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
 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
 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: 335197
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: 335229
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: 335240
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: 335251
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: 335262
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: 335273
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: 335284
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: 335295
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: 335306
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: 335198
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: 335209
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: 335220
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: 335222
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: 335223
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: 335224
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: 335225
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: 335226
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: 335227
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: 335228
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: 335230
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: 335231
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: 335232
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: 335233
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: 335234
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: 335235
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: 335236
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: 335237
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: 335238
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: 335239
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: 335241
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: 335242
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: 335243
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: 335244
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: 335245
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: 335246
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: 335247
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: 335248
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: 335249
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: 335250
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: 335252
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: 335253
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: 335254
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: 335255
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: 335256
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: 335257
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: 335258
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: 335259
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: 335260
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: 335261
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: 335263
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: 335264
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: 335265
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: 335266
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: 335267
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: 335268
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: 335269
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: 335270
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: 335271
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: 335272
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: 335274
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: 335275
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

KITPNUSDP

CC ID: 335276
Seq. Order: 62
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: 335277
Seq. Order: 63
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: 335278
Seq. Order: 64
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: 335279
Seq. Order: 65
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: 335280
Seq. Order: 66
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: 335281
Seq. Order: 67
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: 335282
Seq. Order: 68
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: 335283
Seq. Order: 69
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: 335285
Seq. Order: 70
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: 335286
Seq. Order: 71
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: 335287
Seq. Order: 72
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: 335288
Seq. Order: 73
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: 335289
Seq. Order: 74
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: 335290
Seq. Order: 75
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: 335291
Seq. Order: 76
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: 335292
Seq. Order: 77
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: 335293
Seq. Order: 78
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: 335294
Seq. Order: 79
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: 335296
Seq. Order: 80
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: 335297
Seq. Order: 81
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: 335298
Seq. Order: 82
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: 335299
Seq. Order: 83
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: 335300
Seq. Order: 84
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: 335301
Seq. Order: 85
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: 335302
Seq. Order: 86
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: 335303
Seq. Order: 87
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: 335304
Seq. Order: 88
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: 335305
Seq. Order: 89
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: 335307
Seq. Order: 90
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: 335308
Seq. Order: 91
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: 335309
Seq. Order: 92
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: 335310
Seq. Order: 93
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: 335311
Seq. Order: 94
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: 335312
Seq. Order: 95
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: 335313
Seq. Order: 96
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: 335314
Seq. Order: 97
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: 335315
Seq. Order: 98
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: 335316
Seq. Order: 99
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: 335199
Seq. Order: 100
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: 335200
Seq. Order: 101
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: 335201
Seq. Order: 102
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

ESCAPOUTLENMCP

CC ID: 335202
Seq. Order: 103
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: 335203
Seq. Order: 104
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: 335204
Seq. Order: 105
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: 335205
Seq. Order: 106
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

TTGCOMMENTSS

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

Additional comments regarding the starboard side gear on a twin trawl gear record. Collected for ASM where applicable.
General Data Type: VARCHAR2

TTGCOMMENTSP

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

Additional comments regarding the port side gear on a twin trawl gear record. Collected for ASM where applicable.
General Data Type: VARCHAR2

LINERMATP

CC ID: 335208
Seq. Order: 109
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: 335210
Seq. Order: 110
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: 335211
Seq. Order: 111
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: 335212
Seq. Order: 112
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: 335213
Seq. Order: 113
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: 335214
Seq. Order: 114
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

TEDEXTMSTYPP

CC ID: 335215
Seq. Order: 115
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: 335216
Seq. Order: 116
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

DOE

CC ID: 335217
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: 335218
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: 335219
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: 335221
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: 33578
GUID: gov.noaa.nmfs.inport:33578
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