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: PRTAGI

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:11920  |  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 database for storing individual Surf Clam/Ocean Quahog dealer/processor tag numbers.

Description

Holds individual Surf Clam/Ocean Quahog dealer/processor tag numbers.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PR_TAGI_ID
NUMBER 		Unique record identification number; generated by the system at data entry.
PR_REC_ID
NUMBER 		Foreign key. Link to SFOQPR.
TAGNUM
NUMBER 		Individual tag number.
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.

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

Main database for storing individual Surf Clam/Ocean Quahog dealer/processor tag numbers.
Purpose:

Holds individual Surf Clam/Ocean Quahog dealer/processor tag numbers.
Notes:

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

Server: NERO

Schema: SFCLAM

Table: PRTAGI (Processor Report-Tag-Individual)

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 nh
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 individual Surf Clam/Ocean Quahog dealer/processor tag numbers.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PR_TAGI_ID NUMBER Unique record identification number; generated by the system at data entry.
100
 PR_REC_ID NUMBER Foreign key. Link to SFOQPR.
100
 TAGNUM NUMBER Individual tag number.
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.

Attribute Details

PR_TAGI_ID

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

PR_REC_ID

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

Foreign key. Link to SFOQPR.
General Data Type: NUMBER

TAGNUM

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

Individual tag number.
General Data Type: NUMBER

DE

CC ID: 46105
Seq. Order: 4
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: 46104
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

User loading data into table.
General Data Type: VARCHAR2

DC

CC ID: 46100
Seq. Order: 6
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: 46102
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

User making most recent update(s) to record.
General Data Type: VARCHAR2

Support Roles

Metadata Contact

CC ID: 61215
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: 61214
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: 62900
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: 11920
GUID: gov.noaa.nmfs.inport:11920
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