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

View: EFP_BASE_NEW

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:17889  |  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 Exempted Fishery Program trip information called into the NMFS IVR call-in system by vessels participating in Exempted Fishery Programs with IVR reporting requirements.

Description

Stores Exempted Fishery Program trip information called into the NMFS IVR call-in system.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
PASSCODE
VARCHAR2 		4 or 5-digit Exempted Fishery Program project code.
PERMIT
NUMBER 		Federally issued 6-digit vessel permit number.
SPP2
VARCHAR2 		2 digit species code.
STATE_CODE
VARCHAR2 		2 digit state code where fish were landed.
LBS_KEPT
NUMBER 		Total pounds of fish kept.
LBS_DISC
NUMBER 		Total pounds of fish discarded.
DATE_START
DATE 		Trip start date.
DATE_END
DATE 		Trip end date.
TRIP_STATUS
VARCHAR2 		Open, Closed, Incomplete, I (Open) or C (Closed).
UC
VARCHAR2 		The user who made the latest change to the column.
DC
DATE 		Date a change is made to the column.
CONFIRMATION_NUM
VARCHAR2 		Confirmation number given to caller when a trip is ended.
TIME_IN
DATE 		Records the start time of the latest call to the system.
TIME_OUT
DATE 		Records the end time of the latest call to the system.

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
2005 - Present

This program started in January 2005 and is ongoing.

Item Identification

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

Stores Exempted Fishery Program trip information called into the NMFS IVR call-in system by vessels participating in Exempted Fishery Programs with IVR reporting requirements.
Purpose:

To store trip-level data called into the NMFS IVR system by vessels participating in Exempted Fishery projects. Data collected includes Exempted Fishery project code, date trip started, date trip ended, species landed, total pounds kept and discarded, and state where fish were landed.
Notes:

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

Relational database.

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 Exempted Fishery Program trip information called into the NMFS IVR call-in system.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PASSCODE VARCHAR2 4 or 5-digit Exempted Fishery Program project code.
100
 PERMIT NUMBER Federally issued 6-digit vessel permit number.
100
 SPP2 VARCHAR2 2 digit species code.
100
 STATE_CODE VARCHAR2 2 digit state code where fish were landed.
100
 LBS_KEPT NUMBER Total pounds of fish kept.
100
 LBS_DISC NUMBER Total pounds of fish discarded.
100
 DATE_START DATE Trip start date.
100
 DATE_END DATE Trip end date.
100
 TRIP_STATUS VARCHAR2 Open, Closed, Incomplete, I (Open) or C (Closed).
100
 UC VARCHAR2 The user who made the latest change to the column.
100
 DC DATE Date a change is made to the column.
100
 CONFIRMATION_NUM VARCHAR2 Confirmation number given to caller when a trip is ended.
100
 TIME_IN DATE Records the start time of the latest call to the system.
100
 TIME_OUT DATE Records the end time of the latest call to the system.

Attribute Details

PASSCODE

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

4 or 5-digit Exempted Fishery Program project code.
General Data Type: VARCHAR2

PERMIT

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

Federally issued 6-digit vessel permit number.
General Data Type: NUMBER

SPP2

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

2 digit species code.
General Data Type: VARCHAR2

STATE_CODE

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

2 digit state code where fish were landed.
General Data Type: VARCHAR2

LBS_KEPT

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

Total pounds of fish kept.
General Data Type: NUMBER

LBS_DISC

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

Total pounds of fish discarded.
General Data Type: NUMBER

DATE_START

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

Trip start date.
General Data Type: DATE

DATE_END

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

Trip end date.
General Data Type: DATE

TRIP_STATUS

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

Open, Closed, Incomplete, I (Open) or C (Closed).
General Data Type: VARCHAR2

UC

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

The user who made the latest change to the column.
General Data Type: VARCHAR2

DC

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

Date a change is made to the column.
General Data Type: DATE

CONFIRMATION_NUM

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

Confirmation number given to caller when a trip is ended.
General Data Type: VARCHAR2

TIME_IN

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

Records the start time of the latest call to the system.
General Data Type: DATE

TIME_OUT

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

Records the end time of the latest call to the system.
General Data Type: DATE

Support Roles

Metadata Contact

CC ID: 89455
Date Effective From: 2005-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: 89456
Date Effective From: 2005-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: 89454
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: 89457
Time Frame Type: Continuing
Start: 2005
Description:

This program started in January 2005 and is ongoing.

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: 17889
GUID: gov.noaa.nmfs.inport:17889
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