Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Extents
Access Info
Catalog Details

Summary

Abstract

Main Surf Clam/Ocean Quahog vessel logbook table.

Description

Holds data for SF/OQ vessel logbook records.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VR_REC_ID
NUMBER
Unique record identification number; generated by the system at data entry.
DNUM
NUMBER
Dealer permit number.
NUM
NUMBER
Vessel permit number.
CD
DATE
Catch date.
LAT
VARCHAR2
Latitude degrees concatenated with latitude minutes.
LON
VARCHAR2
Longitude degrees concatenated with longitude minutes.
TAS
NUMBER
Time at sea (tenths of hours).
TF
NUMBER
Time fished (tenths of hours).
BUSH
NUMBER
Number of bushels landed (32 cages = 1 bushel).
DISP
NUMBER
Percent of catch discarded by the vessel.
ST
VARCHAR2
2 digit state code. Link to VTR.PORT.STATECD.
PC
VARCHAR2
2 digit port code. Link to VTR.PORT.PORT2.
CY
VARCHAR2
2 digit county code. Link to VTR.PORT.COUNTYCD.
PR
NUMBER
Price per bushel in dollars.
ANUM
VARCHAR2
Allocation number.
TRIP_NUM
NUMBER
Trip number. Set automatically by application. User may override but not set directly.
DE
DATE
Date record was loaded into table.
UE
VARCHAR2
User loading data into table.
DC
DATE
Date of most recent update(s) to record.
UC
VARCHAR2
User making most recent update(s) to record.
LORAN1
VARCHAR2
Loran bearing 1.
LORAN2
VARCHAR2
Loran bearing 2.
CHANGE
VARCHAR2
Change flag. T indicates user forced retention of previous trip number.
CAREA
VARCHAR2
Calculated area.
CLATDEG
VARCHAR2
Calculated latitude degrees.
CLATMIN
VARCHAR2
Calculated latitude minutes.
CLATSEC
VARCHAR2
Calculated latitude seconds.
CLONDEG
VARCHAR2
Calculated longitude degrees.
CLONMIN
VARCHAR2
Calculated longitude minutes.
CLONSEC
VARCHAR2
Calculated longitude seconds.
CFZONE
VARCHAR2
Calculated fishing zone.
CQDSQ
VARCHAR2
Calculated quarter-degree square.
CTNMS
VARCHAR2
Calculated ten minute square.
CERRNO
NUMBER
Calculated error code. Codes range from 1-12.

Child Items

No Child Items for this record.

Contact Information

Point of Contact
James R St Cyr
james.stcyr@noaa.gov
978-281-9369

Metadata Contact
Alison Ferguson
alison.ferguson@noaa.gov
978-281-9209

Extents

Time Frame 1
1978 - Present

Beginning in 1978, participation in the surf clam fishery became conditional upon a set of requirements including detailed logbook reporting. In the early 1980's ocean quahog vessels became subject to the same detailed logbook reporting requirements.

Item Identification

Title: Table: SFOQVR
Short Name: SFOQVR
Status: Completed
Abstract:

Main Surf Clam/Ocean Quahog vessel logbook table.

Purpose:

Holds data for SF/OQ vessel logbook records.

Notes:

Loaded by batch 2887, 03-09-2012 12:19

Supplemental Information:

Server: NERO

Schema: SFCLAM

Table: SFOQVR (Surf Clam-Ocean Quahog-Vessel Report)

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None individual transferable quota
None itq
None ocean quahog
None oq
None quota monitoring
None sc
None sc/oq
None surf clam
None surfclam
None vessel logbook reporting
None vessel reporting

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 1978-present

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None atlantic
None connecticut
None ct
None de
None delaware
None gloucester
None ma
None maine
None maryland
None massachusetts
None md
None me
None ne
None nero
None new england
None new hampshire
None new jersey
None new york
None nj
None northeast
None ny
None rhode island
None ri
None va
None virginia

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None area
None gear
None species

Physical Location

Organization: Greater Atlantic Regional Fisheries Office
City: Gloucester
State/Province: MA
Country: USA
Location Description:

Fisheries Data Services Division (FDSD)

55 Great Republic Drive

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SFCLAM
Description:

