Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Analysis and Program Support Division (APSD) M... > Vessel Logbook Reporting > Surfclam/Ocean Quahog (SC/OQ) Logbook > SC/OQ Vessel Database >

Table: SFOQPR

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:11923  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Extents
Access Info
Catalog Details

Summary

Abstract

Main Surf Clam/Ocean Quahog dealer/processor report information table.

Description

Holds data for SF/OQ dealer/processor logbook main records.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PR_REC_ID
NUMBER 		Unique record identification number; generated by the system at data entry.
DNUM
NUMBER 		Dealer permit number.
NUM
NUMBER 		Vessel permit number.
PD
DATE 		Purchase date.
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.
CAT
NUMBER 		Category of catch. Surf Clam=1; Ocean Quahog=6.
BUSH
NUMBER 		Number of bushels landed (32 cages = 1 bushel).
PRICE
NUMBER 		Price per bushel in dollars.
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.
COMMENTS
VARCHAR2 		Comments.
DELETED
VARCHAR2 		Not Used.
LOADSOURCE
VARCHAR2 		U for Upload.

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: SFOQPR
Short Name: SFOQPR
Status: Completed
Abstract:

Main Surf Clam/Ocean Quahog dealer/processor report information table.
Purpose:

Holds data for SF/OQ dealer/processor logbook main records.
Notes:

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

Server: NERO

Schema: SFCLAM

Table: SFOQPR (Surf Clam-Ocean Quahog-Processor 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 dealer/processor logbook main records.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PR_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
 PD DATE Purchase date.
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
 CAT NUMBER Category of catch. Surf Clam=1; Ocean Quahog=6.
100
 BUSH NUMBER Number of bushels landed (32 cages = 1 bushel).
100
 PRICE NUMBER Price per bushel in dollars.
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
 COMMENTS VARCHAR2 Comments.
100
 DELETED VARCHAR2 Not Used.
100
 LOADSOURCE VARCHAR2 U for Upload.

Attribute Details

PR_REC_ID

CC ID: 46121
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: 46137
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: 46129
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

PD

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

Purchase date.
General Data Type: DATE

ST

CC ID: 46136
Seq. Order: 5
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: 46130
Seq. Order: 6
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: 46125
Seq. Order: 7
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

CAT

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

Category of catch. Surf Clam=1; Ocean Quahog=6.
General Data Type: NUMBER

BUSH

CC ID: 46122
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

PRICE

CC ID: 46128
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Price per bushel in dollars.
General Data Type: NUMBER

DE

CC ID: 46131
Seq. Order: 11
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: 46133
Seq. Order: 12
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: 46126
Seq. Order: 13
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: 46124
Seq. Order: 14
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

COMMENTS

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

Comments.
General Data Type: VARCHAR2

DELETED

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

Not Used.
General Data Type: VARCHAR2

LOADSOURCE

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

U for Upload.
General Data Type: VARCHAR2

Support Roles

Metadata Contact

CC ID: 61224
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: 61223
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: 62903
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: 11923
GUID: gov.noaa.nmfs.inport:11923
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