View: OBTTG
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 33578
| Published / External
Created: 2016-07-27
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 24111
ID: 33578
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | View: OBTTG |
---|---|
Short Name | OBTTG |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Observer Twin Trawl Gear Characteristics |
* Purpose | |
Notes |
Loaded by batch 9053, 07-27-2016 19:10 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data View |
---|---|
Active Version? | Y |
Alias | |
Schema Name | OBDBS |
» Description |
Observer Twin Trawl Gear Characteristics |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | LINK4 | VARCHAR2 | Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. |
100 | No | No | 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 | No | No | PROGRAM | VARCHAR2 | First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
100 | No | No | YEAR | VARCHAR2 | Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
100 | No | No | MONTH | VARCHAR2 | Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
100 | No | No | 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 | No | No | GEARNUM | VARCHAR2 | Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. |
100 | No | No | DEPLOYED | VARCHAR2 | Position where gear deployed: port, starboard, both or aft |
100 | No | No | NETSCON | VARCHAR2 | If nets connected where two nets deployed on scallop or twin trawl; 1 = yes, 0 = no Collected for ASM where applicable. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | NETBUILDERP | VARCHAR2 | Coded identifier for builder net for port or aft gear See OBNETBUILDER table.(collected stg beginning 01/2008) |
100 | No | No | NETBUILDERS | VARCHAR2 | Coded identifier for builder net for starboard gear See OBNETBUILDER table.(stg beginning 01/2008) |
100 | No | No | DOORUSDP | VARCHAR2 | Door used on port net 0=no, 1=yes, 9 = unknown. |
100 | No | No | DOORUSDS | VARCHAR2 | Door used on starboard net: 0=no, 1=yes, 9 = unknown. |
100 | No | No | DOORWGTP | NUMBER | Weight of one door used on port net in whole kilograms. null if unknown or not used |
100 | No | No | DOORWGTS | NUMBER | Weight of one door used on starboard net in whole kilograms. Null if unknown or not used |
100 | No | No | NEGEAR | VARCHAR2 | Northeast gear code. See OBGEAR table. Collected for ASM where applicable. |
100 | No | No | NETMATP | VARCHAR2 | Material used in body of port side scallop net not including codend. See OBNETMAT table. |
100 | No | No | NETMATS | VARCHAR2 | Material used in body of starboard side scallp net not including codend. See OBNETMAT table. |
100 | No | No | CODMATP | VARCHAR2 | Type of construction material used in codend port side. See OBNETMAT table. |
100 | No | No | CODMATS | VARCHAR2 | Type of construction material used in codend starboard side. See OBNETMAT table. |
100 | No | No | BRDTPLENP | NUMBER | Length of top bridle, in whole fathoms, port or aft deployed |
100 | No | No | BRDTPLENS | NUMBER | Length of top bridle, in whole fathoms, starboard deployed |
100 | No | No | HDROPLENP | NUMBER | Length of head rope on port net, in feet |
100 | No | No | HDROPLENS | NUMBER | Length of head rope on starboard net, in feet |
100 | No | No | FTROPLENP | NUMBER | Length of rope along bottom of port net in whole feet. |
100 | No | No | FTROPLENS | NUMBER | Length of rope along bottom of starboard net in whole feet. |
100 | No | No | GRCABLENP | NUMBER | Length of wire connecting the bridles and back strap on port net in whole feet. |
100 | No | No | GRCABLENS | NUMBER | Length of wire connecting the bridles and back strap on starboard net in whole feet. |
100 | No | No | CIRCLEMCP | NUMBER | Number of meshes in fishing circle on port net. |
100 | No | No | CIRCLEMCS | NUMBER | Number of meshes in fishing circle on starboard net. |
100 | No | No | CIRCLEMSP | NUMBER | Inside mesh measurement from port net fishing circle; nearest 1/10 inch. |
100 | No | No | CIRCLEMSS | NUMBER | Inside mesh measurement from starboard net fishing circle; nearest 1/10. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | NFLOATSP | NUMBER | Number of floats on port gear |
100 | No | No | NFLOATSS | NUMBER | Number of floats on starboard gear |
100 | No | No | FLOATDIAP | NUMBER | Diameter in whole inches of majority of floats attached to port net headrope. |
100 | No | No | FLOATDIAS | NUMBER | Diameter in whole inches of majority of floats attached to starboard net headrope. |
100 | No | No | CODHUNGP | VARCHAR2 | Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable. |
100 | No | No | CODHUNGS | VARCHAR2 | Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable. |
100 | No | No | CODTWINETYPP | VARCHAR2 | Single or double twine used in port codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable. |
100 | No | No | CODTWINETYPS | VARCHAR2 | Single or double twine used in starboard codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable. |
100 | No | No | CODMSIZEP | NUMBER | Ten randomly selected inside mesh measurements from port net codend; whole millimeters Collected for ASM where applicable. |
100 | No | No | CODMSIZES | NUMBER | Ten randomly selected inside mesh measurements from starboard net codend; whole millimeters Collected for ASM where applicable. |
100 | No | No | CODLINERUSDP | VARCHAR2 | Liner used on port net codend: 0=no, 1=yes, 9=unknown Collected for ASM where applicable. |
100 | No | No | CODLINERUSDS | VARCHAR2 | Liner used on starboard net codene: 0=no, 1=yes, 9= unknown Collected for ASM where applicable. |
100 | No | No | CODSTRENUSDP | VARCHAR2 | Strengthener meterial used in codend of port net; 0=no, 1=yes, 9=unknown |
100 | No | No | 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 | No | No | 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 | No | No | KITPNUSDP | VARCHAR2 | Indicator of whether kite panel used on port or aft depoyed gear added 1-08 |
100 | No | No | KITPNUSDS | VARCHAR2 | Indicator of whether kite panel used on starboard depoyed gear added 1-08 |
100 | No | No | NKITPNP | NUMBER | Total number of panels used in kite in port or aft deployed net.| added 1-08 |
100 | No | No | NKITPNS | NUMBER | Total number of panels used in kite in starboard net.| added 1-08 |
100 | No | No | KITPNLENP | NUMBER | Average length of panels used in kite in port or aft deployed net, in whole inches. |
100 | No | No | KITPNLENS | NUMBER | Average length of panels used in kite in starboard deployed net, in whole inches. |
100 | No | No | KITPNWIDP | NUMBER | Average width of panels used in kite in port or aft deployed net, in whole inches.| added 1-08 |
100 | No | No | KITPNWIDS | NUMBER | Average width of panels used in kite in starboard deployed net, in whole inches.| added 1-08 |
100 | No | No | CODSTRENUSDS | VARCHAR2 | Strengthener material used in codend of starboard net; 0=no, 1=yes, 9=unknown |
100 | No | No | CODCHAFFUSDP | VARCHAR2 | Chaffing gear used on port codend. 0=no, 1=yes, 9=unknown. |
100 | No | No | CODCHAFFUSDS | VARCHAR2 | Chaffing gear used on starboard codend. 0=no, 1=yes, 9=unknown. |
100 | No | No | GMELECTSUSDP | VARCHAR2 | Whether transducers used on port net: 0=no, 1=yes, 9=unknown |
100 | No | No | GMELECTSUSDS | VARCHAR2 | Whether transducers used on starboard net: 0=no, 1=yes, 9=unknown |
100 | No | No | NTRANSP | NUMBER | Number of transducers used on port gear. unknown: null; null if not used |
100 | No | No | NTRANSS | NUMBER | Number of transducers on starboard gear. Unknown: null; null if not used |
100 | No | No | TRANSTYPP | VARCHAR2 | Type of transducers used. 0=unknown, 1=wired, 2=wireless,3 = Both |
100 | No | No | TRANSTYPS | VARCHAR2 | Type of transducers used: 0=unknown, 1=wired, 2=wireless, 3 = Both |
100 | No | No | TRANSBRDP | VARCHAR2 | Code for brand of port side transducers: 0=unknown, 1=Furuno, 2=Simrad 9=other , 3 = Furuno/Simrad combination 9 = other |
100 | No | No | TRANSBRDS | VARCHAR2 | Code for brand of starboard side transducers: 0= unkno1n, 1=Furuno, 2=Simrad , 3 = Furuno/Simrad combination , 9=other |
100 | No | No | 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 | No | No | 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 | No | No | EXCLUSDP | VARCHAR2 | Excluder or separators ddevice used on port net: 0=no, 1=yes, 9=unknown. Collected for ASM where applicable. |
100 | No | No | EXCLUSDS | VARCHAR2 | Excluder or separators devide used on starboard net: 0=no, 1=yes, 9= unknown. Collected for ASM where applicable. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | ESCAPOUTTYPP | VARCHAR2 | Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other |
100 | No | No | ESCAPOUTTYPS | VARCHAR2 | Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other |
100 | No | No | ESCAPOUTMSP | NUMBER | Mesh size of the escape outlet in whole inches. |
100 | No | No | ESCAPOUTMSS | NUMBER | Mesh size of the escape outlet in whole inches. |
100 | No | No | TEDEXTMSP | NUMBER | Turtle exclusion device extension mesh size port or aft gear in tenths of inches (begun 1/2008) |
100 | No | No | TEDEXTMSS | NUMBER | Turtle exclusion device extension mesh size starboard gear in tenths of inches (begun 3/2007) |
100 | No | No | ESCAPOUTLENMCP | NUMBER | Number of meshes in length of the escape outlet (front -> codend) |
100 | No | No | ESCAPOUTLENMCS | NUMBER | Number of meshes in length of the escape outlet (front -> codend) |
100 | No | No | ESCAPOUTWIDMCP | NUMBER | Number of meshes in width of the escape outlet (side -> side) |
100 | No | No | ESCAPOUTWIDMCS | NUMBER | Number of meshes in width of the escape outlet (side -> side) |
100 | No | No | TTGCOMMENTSS | VARCHAR2 | Additional comments regarding the starboard side gear on a twin trawl gear record. Collected for ASM where applicable. |
100 | No | No | TTGCOMMENTSP | VARCHAR2 | Additional comments regarding the port side gear on a twin trawl gear record. Collected for ASM where applicable. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | DOE | DATE | Date of Entry of the associated record. |
100 | No | No | UOE | VARCHAR2 | Oracle user ID of the person who entered the data. |
100 | No | No | DOC | DATE | Date associated record was updated. |
100 | No | No | UOC | VARCHAR2 | Oracle ID of user who made the (most recent ) change on the record. |
Attribute Details
Attribute Name | LINK4 |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINK1 |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PROGRAM |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | YEAR |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MONTH |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRIPID |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEARNUM |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPLOYED |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Position where gear deployed: port, starboard, both or aft |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETSCON |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETNAMEP |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETNAMES |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETTYPEP |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETTYPES |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETBUILDERP |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETBUILDERS |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coded identifier for builder net for starboard gear See OBNETBUILDER table.(stg beginning 01/2008) |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOORUSDP |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Door used on port net 0=no, 1=yes, 9 = unknown. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOORUSDS |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Door used on starboard net: 0=no, 1=yes, 9 = unknown. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOORWGTP |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOORWGTS |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NEGEAR |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Northeast gear code. See OBGEAR table. Collected for ASM where applicable. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETMATP |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Material used in body of port side scallop net not including codend. See OBNETMAT table. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NETMATS |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Material used in body of starboard side scallp net not including codend. See OBNETMAT table. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODMATP |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of construction material used in codend port side. See OBNETMAT table. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODMATS |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of construction material used in codend starboard side. See OBNETMAT table. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BRDTPLENP |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BRDTPLENS |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HDROPLENP |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HDROPLENS |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FTROPLENP |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FTROPLENS |
---|---|
Seq. Order | 30 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GRCABLENP |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GRCABLENS |
---|---|
Seq. Order | 32 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CIRCLEMCP |
---|---|
Seq. Order | 33 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CIRCLEMCS |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CIRCLEMSP |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CIRCLEMSS |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GRCABTYPP |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GRCABTYPS |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BRDLGTYPP |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BRDLGTYPS |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FTROPTYPP |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FTROPTYPS |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NSWEEPSP |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SWEEPDIAP |
---|---|
Seq. Order | 44 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NSWEEPSS |
---|---|
Seq. Order | 45 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SWEEPDIAS |
---|---|
Seq. Order | 46 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NFLOATSP |
---|---|
Seq. Order | 47 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Number of floats on port gear |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NFLOATSS |
---|---|
Seq. Order | 48 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Number of floats on starboard gear |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FLOATDIAP |
---|---|
Seq. Order | 49 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FLOATDIAS |
---|---|
Seq. Order | 50 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODHUNGP |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODHUNGS |
---|---|
Seq. Order | 52 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODTWINETYPP |
---|---|
Seq. Order | 53 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODTWINETYPS |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODMSIZEP |
---|---|
Seq. Order | 55 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODMSIZES |
---|---|
Seq. Order | 56 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODLINERUSDP |
---|---|
Seq. Order | 57 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Liner used on port net codend: 0=no, 1=yes, 9=unknown Collected for ASM where applicable. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODLINERUSDS |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Liner used on starboard net codene: 0=no, 1=yes, 9= unknown Collected for ASM where applicable. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODSTRENUSDP |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Strengthener meterial used in codend of port net; 0=no, 1=yes, 9=unknown |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINERMSIZEP |
---|---|
Seq. Order | 60 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINERMSIZES |
---|---|
Seq. Order | 61 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | KITPNUSDP |
---|---|
Seq. Order | 62 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicator of whether kite panel used on port or aft depoyed gear added 1-08 |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | KITPNUSDS |
---|---|
Seq. Order | 63 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicator of whether kite panel used on starboard depoyed gear added 1-08 |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NKITPNP |
---|---|
Seq. Order | 64 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NKITPNS |
---|---|
Seq. Order | 65 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | KITPNLENP |
---|---|
Seq. Order | 66 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | KITPNLENS |
---|---|
Seq. Order | 67 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | KITPNWIDP |
---|---|
Seq. Order | 68 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | KITPNWIDS |
---|---|
Seq. Order | 69 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODSTRENUSDS |
---|---|
Seq. Order | 70 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Strengthener material used in codend of starboard net; 0=no, 1=yes, 9=unknown |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODCHAFFUSDP |
---|---|
Seq. Order | 71 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Chaffing gear used on port codend. 0=no, 1=yes, 9=unknown. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODCHAFFUSDS |
---|---|
Seq. Order | 72 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Chaffing gear used on starboard codend. 0=no, 1=yes, 9=unknown. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GMELECTSUSDP |
---|---|
Seq. Order | 73 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Whether transducers used on port net: 0=no, 1=yes, 9=unknown |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GMELECTSUSDS |
---|---|
Seq. Order | 74 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Whether transducers used on starboard net: 0=no, 1=yes, 9=unknown |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NTRANSP |
---|---|
Seq. Order | 75 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NTRANSS |
---|---|
Seq. Order | 76 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSTYPP |
---|---|
Seq. Order | 77 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of transducers used. 0=unknown, 1=wired, 2=wireless,3 = Both |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSTYPS |
---|---|
Seq. Order | 78 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of transducers used: 0=unknown, 1=wired, 2=wireless, 3 = Both |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSBRDP |
---|---|
Seq. Order | 79 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSBRDS |
---|---|
Seq. Order | 80 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSLOCSTRP |
---|---|
Seq. Order | 81 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSLOCSTRS |
---|---|
Seq. Order | 82 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXCLUSDP |
---|---|
Seq. Order | 83 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXCLUSDS |
---|---|
Seq. Order | 84 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXCLTYPP |
---|---|
Seq. Order | 85 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXCLTYPS |
---|---|
Seq. Order | 86 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTUSDP |
---|---|
Seq. Order | 87 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTUSDS |
---|---|
Seq. Order | 88 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTLENP |
---|---|
Seq. Order | 89 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTLENS |
---|---|
Seq. Order | 90 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTWIDP |
---|---|
Seq. Order | 91 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTWIDS |
---|---|
Seq. Order | 92 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTSHPP |
---|---|
Seq. Order | 93 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTSHPS |
---|---|
Seq. Order | 94 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTLOCP |
---|---|
Seq. Order | 95 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTLOCS |
---|---|
Seq. Order | 96 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTTYPP |
---|---|
Seq. Order | 97 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTTYPS |
---|---|
Seq. Order | 98 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTMSP |
---|---|
Seq. Order | 99 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTMSS |
---|---|
Seq. Order | 100 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TEDEXTMSP |
---|---|
Seq. Order | 101 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TEDEXTMSS |
---|---|
Seq. Order | 102 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTLENMCP |
---|---|
Seq. Order | 103 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTLENMCS |
---|---|
Seq. Order | 104 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTWIDMCP |
---|---|
Seq. Order | 105 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ESCAPOUTWIDMCS |
---|---|
Seq. Order | 106 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TTGCOMMENTSS |
---|---|
Seq. Order | 107 |
Data Storage Type | VARCHAR2 |
Max Length | 250 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TTGCOMMENTSP |
---|---|
Seq. Order | 108 |
Data Storage Type | VARCHAR2 |
Max Length | 250 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINERMATP |
---|---|
Seq. Order | 109 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINERMATS |
---|---|
Seq. Order | 110 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINERHUNGP |
---|---|
Seq. Order | 111 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINERHUNGS |
---|---|
Seq. Order | 112 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINERTWTYPP |
---|---|
Seq. Order | 113 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINERTWTYPS |
---|---|
Seq. Order | 114 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TEDEXTMSTYPP |
---|---|
Seq. Order | 115 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TEDEXTMSTYPS |
---|---|
Seq. Order | 116 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOE |
---|---|
Seq. Order | 117 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date of Entry of the associated record. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UOE |
---|---|
Seq. Order | 118 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Oracle user ID of the person who entered the data. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOC |
---|---|
Seq. Order | 119 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date associated record was updated. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UOC |
---|---|
Seq. Order | 120 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Oracle ID of user who made the (most recent ) change on the record. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2016-07-28 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-07-28 |
Tags |
---|