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_DEBIT

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:5008  |  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 debited from the holder

Description

Holds data for tag ranges debited from 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_TO
CHAR 		Allocation number of a holder to whom a tag range was transferred.
TR_TYPE
CHAR 		Transaction type
TR_DATE
DATE 		Transaction date
BEG_TAG
NUMBER 		Beginning tag
END_TAG
NUMBER 		Ending tag
UPD_NAME
VARCHAR2 		Updated Name
UPD_DATE
DATE 		Updated date
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_DEBIT
Short Name: C_DEBIT
Status: Completed
Abstract:

Holds data for tag ranges debited from 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 debited from 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_TO CHAR Allocation number of a holder to whom a tag range was transferred.
100
 TR_TYPE CHAR Transaction type
100
 TR_DATE DATE Transaction date
100
 BEG_TAG NUMBER Beginning tag
100
 END_TAG NUMBER Ending tag
100
 UPD_NAME VARCHAR2 Updated Name
100
 UPD_DATE DATE Updated date
100
 TAG_RANGE_STATUS VARCHAR2 TAG_RANGE_STATUS

Attribute Details

REC_STATUS

CC ID: 13460
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: 13464
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: 13456
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_TO

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

Allocation number of a holder to whom a tag range was transferred.
General Data Type: CHAR

TR_TYPE

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

Transaction type
General Data Type: CHAR

TR_DATE

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

Transaction date
General Data Type: DATE

BEG_TAG

CC ID: 13458
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: 13459
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: 13466
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Updated Name
General Data Type: VARCHAR2

UPD_DATE

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

Updated date
General Data Type: DATE

TAG_RANGE_STATUS

CC ID: 13461
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: 85187
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: 85188
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: 85186
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: 62898
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: 5008
GUID: gov.noaa.nmfs.inport:5008
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