Holds data for SF/OQ vessel logbook records.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key VR_REC_ID NUMBER Unique record identification number; generated by the system at data entry.
100
DNUM NUMBER Dealer permit number.
100
NUM NUMBER Vessel permit number.
100
CD DATE Catch date.
100
LAT VARCHAR2 Latitude degrees concatenated with latitude minutes.
100
LON VARCHAR2 Longitude degrees concatenated with longitude minutes.
100
TAS NUMBER Time at sea (tenths of hours).
100
TF NUMBER Time fished (tenths of hours).
100
BUSH NUMBER Number of bushels landed (32 cages = 1 bushel).
100
DISP NUMBER Percent of catch discarded by the vessel.
100
ST VARCHAR2 2 digit state code. Link to VTR.PORT.STATECD.
100
PC VARCHAR2 2 digit port code. Link to VTR.PORT.PORT2.
100
CY VARCHAR2 2 digit county code. Link to VTR.PORT.COUNTYCD.
100
PR NUMBER Price per bushel in dollars.
100
ANUM VARCHAR2 Allocation number.
100
TRIP_NUM NUMBER Trip number. Set automatically by application. User may override but not set directly.
100
DE DATE Date record was loaded into table.
100
UE VARCHAR2 User loading data into table.
100
DC DATE Date of most recent update(s) to record.
100
UC VARCHAR2 User making most recent update(s) to record.
100
LORAN1 VARCHAR2 Loran bearing 1.
100
LORAN2 VARCHAR2 Loran bearing 2.
100
CHANGE VARCHAR2 Change flag. T indicates user forced retention of previous trip number.
100
CAREA VARCHAR2 Calculated area.
100
CLATDEG VARCHAR2 Calculated latitude degrees.
100
CLATMIN VARCHAR2 Calculated latitude minutes.
100
CLATSEC VARCHAR2 Calculated latitude seconds.
100
CLONDEG VARCHAR2 Calculated longitude degrees.
100
CLONMIN VARCHAR2 Calculated longitude minutes.
100
CLONSEC VARCHAR2 Calculated longitude seconds.
100
CFZONE VARCHAR2 Calculated fishing zone.
100
CQDSQ VARCHAR2 Calculated quarter-degree square.
100
CTNMS VARCHAR2 Calculated ten minute square.
100
CERRNO NUMBER Calculated error code. Codes range from 1-12.

Attribute Details

VR_REC_ID

CC ID: 46138
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 6
Scale: 0
Status: Active
Description:

Unique record identification number; generated by the system at data entry.

General Data Type: NUMBER

DNUM

CC ID: 46148
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Dealer permit number.

General Data Type: NUMBER

NUM

CC ID: 46170
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Vessel permit number.

General Data Type: NUMBER

CD

CC ID: 46169
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Catch date.

General Data Type: DATE

LAT

CC ID: 46163
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees concatenated with latitude minutes.

General Data Type: VARCHAR2

LON

CC ID: 46152
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees concatenated with longitude minutes.

General Data Type: VARCHAR2

TAS

CC ID: 46144
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Time at sea (tenths of hours).

General Data Type: NUMBER

TF

CC ID: 46141
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Time fished (tenths of hours).

General Data Type: NUMBER

BUSH

CC ID: 46143
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of bushels landed (32 cages = 1 bushel).

General Data Type: NUMBER

DISP

CC ID: 46154
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Percent of catch discarded by the vessel.

General Data Type: NUMBER

ST

CC ID: 46151
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2 digit state code. Link to VTR.PORT.STATECD.

General Data Type: VARCHAR2

PC

CC ID: 46171
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2 digit port code. Link to VTR.PORT.PORT2.

General Data Type: VARCHAR2

CY

CC ID: 46146
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2 digit county code. Link to VTR.PORT.COUNTYCD.

General Data Type: VARCHAR2

PR

CC ID: 46155
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Price per bushel in dollars.

General Data Type: NUMBER

ANUM

CC ID: 46160
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Allocation number.

General Data Type: VARCHAR2

TRIP_NUM

CC ID: 46150
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Trip number. Set automatically by application. User may override but not set directly.

General Data Type: NUMBER

DE

CC ID: 46158
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date record was loaded into table.

General Data Type: DATE

UE

CC ID: 46167
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

