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

Table: C_OWNER

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

Summary

Description

a table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
REC_STATUS
CHAR 		N/A
ALLOC_NUM
CHAR 		Allocation Number
OWNER
VARCHAR2 		Owner
OWNER2
VARCHAR2 		Additional Owner
VESSEL
VARCHAR2 		Vessel
STREET
VARCHAR2 		STREET
CITY
VARCHAR2 		CITY
STATE
CHAR 		STATE
ZIP
CHAR 		ZIP
TEL
CHAR 		Telephone Number
UPD_NAME
VARCHAR2 		N/A
UPD_DATE
DATE 		N/A

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
2004-05-01 - Present

As of May 2004, SC/OQ dealers are required to submit reports electronically, consistent with the requirements for standard dealer reports.

Item Identification

Title: Table: C_OWNER
Short Name: C_OWNER
Status: Completed
Notes:

Loaded by batch 1571, 09-04-2007 12:13

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:

a table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 REC_STATUS CHAR N/A
100
 ALLOC_NUM CHAR Allocation Number
100
 OWNER VARCHAR2 Owner
100
 OWNER2 VARCHAR2 Additional Owner
100
 VESSEL VARCHAR2 Vessel
100
 STREET VARCHAR2 STREET
100
 CITY VARCHAR2 CITY
100
 STATE CHAR STATE
100
 ZIP CHAR ZIP
100
 TEL CHAR Telephone Number
100
 UPD_NAME VARCHAR2 N/A
100
 UPD_DATE DATE N/A

Attribute Details

REC_STATUS

CC ID: 13471
Seq. Order: 1
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

N/A
General Data Type: CHAR

ALLOC_NUM

CC ID: 13467
Seq. Order: 2
Data Storage Type: CHAR
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

Allocation Number
General Data Type: CHAR

OWNER

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

Owner
General Data Type: VARCHAR2

OWNER2

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

Additional Owner
General Data Type: VARCHAR2

VESSEL

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

Vessel
General Data Type: VARCHAR2

STREET

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

STREET
General Data Type: VARCHAR2

CITY

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

CITY
General Data Type: VARCHAR2

STATE

CC ID: 13472
Seq. Order: 8
Data Storage Type: CHAR
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

STATE
General Data Type: CHAR

ZIP

CC ID: 13478
Seq. Order: 9
Data Storage Type: CHAR
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

ZIP
General Data Type: CHAR

TEL

CC ID: 13474
Seq. Order: 10
Data Storage Type: CHAR
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Telephone Number
General Data Type: CHAR

UPD_NAME

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

N/A
General Data Type: VARCHAR2

UPD_DATE

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

N/A
General Data Type: DATE

Support Roles

Metadata Contact

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

Originator

CC ID: 85191
Date Effective From: 2000-01-01
Date Effective To:
Contact (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

Point of Contact

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

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 62899
Time Frame Type: Continuing
Start: 2004-05-01
Description:

As of May 2004, SC/OQ dealers are required to submit reports electronically, consistent with the requirements for standard dealer reports.

Access Information

Security Class: Confidential
Data Access Policy:

Access to dealer 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: 5009
GUID: gov.noaa.nmfs.inport:5009
Metadata Record Created By: SysAdmin InPortAdmin
Metadata Record Created: 2007-09-04 12:13+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+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