Table: PRTAGR

Greater Atlantic Regional Fisheries Office
Entity (ENT) | ID: 11921 | Published / External
Created: 2012-03-09   |   Last Modified: 2022-08-09

Parent: SC/OQ Vessel Database
Data Set (DS) | ID: 1503

ID: 11921
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: PRTAGR
Short Name PRTAGR
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

Main database for storing ranges of Surf Clam/Ocean Quahog dealer/processor tag numbers.
* Purpose

Holds ranges of Surf Clam/Ocean Quahog dealer/processor tag numbers.
Notes

Loaded by batch 2887, 03-09-2012 12:19
Other Citation Details
• Supplemental Information

Server: NERO

Schema: SFCLAM

Table: PRTAGR (Processor Report-Tag-Range)
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

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

Temporal Keywords

Thesaurus Keyword
None 1978-present
   
   
   

* Spatial Keywords

Thesaurus Keyword
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
None area
None gear
None species
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

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? Y
Alias  
Schema Name SFCLAM
» Description

Holds ranges of Surf Clam/Ocean Quahog dealer/processor tag numbers.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes Yes PR_TAGR_ID NUMBER Unique record identification number; generated by the system at data entry.
100 No No PR_REC_ID NUMBER Foreign key. Link to SFOQPR.
100 Yes No BEGTAG NUMBER First tag number in series.
100 Yes No ENDTAG NUMBER Last tag number in series.
100 No No DE DATE Date record was loaded into table.
100 No No UE VARCHAR2 User loading data into table.
100 No No DC DATE Date of most recent update(s) to record.
100 No No UC VARCHAR2 User making most recent update(s) to record.

Attribute Details

Attribute Name PR_TAGR_ID
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PR_REC_ID
Seq. Order 2
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 6
Scale 0
Status Active
Description

Foreign key. Link to SFOQPR.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BEGTAG
Seq. Order 3
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 8
Scale 0
Status Active
Description

First tag number in series.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ENDTAG
Seq. Order 4
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 8
Scale 0
Status Active
Description

Last tag number in series.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DE
Seq. Order 5
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Date record was loaded into table.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name UE
Seq. Order 6
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

User loading data into table.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DC
Seq. Order 7
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Date of most recent update(s) to record.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name UC
Seq. Order 8
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

User making most recent update(s) to record.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role Metadata Contact
* » Date Effective From 2010-01-01
Date Effective To
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
Mobile  
URL  
Business Hours  
Contact Instructions
* » Support Role Originator
* » Date Effective From 2000-01-01
Date Effective To 2010-01-01
Person Power, Gregory
Address 55 Great Republic Drive
Gloucester, MA 01930
USA
Email Address greg.power@noaa.gov
Phone 978-281-9304
Fax 978-281-9161
Mobile  
URL  
Business Hours  
Contact Instructions
* » Support Role Point of Contact
* » Date Effective From 2010-01-01
Date Effective To
Person St Cyr, James R
Address 55 Great Republic Drive
Gloucester, MA 01930
USA
Email Address james.stcyr@noaa.gov
Phone 978-281-9369
Fax  
Mobile  
URL  
Business Hours  
Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame 1

* » Time Frame Type Continuing
* » Start 1978
End  
Alternate Start As Of Info  
Alternate End As Of Info  
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.
Security Handling Description
• 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 Access Constraints
Metadata Use Constraints

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

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 11921
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 Workflow State Published / External
Metadata Last Review Date 2016-02-25
Metadata Review Frequency 1 Year
Metadata Next Review Date 2017-02-25
Tags