User loading data into table.

General Data Type: VARCHAR2

DC

CC ID: 46157
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of most recent update(s) to record.

General Data Type: DATE

UC

CC ID: 46139
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

User making most recent update(s) to record.

General Data Type: VARCHAR2

LORAN1

CC ID: 46164
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Loran bearing 1.

General Data Type: VARCHAR2

LORAN2

CC ID: 46159
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Loran bearing 2.

General Data Type: VARCHAR2

CHANGE

CC ID: 46161
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Change flag. T indicates user forced retention of previous trip number.

General Data Type: VARCHAR2

CAREA

CC ID: 46165
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Calculated area.

General Data Type: VARCHAR2

CLATDEG

CC ID: 46153
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Calculated latitude degrees.

General Data Type: VARCHAR2

CLATMIN

CC ID: 46166
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Calculated latitude minutes.

General Data Type: VARCHAR2

CLATSEC

CC ID: 46140
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Calculated latitude seconds.

General Data Type: VARCHAR2

CLONDEG

CC ID: 46149
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Calculated longitude degrees.

General Data Type: VARCHAR2

CLONMIN

CC ID: 46145
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Calculated longitude minutes.

General Data Type: VARCHAR2

CLONSEC

CC ID: 46156
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Calculated longitude seconds.

General Data Type: VARCHAR2

CFZONE

CC ID: 46162
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Calculated fishing zone.

General Data Type: VARCHAR2

CQDSQ

CC ID: 46142
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Calculated quarter-degree square.

General Data Type: VARCHAR2

CTNMS

CC ID: 46168
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Calculated ten minute square.

General Data Type: VARCHAR2

CERRNO

CC ID: 46147
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Calculated error code. Codes range from 1-12.

General Data Type: NUMBER

Support Roles

Metadata Contact

CC ID: 61227
Date Effective From: 2010-01-01
Date Effective To:
Contact (Person): Ferguson, Alison
Address: 55 Great Republic Drive
Gloucester, MA 01930
United States
Email Address: alison.ferguson@noaa.gov
Phone: 978-281-9209
Fax: 978-281-9161

Point of Contact

CC ID: 61226
Date Effective From: 2010-01-01
Date Effective To:
Contact (Person): St Cyr, James R
Address: 55 Great Republic Drive
Gloucester, MA 01930
USA
Email Address: james.stcyr@noaa.gov
Phone: 978-281-9369
View Historical Support Roles

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 62904
Time Frame Type: Continuing
Start: 1978
Description:

Beginning in 1978, participation in the surf clam fishery became conditional upon a set of requirements including detailed logbook reporting. In the early 1980's ocean quahog vessels became subject to the same detailed logbook reporting requirements.

Access Information

Security Class: Confidential
Security Classification System:

Vessel trip reports are considered to be business confidential and may not be released without signed approval of the permit holder on record for the time period requested.

Data Access Policy:

Access to VTR data is governed by 50CFR600 - Confidentiality of Information. Access by state fishery management agency staff and Fisheries Management Council staff may be allowed through Memorandum of Understanding that are signed by the NE Regional Administrator and Directors of the State Agency or Councils that describe the need and uses of the data and list the individuals who will have access to the data. Contractors may be granted access provided they are working under contract to NOAA or a cooperating partner (state, Council, Commission) on a specific project under the oversight of a partner.

Data Access Procedure:

Contact POC to request access.

Data Access Constraints:

Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel. The APSD Data Request staff are the POC for non-disclosure forms.

Data Use Constraints:

Access to individual reports is restricted to NOAA employees and our partners who have signed non-disclosure agreements. Summary data may be made available based on the "rule of 3", i.e., there must be at least three entities included in a summary for the summary information to be made publically available. Data may be made available if there is no information included that could uniquely link the information to an individual entity (person, vessel operating unit, business, etc.). Individually identifiable information may not be released without written authorization from the provider or by court order.

Metadata Use Constraints:

There are no constraints on the use of the metadata associated with this program.

Catalog Details

Catalog Item ID: 11924
GUID: gov.noaa.nmfs.inport:11924
Metadata Record Created By: Patrick R Rohan
Metadata Record Created: 2012-03-09 12:19+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-02-25
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-02-25
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-02-25