Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Analysis and Program Support Division (APSD) M... > IVR Reporting > Tilefish IVR Reporting > IVR Tilefish Database >

View: TILEFISH_DEALER_INFO_NEW

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

Summary

Abstract

Stores detailed Tilefish trip information called into the NMFS IVR call-in system, regarding dealers sold to and VTR Serial Number.

Description

Stores detailed Tilefish trip information called into the NMFS IVR call-in system, regarding dealers sold to and VTR Serial Number.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
PERMIT_NUMBER
VARCHAR2 		6 digit Federal permit number.
CONFIRMATION
VARCHAR2 		6 digit number - matches Comments field in QMDBS.VESS_TILEFISH.
DEALER_NUM
VARCHAR2 		5 digit Federal dealer number.
DE
DATE 		Date record was loaded into table.
UE
VARCHAR2 		User loading data into table.
LBS
NUMBER 		Pounds of tilefish landed on the trip.

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
2010-02-04 - Present

This table has been collecting data on tilefish trip dealer and vtr serial number since 2/4/2010.

Item Identification

Title: View: TILEFISH_DEALER_INFO_NEW
Short Name: TILEFISH_DEALER_INFO_NEW
Status: Completed
Abstract:

Stores detailed Tilefish trip information called into the NMFS IVR call-in system, regarding dealers sold to and VTR Serial Number.
Purpose:

To store dealer number(s) and VTR serial number for each tilefish trip called into the IVR system. The confirmation number in this view can be matched to the Comments field in QMDBS.VESS_TILEFISH.
Notes:

Loaded by batch 4171, 01-24-2013 17:13
Supplemental Information:

Server: NERO, Schema: IVR, Table: TILEFISH_DEALER_INFO_NEW

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None commercial
None commercial fishing
None fdsd
None fish online
None fisheries data services division
None fishery dependent data
None fso
None interactice voice response
None nero
None vessel reporting

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 2001-present

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None atlantic
None connecticut
None ct
None de
None delaware
None georges bank
None gloucester
None gulf of maine
None ma
None maine
None maryland
None massachusetts
None md
None me
None mid-atlantic
None ne
None new england
None new hampshire
None new jersey
None new york
None nh
None nj
None northeast
None northeast atlantic
None northeast u.s.
None northern atlantic
None northwest atlantic
None ny
None rhode island
None ri
None va
None virginia

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None 888-284-4904
None area
None catch
None effort
None gear
None ivr
None species

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 View
Active Version?: Yes
Schema Name: IVR
Description:

Stores detailed Tilefish trip information called into the NMFS IVR call-in system, regarding dealers sold to and VTR Serial Number.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PERMIT_NUMBER VARCHAR2 6 digit Federal permit number.
100
 CONFIRMATION VARCHAR2 6 digit number - matches Comments field in QMDBS.VESS_TILEFISH.
100
 DEALER_NUM VARCHAR2 5 digit Federal dealer number.
100
 DE DATE Date record was loaded into table.
100
 UE VARCHAR2 User loading data into table.
100
 LBS NUMBER Pounds of tilefish landed on the trip.

Attribute Details

PERMIT_NUMBER

CC ID: 88661
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

6 digit Federal permit number.
General Data Type: VARCHAR2

CONFIRMATION

CC ID: 88664
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

6 digit number - matches Comments field in QMDBS.VESS_TILEFISH.
General Data Type: VARCHAR2

DEALER_NUM

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

5 digit Federal dealer number.
General Data Type: VARCHAR2

DE

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

Date record was loaded into table.
General Data Type: DATE

UE

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

User loading data into table.
General Data Type: VARCHAR2

LBS

CC ID: 88666
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Pounds of tilefish landed on the trip.
General Data Type: NUMBER

Support Roles

Metadata Contact

CC ID: 89484
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: 89485
Date Effective From: 2010-01-01
Date Effective To:
Contact (Person): Ortiz, Ken J
Address: 55 Great Republic Drive
Gloucester, MA 01930
USA
Email Address: ken.ortiz@noaa.gov
Phone: (978)281-9316
Business Hours: 8:00 a.m. - 5:30 p.m. EST

Point of Contact

CC ID: 89461
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: 89519
Time Frame Type: Continuing
Start: 2010-02-04
Description:

This table has been collecting data on tilefish trip dealer and vtr serial number since 2/4/2010.

Access Information

Security Class: Confidential
Security Classification System:

IVR reports are considered to be business confidential and may not be released without signed approval of the permit holder on record for the time period requested.
Data Access Policy:

Access to IVR 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: 17891
GUID: gov.noaa.nmfs.inport:17891
Metadata Record Created By: Denise A Washick
Metadata Record Created: 2013-01-24 17:13+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+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