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_CREDIT

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:5007  |  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 tag ranges credited to the holder

Description

Holds data for tag ranges credited to the holder

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 a tag range was transferred.
TR_TYPE
CHAR 		Transfer type - P or T (permanent or temporary)
TR_DATE
DATE 		Date of transfer (or date of transaction) - Date a credit was transferred
BEG_TAG
NUMBER 		Beginning Tag
END_TAG
NUMBER 		Ending Tag
UPD_NAME
VARCHAR2 		Update name - User that updated the database by doing a tag range transfer
UPD_DATE
DATE 		Update date - Date the database was updated by doing a tag range transfer
TAG_RANGE_STATUS
VARCHAR2 		TAG_RANGE_STATUS

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

Holds data for tag ranges credited to the holder
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 tag ranges credited to the holder

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 a tag range was transferred.
100
 TR_TYPE CHAR Transfer type - P or T (permanent or temporary)
100
 TR_DATE DATE Date of transfer (or date of transaction) - Date a credit was transferred
100
 BEG_TAG NUMBER Beginning Tag
100
 END_TAG NUMBER Ending Tag
100
 UPD_NAME VARCHAR2 Update name - User that updated the database by doing a tag range transfer
100
 UPD_DATE DATE Update date - Date the database was updated by doing a tag range transfer
100
 TAG_RANGE_STATUS VARCHAR2 TAG_RANGE_STATUS

Attribute Details

REC_STATUS

CC ID: 13449
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: 13453
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: 13446
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: 13445
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 a tag range was transferred.
General Data Type: CHAR

TR_TYPE

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

Transfer type - P or T (permanent or temporary)
General Data Type: CHAR

TR_DATE

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

Date of transfer (or date of transaction) - Date a credit was transferred
General Data Type: DATE

BEG_TAG

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

Beginning Tag
General Data Type: NUMBER

END_TAG

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

Ending Tag
General Data Type: NUMBER

UPD_NAME

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

Update name - User that updated the database by doing a tag range transfer
General Data Type: VARCHAR2

UPD_DATE

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

Update date - Date the database was updated by doing a tag range transfer
General Data Type: DATE

TAG_RANGE_STATUS

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

TAG_RANGE_STATUS
General Data Type: VARCHAR2

Support Roles

Metadata Contact

CC ID: 85184
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: 85185
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: 85183
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: 62897
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: 5007
GUID: gov.noaa.nmfs.inport:5007
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