View: OBPSH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33309 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Observer Purse Seine Hauls
DescriptionObserver Purse Seine Hauls
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
LINK3
VARCHAR2 |
Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable. |
LINK4
VARCHAR2 |
Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. |
LINK1
VARCHAR2 |
15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. |
PROGRAM
VARCHAR2 |
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
YEAR
VARCHAR2 |
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
MONTH
VARCHAR2 |
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
TRIPID
VARCHAR2 |
May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. |
HAULNUM
VARCHAR2 |
Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. |
GEARNUM
VARCHAR2 |
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. |
SETSPEED
NUMBER |
Speed of vessel setting net during set, nearest 10th of knot. |
PLANEUSD
VARCHAR2 |
Indicator of whether a spotter plane was used. |
TIMEUP
VARCHAR2 |
Using 24 hour clock(0000-2359), time the spotter plane took off. |
TIMEDOWN
VARCHAR2 |
Using 24 hour clock(0000-2359), time the spotter plane landed. |
SETPLANE
VARCHAR2 |
Indicator of whether a spotter palne was used to set on school of fish. |
SETDEBRIS
VARCHAR2 |
Indicator of whether set was made on debris. |
SETSUCCESS
VARCHAR2 |
Captain felt set was successful: 0 = no, 1 = yes, 9 = unknown |
FISHLOST
VARCHAR2 |
Indicator for whether fish were lost during set. |
PUMPBEGINYEAR
VARCHAR2 |
Year in local time that fish pumping is attached to codend and initially turned on |
PUMPBEGINMONTH
VARCHAR2 |
Month in local time that fish pumping is attached to codend and initially turned on |
PUMPBEGINDAY
VARCHAR2 |
Day in local time that fish pumping is attached to codend and initially turned on |
PUMPBEGINTIME
VARCHAR2 |
Time in local time that fish pumping is attached to codend and initially turned on |
PUMPENDYEAR
VARCHAR2 |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
PUMPENDMONTH
VARCHAR2 |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
PUMPENDDAY
VARCHAR2 |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
PUMPENDTIME
VARCHAR2 |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
PSHCOMMENTS
VARCHAR2 |
Additional information re: Purse Seine Haul. |
DOE
DATE |
Date of Entry of the associated record. |
UOE
VARCHAR2 |
Oracle user ID of the person who entered the data. |
DOC
DATE |
Date associated record was updated. |
UOC
VARCHAR2 |
Oracle ID of user who made the (most recent ) change on the record. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | View: OBPSH |
---|---|
Short Name: | OBPSH |
Status: | Completed |
Abstract: |
Observer Purse Seine Hauls |
Notes: |
Loaded by batch 8949, 07-06-2016 08:23 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | OBDBS |
Description: |
Observer Purse Seine Hauls |
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
|
LINK4 | VARCHAR2 | Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. | |
100
|
LINK1 | VARCHAR2 | 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. | |
100
|
PROGRAM | VARCHAR2 | First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. | |
100
|
YEAR | VARCHAR2 | Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. | |
100
|
MONTH | VARCHAR2 | Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. | |
100
|
TRIPID | VARCHAR2 | May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. | |
100
|
HAULNUM | VARCHAR2 | Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. | |
100
|
GEARNUM | VARCHAR2 | Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. | |
100
|
SETSPEED | NUMBER | Speed of vessel setting net during set, nearest 10th of knot. | |
100
|
PLANEUSD | VARCHAR2 | Indicator of whether a spotter plane was used. | |
100
|
TIMEUP | VARCHAR2 | Using 24 hour clock(0000-2359), time the spotter plane took off. | |
100
|
TIMEDOWN | VARCHAR2 | Using 24 hour clock(0000-2359), time the spotter plane landed. | |
100
|
SETPLANE | VARCHAR2 | Indicator of whether a spotter palne was used to set on school of fish. | |
100
|
SETDEBRIS | VARCHAR2 | Indicator of whether set was made on debris. | |
100
|
SETSUCCESS | VARCHAR2 | Captain felt set was successful: 0 = no, 1 = yes, 9 = unknown | |
100
|
FISHLOST | VARCHAR2 | Indicator for whether fish were lost during set. | |
100
|
PUMPBEGINYEAR | VARCHAR2 | Year in local time that fish pumping is attached to codend and initially turned on | |
100
|
PUMPBEGINMONTH | VARCHAR2 | Month in local time that fish pumping is attached to codend and initially turned on | |
100
|
PUMPBEGINDAY | VARCHAR2 | Day in local time that fish pumping is attached to codend and initially turned on | |
100
|
PUMPBEGINTIME | VARCHAR2 | Time in local time that fish pumping is attached to codend and initially turned on | |
100
|
PUMPENDYEAR | VARCHAR2 | Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. | |
100
|
PUMPENDMONTH | VARCHAR2 | Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. | |
100
|
PUMPENDDAY | VARCHAR2 | Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. | |
100
|
PUMPENDTIME | VARCHAR2 | Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. | |
100
|
PSHCOMMENTS | VARCHAR2 | Additional information re: Purse Seine Haul. | |
100
|
DOE | DATE | Date of Entry of the associated record. | |
100
|
UOE | VARCHAR2 | Oracle user ID of the person who entered the data. | |
100
|
DOC | DATE | Date associated record was updated. | |
100
|
UOC | VARCHAR2 | Oracle ID of user who made the (most recent ) change on the record. |
Attribute Details
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 |
LINK4
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 17 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
LINK1
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
PROGRAM
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 |
HAULNUM
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
GEARNUM
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
SETSPEED
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 2 |
Status: | Active |
Description: |
Speed of vessel setting net during set, nearest 10th of knot. |
General Data Type: | NUMBER |
PLANEUSD
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether a spotter plane was used. |
General Data Type: | VARCHAR2 |
TIMEUP
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Using 24 hour clock(0000-2359), time the spotter plane took off. |
General Data Type: | VARCHAR2 |
TIMEDOWN
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Using 24 hour clock(0000-2359), time the spotter plane landed. |
General Data Type: | VARCHAR2 |
SETPLANE
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether a spotter palne was used to set on school of fish. |
General Data Type: | VARCHAR2 |
SETDEBRIS
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether set was made on debris. |
General Data Type: | VARCHAR2 |
SETSUCCESS
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Captain felt set was successful: 0 = no, 1 = yes, 9 = unknown |
General Data Type: | VARCHAR2 |
FISHLOST
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator for whether fish were lost during set. |
General Data Type: | VARCHAR2 |
PUMPBEGINYEAR
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year in local time that fish pumping is attached to codend and initially turned on |
General Data Type: | VARCHAR2 |
PUMPBEGINMONTH
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month in local time that fish pumping is attached to codend and initially turned on |
General Data Type: | VARCHAR2 |
PUMPBEGINDAY
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day in local time that fish pumping is attached to codend and initially turned on |
General Data Type: | VARCHAR2 |
PUMPBEGINTIME
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish pumping is attached to codend and initially turned on |
General Data Type: | VARCHAR2 |
PUMPENDYEAR
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
General Data Type: | VARCHAR2 |
PUMPENDMONTH
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
General Data Type: | VARCHAR2 |
PUMPENDDAY
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
General Data Type: | VARCHAR2 |
PUMPENDTIME
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
General Data Type: | VARCHAR2 |
PSHCOMMENTS
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information re: Purse Seine Haul. |
General Data Type: | VARCHAR2 |
DOE
Seq. Order: | 27 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of Entry of the associated record. |
General Data Type: | DATE |
UOE
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle user ID of the person who entered the data. |
General Data Type: | VARCHAR2 |
DOC
Seq. Order: | 29 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date associated record was updated. |
General Data Type: | DATE |
UOC
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle ID of user who made the (most recent ) change on the record. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33309 |
---|---|
GUID: | gov.noaa.nmfs.inport:33309 |
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 |