Table: C_CREDIT
Greater Atlantic Regional Fisheries Office
Entity
(ENT)
| ID: 5007
| Published / External
Created: 2007-09-04
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 2070
ID: 5007
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: C_CREDIT |
---|---|
Short Name | C_CREDIT |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Holds data for tag ranges credited to the holder |
* Purpose | |
Notes |
Loaded by batch 1571, 09-04-2007 12:13 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
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 data for tag ranges credited to the holder |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | REC_STATUS | CHAR | Record status - C or P - current or previous |
100 | Yes | No | TX_NUM | NUMBER | transaction number - system generated number that links credit, debit and allocation transfer transactions together |
100 | Yes | No | ALLOC_NUM | CHAR | Holder's allocation number |
100 | No | No | ALLOC_FROM | CHAR | Allocation number of a holder from whom a tag range was transferred. |
100 | Yes | No | TR_TYPE | CHAR | Transfer type - P or T (permanent or temporary) |
100 | No | No | TR_DATE | DATE | Date of transfer (or date of transaction) - Date a credit was transferred |
100 | Yes | No | BEG_TAG | NUMBER | Beginning Tag |
100 | Yes | No | END_TAG | NUMBER | Ending Tag |
100 | No | No | UPD_NAME | VARCHAR2 | Update name - User that updated the database by doing a tag range transfer |
100 | No | No | UPD_DATE | DATE | Update date - Date the database was updated by doing a tag range transfer |
100 | No | No | TAG_RANGE_STATUS | VARCHAR2 | TAG_RANGE_STATUS |
Attribute Details
Attribute Name | REC_STATUS |
---|---|
Seq. Order | 1 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Record status - C or P - current or previous |
General Data Type | CHAR |
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 | TX_NUM |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
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 | ALLOC_NUM |
---|---|
Seq. Order | 3 |
Data Storage Type | CHAR |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Holder's allocation number |
General Data Type | CHAR |
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 | ALLOC_FROM |
---|---|
Seq. Order | 4 |
Data Storage Type | CHAR |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Allocation number of a holder from whom a tag range was transferred. |
General Data Type | CHAR |
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 | TR_TYPE |
---|---|
Seq. Order | 5 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Transfer type - P or T (permanent or temporary) |
General Data Type | CHAR |
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 | TR_DATE |
---|---|
Seq. Order | 6 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date of transfer (or date of transaction) - Date a credit was transferred |
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 | BEG_TAG |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 8 |
Scale | 0 |
Status | Active |
Description |
Beginning Tag |
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 | END_TAG |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 8 |
Scale | 0 |
Status | Active |
Description |
Ending Tag |
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 | UPD_NAME |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Update name - User that updated the database by doing a tag range transfer |
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 | UPD_DATE |
---|---|
Seq. Order | 10 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Update date - Date the database was updated by doing a tag range transfer |
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 | TAG_RANGE_STATUS |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
TAG_RANGE_STATUS |
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
* » 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 | |
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 | 2004-05-01 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
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 |
---|---|
* Security Classification System | |
Security Handling Description | |
• 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 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 | 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 Workflow State | Published / External |
Metadata Last Review Date | 2016-02-25 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-02-25 |
Tags |
---|