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_ALLOC

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

Summary

Abstract

Holds data for holders' allocation ratios (percentage of the whole) of sfclam and quahog yearly allocation quotas

Description

Holds data for holders' allocation ratios (percentage of the whole) of sfclam and quahog yearly allocation quotas

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
REC_STATUS
CHAR 		Record status - C or P - current or previous
TX_NUM
NUMBER 		transaction number - system generated number that links credit, debit and allocation transfer transactions together
ALLOC_NUM
CHAR 		Holder's allocation number
ALLOC_FROM
CHAR 		Allocation number of a holder from whom an allocation was transferred.
NUM_CAGES
NUMBER 		Number of cages held by the allocation holder
NUM_BUSHELS
NUMBER 		Number of bushels held by the allocation holder (32 cages = 1 bushel)
RATIO
NUMBER 		Allocation holder's percentage of the whole yearly allocation quota
TR_DATE
DATE 		Date of transfer or date of transaction - Date an allocation was transferred
UPD_NAME
VARCHAR2 		Update name - User that changed the allocation record
UPD_DATE
DATE 		Update date - Date the allocation record was changed

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

Holds data for holders' allocation ratios (percentage of the whole) of sfclam and quahog yearly allocation quotas
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:

Holds data for holders' allocation ratios (percentage of the whole) of sfclam and quahog yearly allocation quotas

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 REC_STATUS CHAR Record status - C or P - current or previous
100
 TX_NUM NUMBER transaction number - system generated number that links credit, debit and allocation transfer transactions together
100
 ALLOC_NUM CHAR Holder's allocation number
100
 ALLOC_FROM CHAR Allocation number of a holder from whom an allocation was transferred.
100
 NUM_CAGES NUMBER Number of cages held by the allocation holder
100
 NUM_BUSHELS NUMBER Number of bushels held by the allocation holder (32 cages = 1 bushel)
100
 RATIO NUMBER Allocation holder's percentage of the whole yearly allocation quota
100
 TR_DATE DATE Date of transfer or date of transaction - Date an allocation was transferred
100
 UPD_NAME VARCHAR2 Update name - User that changed the allocation record
100
 UPD_DATE DATE Update date - Date the allocation record was changed

Attribute Details

REC_STATUS

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

Record status - C or P - current or previous
General Data Type: CHAR

TX_NUM

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

transaction number - system generated number that links credit, debit and allocation transfer transactions together
General Data Type: NUMBER

ALLOC_NUM

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

Holder's allocation number
General Data Type: CHAR

ALLOC_FROM

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

Allocation number of a holder from whom an allocation was transferred.
General Data Type: CHAR

NUM_CAGES

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

Number of cages held by the allocation holder
General Data Type: NUMBER

NUM_BUSHELS

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

Number of bushels held by the allocation holder (32 cages = 1 bushel)
General Data Type: NUMBER

RATIO

CC ID: 13439
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 9
Status: Active
Description:

Allocation holder's percentage of the whole yearly allocation quota
General Data Type: NUMBER

TR_DATE

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

Date of transfer or date of transaction - Date an allocation was transferred
General Data Type: DATE

UPD_NAME

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

Update name - User that changed the allocation record
General Data Type: VARCHAR2

UPD_DATE

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

Update date - Date the allocation record was changed
General Data Type: DATE

Support Roles

Metadata Contact

CC ID: 85181
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: 85182
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: 85180
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: 62896
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: 5006
GUID: gov.noaa.nmfs.inport:5006
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