View: OBTRS
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 33577
| Published / External
Created: 2016-07-27
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 24111
ID: 33577
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | View: OBTRS |
---|---|
Short Name | OBTRS |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Observer Scallop Trip Summary Data from standard observer trips |
* 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 Scallop Trip Summary Data from standard observer trips |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
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 | CATSOAK | VARCHAR2 | Scallop meats soaked in fluid other than water. 0=no; 1=yes |
100 | No | No | CATMIX | VARCHAR2 | Indicator of whether scallop meats were mixed size. 0 = no, 1 = yes, 9 = unknown. |
100 | No | No | NBAGS | NUMBER | Total number of bags of shucked scallops for trip. |
100 | No | No | BAGAVGLB | NUMBER | Average weight of bag of shucked scallops for trip, in whole pounds. Not collected prior to May, 1994 (set to null = unknown) |
100 | No | No | TRSCOMMENTS | VARCHAR2 | Additional information regarding scallop trip. Prior to 2001 only true or false |
100 | No | No | QTR | NUMBER | Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable. |
100 | No | No | TRIPEXT | VARCHAR2 | Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable. |
100 | No | No | VTRSERNO | VARCHAR2 | Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number. |
100 | No | No | FLEET_TYPE | VARCHAR2 | Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE. |
100 | No | No | SECTOR_ID | VARCHAR2 | Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table. |
100 | No | No | VENDOR_ID | VARCHAR2 | 01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable. |
100 | No | No | HULLNUM1 | VARCHAR2 | Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable. |
100 | No | No | XTRIPDUR | NUMBER | The number of days the Captain expected to be away from port on fishing trip. |
100 | No | No | YEARSAIL | VARCHAR2 | Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable. |
100 | No | No | MONTHSAIL | VARCHAR2 | Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable. |
100 | No | No | DAYSAIL | VARCHAR2 | The day the vessel left the dock to go fishing. Collected for ASM where applicable. |
100 | No | No | TIMESAIL | VARCHAR2 | Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable. |
100 | No | No | DATESAIL | DATE | The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. |
100 | No | No | TRIPTYPE | VARCHAR2 | Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear. |
100 | No | No | HULLNUM2 | VARCHAR2 | Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown |
100 | No | No | CREW | NUMBER | The number of individuals working on the vessel, including the Captain. Null = unknown. |
100 | No | No | YEARLAND | VARCHAR2 | (Same as YEAR) Collected for ASM where applicable. |
100 | No | No | MONTHLAND | VARCHAR2 | Month vessel landed for unloading catch. Collected for ASM where applicable. |
100 | No | No | DAYLAND | VARCHAR2 | Day the vessel landed to off load catch. Collected for ASM where applicable. |
100 | No | No | TIMELAND | VARCHAR2 | Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable. |
100 | No | No | DATELAND | DATE | Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. |
100 | No | No | TMPHPORT | VARCHAR2 | 4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch. |
100 | No | No | PORT | VARCHAR2 | The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable. |
100 | No | No | PORTSAIL | VARCHAR2 | The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable. |
100 | No | No | STEAMTIM | NUMBER | Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable. |
100 | No | No | ICETONS | NUMBER | Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable. |
100 | No | No | FUELGAL | NUMBER | Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable. |
100 | No | No | DAMAGCOST | NUMBER | Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. |
100 | No | No | SUPPLYCOST | NUMBER | Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable. |
100 | No | No | FOODCOST | NUMBER | Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. |
100 | No | No | ICEPRICE | NUMBER | Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable. |
100 | No | No | FUELPRICE | NUMBER | Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable. |
100 | No | No | WATERCOST | NUMBER | Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. |
100 | No | No | OILCOST | NUMBER | Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. |
100 | No | No | BAITCOST | NUMBER | Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. |
100 | No | No | TIMELOSTCD1 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost. |
100 | No | No | TIMELOST1 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear. |
100 | No | No | TIMELOSTCD2 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
100 | No | No | TIMELOST2 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear. |
100 | No | No | TIMELOSTCD3 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to |
100 | No | No | TIMELOST3 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear. |
100 | No | No | TIMELOSTCD4 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
100 | No | No | TIMELOST4 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear. |
100 | No | No | TIMELOSTCD5 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
100 | No | No | TIMELOST5 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear. |
100 | No | No | TRPCOMMENTS | VARCHAR2 | Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable. |
100 | No | No | PERMIT1 | NUMBER | Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. |
100 | No | No | PERMIT2 | NUMBER | Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011). |
100 | No | No | DEALNUM | VARCHAR2 | Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. |
100 | No | No | DEALISS_AGENCY | VARCHAR2 | Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011). |
100 | No | No | VMSCODE | VARCHAR2 | VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011). |
Attribute Details
Attribute Name | LINK1 |
---|---|
Seq. Order | 1 |
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 | 2 |
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 | 3 |
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 | 4 |
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 | 5 |
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 | CATSOAK |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Scallop meats soaked in fluid other than water. 0=no; 1=yes |
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 | CATMIX |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicator of whether scallop meats were mixed size. 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 | NBAGS |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Total number of bags of shucked scallops for trip. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAGAVGLB |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Average weight of bag of shucked scallops for trip, in whole pounds. Not collected prior to May, 1994 (set to null = unknown) |
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 | TRSCOMMENTS |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 250 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Additional information regarding scallop trip. Prior to 2001 only true or false |
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 | QTR |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. 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 | TRIPEXT |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : 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 | VTRSERNO |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number. |
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 | FLEET_TYPE |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE. |
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 | SECTOR_ID |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID 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 | VENDOR_ID |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 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 | HULLNUM1 |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number on the hull of the vessel on which observer is deployed. See OBVESSEL 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 | XTRIPDUR |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
The number of days the Captain expected to be away from port on fishing trip. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | YEARSAIL |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Four digit year in which the vessel left dock to go fishing. 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 | MONTHSAIL |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two digit month in which vessel left dock to go fishing. 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 | DAYSAIL |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The day the vessel left the dock to go fishing. 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 | TIMESAIL |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. 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 | DATESAIL |
---|---|
Seq. Order | 23 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. |
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 | TRIPTYPE |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear. |
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 | HULLNUM2 |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to 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 | CREW |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
The number of individuals working on the vessel, including the Captain. Null = unknown. |
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 | YEARLAND |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
(Same as 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 | MONTHLAND |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month vessel landed for unloading catch. 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 | DAYLAND |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Day the vessel landed to off load catch. 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 | TIMELAND |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time vessel docked to unload catch at the end of the 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 | DATELAND |
---|---|
Seq. Order | 31 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. |
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 | TMPHPORT |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch. |
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 | PORT |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The 6-char code of the port, including state, in which vessel offloads its catch. See PORT 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 | PORTSAIL |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The 6-char code of the port, including state, from which the vessel sailed. See PORT 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 | STEAMTIM |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. 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 | ICETONS |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 2 |
Status | Active |
Description |
Estimated ice used, to the nearest hundredth of a ton. 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 | FUELGAL |
---|---|
Seq. Order | 37 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. 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 | DAMAGCOST |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. 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 | SUPPLYCOST |
---|---|
Seq. Order | 39 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. 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 | FOODCOST |
---|---|
Seq. Order | 40 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. 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 | ICEPRICE |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 2 |
Status | Active |
Description |
Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. 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 | FUELPRICE |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 2 |
Status | Active |
Description |
Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. 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 | WATERCOST |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. 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 | OILCOST |
---|---|
Seq. Order | 44 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. 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 | BAITCOST |
---|---|
Seq. Order | 45 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. 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 | TIMELOSTCD1 |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost. |
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 | TIMELOST1 |
---|---|
Seq. Order | 47 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary 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 | TIMELOSTCD2 |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIMELOST2 |
---|---|
Seq. Order | 49 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary 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 | TIMELOSTCD3 |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to |
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 | TIMELOST3 |
---|---|
Seq. Order | 51 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary 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 | TIMELOSTCD4 |
---|---|
Seq. Order | 52 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIMELOST4 |
---|---|
Seq. Order | 53 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary 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 | TIMELOSTCD5 |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIMELOST5 |
---|---|
Seq. Order | 55 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary 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 | TRPCOMMENTS |
---|---|
Seq. Order | 56 |
Data Storage Type | VARCHAR2 |
Max Length | 250 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any additional information regarding trip or expenditures.Prior to 2001 only true or false. 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 | PERMIT1 |
---|---|
Seq. Order | 57 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Vessel Permit 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 | PERMIT2 |
---|---|
Seq. Order | 58 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011). |
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 | DEALNUM |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Dealer number. See OBDEALER_MV 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 | DEALISS_AGENCY |
---|---|
Seq. Order | 60 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Dealer issuing agency, codes 9,10,11 used by NEFOP only. 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 | VMSCODE |
---|---|
Seq. Order | 61 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
VMS Fishing Area Code required for Special Access Program (SAP) trips. 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 | |
---|---|
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 | 33577 |
---|---|
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 |
---|