View: OBCDH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33289 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: OBCDH |
|---|---|
| Short Name: | OBCDH |
| Status: | Completed |
| Abstract: |
Observer Clam Dredge Haul Logs |
| Notes: |
Loaded by batch 8949, 07-06-2016 08:23 |
Entity Information
| Entity Type: | Data View |
|---|---|
| Active Version?: | Yes |
| Schema Name: | OBDBS |
| Description: |
Observer Clam Dredge Haul Logs |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
LINK3 | VARCHAR2 | Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable. | |
|
100
|
LINK1 | VARCHAR2 | 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. | |
|
100
|
LINK4 | VARCHAR2 | Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. | |
|
100
|
PROGRAM | VARCHAR2 | First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. | |
|
100
|
YEAR | VARCHAR2 | Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. | |
|
100
|
MONTH | VARCHAR2 | Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. | |
|
100
|
TRIPID | VARCHAR2 | May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. | |
|
100
|
TOWSPEED | NUMBER | Average towing speed over bottom, to nearest 10th of knot. | |
|
100
|
WIREOUT | NUMBER | Amount of wire paid out for haul, in whole fathoms. | |
|
100
|
CLAPOBS | VARCHAR2 | Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown. | |
|
100
|
NBUSHKEP | NUMBER | Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown. | |
|
100
|
NBUSHDIS | NUMBER | Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown. | |
|
100
|
CDHCOMMENTS | VARCHAR2 | Clam/quahog dredge haul comments. |
Attribute Details
LINK3
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 19 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
LINK1
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
LINK4
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 17 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
PROGRAM
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
YEAR
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
MONTH
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
TRIPID
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
TOWSPEED
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Average towing speed over bottom, to nearest 10th of knot. |
| General Data Type: | NUMBER |
WIREOUT
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Amount of wire paid out for haul, in whole fathoms. |
| General Data Type: | NUMBER |
CLAPOBS
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown. |
| General Data Type: | VARCHAR2 |
NBUSHKEP
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown. |
| General Data Type: | NUMBER |
NBUSHDIS
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown. |
| General Data Type: | NUMBER |
CDHCOMMENTS
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 250 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Clam/quahog dredge haul comments. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 33289 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33289 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-07-06 08:23+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-07-28 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-07-28 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-07-28 |