27501
U.S. Caribbean Commercial Landings (CCL) Tables in new format since July 2011 for U.S. Virgin Islands and January 2012 for Puerto Rico
Commercial U.S. Caribbean Landings (new format) since July 2011
Data Set
Published / External
20884
Commercial Fisheries Landings for U.S. Caribbean
Project
Completed
During the period of 2011-2012 a new series of logbook forms were developed for Puerto Rico and the US Virgin Islands. These forms were designed as the first step in providing improved commercial landings catch and effort data for the US Caribbean. They are multi-species trip-based forms with the Puerto Rico form divided by species groupings, and the USVI forms divided by gears with the primary species caught by each gear listed for each gear type. A new set of tables was created in 2011 to house US Caribbean Commercial Landings (CCL) data. These tables are separate from the Accumulated Landings System (ALS) data tables for the landings, although the data are currently passed on to the ALS tables on a regular bi-weekly basis from the CCL. The data in the CCL begins on January 1, 2012 for Puerto RIco and July 1, 2011 for the USVI. The tables are designed to house information from 4 different surveys, each having its own multi-species reporting form: 1 from Puerto Rico, 2 from St. Thomas/St. John (traps, other gear groups), and 1 from St. Croix (all gears). They also house data from a monthly 'no-fishing' form from Puerto Rico.
These logbook forms are used to record data for catch (landed catch) and effort for fishing trips made by commercially permitted fishers in Puerto Rico and the USVI. The catch and effort data for the entire trip are reported on a single form (i.e., one form per trip). The types of information required on this trip form include permit holder name, license number, vessel registration number, information on the quantity (reported in pounds) caught for each species, the area and depth of catch, the type and quantity of gear, the landing date (return date), location of landing (unloading of catch), an estimate of the fishing time, and the number of crew are included on this form.
The Puerto Rico form collects ex-vessel price information. The USVI forms do not collect price information. The Puerto RIco logbook form generally follows the historical format; however, there is now only one trip recorded per form. The new USVI forms are a significant departure from the previous format in that gear types and species specific names are pre-printed on the forms and there is only 1 trip recorded per page where the historical forms included the entire month of trips on a page. There are also spaces on all new forms where discard information may be recorded.
In addition the data set houses look-up tables for species and families, dialects, gear and gear groups, fishing areas, and permit holders. An online application was designed to allow for entry of data from each form type according to customized screens.
Provide improved catch and effort data for commercial fisheries from Puerto RIco and the US Virgin Islands to help ensure compliance with the Magnuson Act.
Data are self-reported. Forms were developed with the cooperation of Puerto Rico and the USVI. Data entry application and data set were designed by Arttech Inc. for NOAA-SEFSC consulting with the NOAA-Fisheries Statistics DIvision and the US Caribbean partner agencies. Forms are provided on NOAA-SEFSC website (see URLs listed under this documentation.
Theme
U.S. Caribbean fisheries
Theme
commercial fisheries
Theme
commercial landings
Theme
fishdep
Theme
fisheries
Theme
fishery-dependent
Theme
landings
Theme
marine fisheries
Spatial
Caribbean
Spatial
Puerto Rico
Spatial
Puerto Rico fish
Spatial
St. Croix
Spatial
St. John
Spatial
St. Thomas
Spatial
Virgin Islands fish
Stratum
area fished
Stratum
fishing gear
Stratum
marine species
Southeast Fisheries Science Center
Miami
FL
USA
In SECPR Oracle database
Data Set
Oracle Database
Continually
Table (digital)
Entities described in 'children'.
web-based data entry application
Oracle
From fishers of various gears in US Caribbean
28532
Table: AREA_LIST
AREA_LIST
Published / External
Completed
Table Of Valid Area Codes for the area fished. See URLs section for link to area maps. These codes are for 2.5 x 2.5 minute grids which show fishing areas for Puerto Rico and the USVI.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Table Of Valid Area Codes
1
AREA_CD
VARCHAR2
30
Yes
No
Active
Areas Code
VARCHAR2
2
REGION_CD
VARCHAR2
30
Yes
No
Active
Region Code
VARCHAR2
3
LU_DT
DATE
7
Yes
No
Active
Date Record Was Last Updated
DATE
4
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle Userid Of the person who updated this record
NUMBER
28533
Table: DIALECT_GEAR_LIST
DIALECT_GEAR_LIST
Published / External
Completed
A table of different Dialect names for a specific Gear and Form Template.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table of different Dialect names for a specific Gear and Form Template.
1
DIALECT_CD
VARCHAR2
30
Yes
Yes
Active
FK to DIALECT_LIST. Supports different Gear Names grouped by Dialect.
VARCHAR2
CCL.DIALECT_LIST
2
GEAR_CD
VARCHAR2
30
Yes
Yes
Active
FK to GEAR_LIST. Links a specific gear to an alternate name using a Dialect.
VARCHAR2
CCL.GEAR_LIST
3
DIALECT_GEAR_NM
VARCHAR2
60
No
No
Active
The alternate name for a Gear based on the chosen dialect.
VARCHAR2
4
SEQ
NUMBER
22
No
No
38
0
Active
The display sequence (order by). To help the online forms match the paper forms.
NUMBER
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
28534
Table: DIALECT_LIST
DIALECT_LIST
Published / External
Completed
The list of available dialects supported by the system. Dialect allow the system to use different words for the same species and gear. Such as Spanish and English or various dilects of either.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
The list of available dialects supported by the system. Dialect allow the system to use different words for the same species and gear. Such as Spanish and English or various dilects of either.
1
DIALECT_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
DIALECT_NM
VARCHAR2
60
Yes
No
Active
The name of the dialect. User defined.
VARCHAR2
3
IS_ENABLED
NUMBER
22
Yes
No
1
0
Active
Is the value enabled for use.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
DIALECT_DESC
VARCHAR2
256
No
No
Active
Description of a Region.
VARCHAR2
28535
Table: DIALECT_SPECIES_CLASS_LIST
DIALECT_SPECIES_CLASS_LIST
Published / External
Completed
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
1
DIALECT_CD
VARCHAR2
30
Yes
Yes
Active
FK to DIALECT. Identifies the Dialect alternate name to use.
VARCHAR2
CCL.DIALECT_LIST
2
SPECIES_CLASS_CD
VARCHAR2
30
Yes
Yes
Active
FK to SPECIES_CLASS_LIST. Identifies the Species Class having an alternate dialect name.
VARCHAR2
CCL.SPECIES_CLASS_LIST
3
DIALECT_SPECIES_CLASS_NM
VARCHAR2
60
No
No
Active
The alternate dialect name.
VARCHAR2
4
SEQ
NUMBER
22
No
No
38
0
Active
The display sequence (order by). To help the online forms match the paper forms.
NUMBER
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
28536
Table: DIALECT_SPECIES_LIST
DIALECT_SPECIES_LIST
Published / External
Completed
A table of different Dialect names for a specific Species and Form Template.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table of different Dialect names for a specific Species and Form Template.
1
DIALECT_CD
VARCHAR2
30
Yes
Yes
Active
FK to DIALECT. Supports alternate names for Species using a Dialect.
VARCHAR2
CCL.DIALECT_LIST
2
SPECIES_CD
VARCHAR2
30
Yes
Yes
Active
FK to SPECIES_LIST. Identifies the species used for the alternate dilect name.
VARCHAR2
CCL.SPECIES_LIST
3
DIALECT_SPECIES_NM
VARCHAR2
60
No
No
Active
Species name used in the region
VARCHAR2
4
SEQ
NUMBER
22
No
No
38
0
Active
The display sequence (order by). To help the online forms match the paper forms.
NUMBER
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
28537
Table: DID_NOT_FISH
DID_NOT_FISH
Published / External
Completed
Table of Did Not Fish reports from permit holders. A permit holder is required to submit a report indicating that they did not fish for a whole month.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Table of Did Not Fish reports from permit holders. A permit holder is required to submit a report indicating that they did not fish for a whole month.
1
DID_NOT_FISH_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
FISHER_PERMIT_ID
NUMBER
22
Yes
No
38
Active
FK to the FISHER_PERMIT who provided the Did Not Fish report.
NUMBER
CCL.FISHER_PERMIT
3
DID_NOT_FISH_MON
CHAR
2
Yes
No
Active
The Month value for Did Not Fish reports.
CHAR
4
DID_NOT_FISH_YR
CHAR
4
Yes
No
Active
The Year value for Did Not Fish reports.
CHAR
5
TRIP_TICKET_NUM
VARCHAR2
30
Yes
No
Active
Each logbook has a unique Trip Ticket number. This feild stored that number for Did Not Fish reports.
VARCHAR2
6
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
7
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
8
DNF_REASON_CD
VARCHAR2
30
No
No
Active
Reason why the did not fish report
VARCHAR2
CCL.DNF_REASON_LIST
28538
Table: DNF_REASON_LIST
DNF_REASON_LIST
Published / External
Completed
The list of reasons that no fishing occurred during a given month. Boat repair, illness etc.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
The list of available dialects supported by the system. Dialect allow the system to use different words for the same species and gear. Such as Spanish and English or various dilects of either.
1
DNF_REASON_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
DNF_REASON_NM
VARCHAR2
60
Yes
No
Active
The reason for Did Not Fish logbook. User defined.
VARCHAR2
3
IS_ENABLED
NUMBER
22
Yes
No
1
0
Active
Is the value enabled for use.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
DNF_REASON_DESC
VARCHAR2
256
No
No
Active
Description of the reason
VARCHAR2
28539
Table: FILTER
FILTER
Published / External
Completed
A table to support filtering species by gears or species by class (such as palagico). The table consolidates the two types of Filters into one table.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table to support filtering species by gears or species by class (such as palagico). The table consolidates the two types of Filters into one table.
1
FILTER_ID
NUMBER
22
Yes
Yes
Active
Primary key for this Table. Used to join GEAR_LIST with SPECIES_FILTER or SPECIES_CLASS_LIST with SPECIES_FILTER. The join is convereted to Filter ID so the Species Filter table can support both kinds of filters.
NUMBER
2
SPECIES_CLASS_CD
VARCHAR2
30
No
No
Active
The table supports filtering Species by Gear or Class. This field is used when filtering by SPECIES_CLASS_CD.
VARCHAR2
CCL.SPECIES_CLASS_LIST
3
GEAR_TYPE_CD
VARCHAR2
30
No
No
Active
The table supports filtering Species by Gear or Class. This field is used when filtering by GEAR_CD.
VARCHAR2
CCL.GEAR_TYPE_LIST
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
6
FORM_TEMPLATE_CD
VARCHAR2
30
No
No
Active
FK to form template list, if the species code or gear code is present in the form template
VARCHAR2
CCL.FORM_TEMPLATE_LIST
7
FILTER_NM
VARCHAR2
60
No
No
Active
Unique Name for a filter. .
VARCHAR2
8
FILTER_DESC
VARCHAR2
250
No
No
Active
Description of a filter.
VARCHAR2
28540
Table: FILTER_CLASS_SPECIES_LIST
FILTER_CLASS_SPECIES_LIST
Published / External
Completed
A table for filtering Species by Species Class for a Form Template. Example: when the user chooses the species class they fished, the system can filter to show only valid species.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table for filtering Species by Species Class for a Form Template. Example: when the user chooses the species class they fished, the system can filter to show only valid species.
1
FILTER_CLASS_SPECIES_LIST_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
SPECIES_CD
VARCHAR2
30
Yes
No
Active
FK to SPECIES_LIST. Identifies the species included in the filter for the chosen Form Template.
VARCHAR2
CCL.SPECIES_LIST
3
SEQ
NUMBER
22
Yes
No
6
0
Active
Sort order when displaying the sepcies values included in the filter.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
FILTER_ID
NUMBER
22
No
No
Active
FK to FILTER to identify what form template and class/gear the species belong to
NUMBER
28541
Table: FILTER_GEAR_SPECIES_LIST
FILTER_GEAR_SPECIES_LIST
Published / External
Completed
A table for filtering Species by gear type for a Form Template. Example: when the user chooses the gear type they fished, the system can filter to show only valid species.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table for filtering Species by gear type for a Form Template. Example: when the user chooses the gear type they fished, the system can filter to show only valid species.
1
FILTER_GEAR_SPECIES_LIST_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
SPECIES_CD
VARCHAR2
30
Yes
No
Active
The species being filtered by form template and gear type. The species which can be caught (based on catch report forms) using a particular gear type.
VARCHAR2
CCL.SPECIES_LIST
3
SEQ
NUMBER
22
Yes
No
6
0
Active
Sort order when displaying the sepcies values included in the filter.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
FILTER_ID
NUMBER
22
No
No
Active
FK to FILTER to identify GEAR TYPE CD and template for the species
NUMBER
CCL.FILTER
28542
Table: FISHER_PERMIT
FISHER_PERMIT
Published / External
Completed
A unique list of regional permits with owner name (bus or individual) and associated permits.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of regional permits with owner name (bus or individual) and associated permits.
1
FISHER_PERMIT_ID
NUMBER
22
Yes
Yes
38
Active
Primary key for this table. An instance of the permit holder
NUMBER
2
REGION_PERMIT_NUM
VARCHAR2
30
Yes
No
Active
FK to REGION_LIST. Associated a Fishing Permit or fishing License holder to a Region. Allos the system to support multiple Regions and keep the Fishers Permits by Region.
VARCHAR2
3
FISHER_TYPE_CD
VARCHAR2
30
Yes
No
Active
FK to FISHER_TYPE_LIST. Identifies if the Fisher is a Business or an Individual.
VARCHAR2
CCL.FISHER_TYPE_LIST
4
FISHER_FIRST_NM
VARCHAR2
60
No
No
Active
First name of the fisher.
VARCHAR2
5
FISHER_LAST_NM
VARCHAR2
60
No
No
Active
Last name of the fisher.
VARCHAR2
6
BUSINESS_NM
VARCHAR2
60
No
No
Active
Business name of the fisher when the permit is owned by a Business.
VARCHAR2
7
HMS_PERMIT_NUM
VARCHAR2
30
No
No
Active
Field to store the Fishers HMS fishing permit/license number
VARCHAR2
8
CONCH_PERMIT_NUM
VARCHAR2
30
No
No
Active
Field to store the Fishers Conch fishing permit/license number.
VARCHAR2
9
LOBSTER_PERMIT_NUM
VARCHAR2
30
No
No
Active
Field to store the Fishers Lobster fishing permit/license number.
VARCHAR2
10
PHONE_NUM
VARCHAR2
30
No
No
Active
Phone number associated to a Fisher or Business.
VARCHAR2
11
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
12
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
13
FISHER_PERMIT_EXP_DT
DATE
7
No
No
Active
Date that the data expired and was replaced by newer data
DATE
14
ISLAND_CD
VARCHAR2
30
Yes
No
Active
This island home of the fisher
VARCHAR2
CCL.ISLAND_LIST
15
ENTITY_ID
NUMBER
22
No
No
Active
Internal unique identifier for the entity (across instances and historical data)
NUMBER
16
IS_INACTIVE
NUMBER
22
Yes
No
1
0
Active
1=inactive user
NUMBER
17
CREATED_DT
DATE
7
No
No
Active
DATE
18
CREATED_BY_USER_ID
NUMBER
22
No
No
Active
NUMBER
28543
Table: FISHER_ROLE_LIST
FISHER_ROLE_LIST
Published / External
Completed
A unique list of Roles for the permitted fisheres, such as Primary or Partner.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of Roles for the permitted fisheres, such as Primary or Partner.
1
FISHER_ROLE_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
FISHER_ROLE_NM
VARCHAR2
60
Yes
No
Active
A unique name of a Role of a Fisher, such as primary or partner.
VARCHAR2
3
FISHER_ROLE_DESC
VARCHAR2
256
No
No
Active
Description of the list item.
VARCHAR2
4
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the value enabled for use.
NUMBER
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
28544
Table: FISHER_TYPE_LIST
FISHER_TYPE_LIST
Published / External
Completed
Fisher Type identifies if the Fisher is a business or an individual.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Fisher Type identifies if the Fisher is a business or an individual.
1
FISHER_TYPE_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
FISHER_TYPE_NM
VARCHAR2
60
Yes
No
Active
Field to store the Fisher Type name, such as Business or Individual.
VARCHAR2
3
IS_ENABLED
NUMBER
22
Yes
No
1
0
Active
Is the value enabled for use.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
FISHER_TYPE_DESC
VARCHAR2
256
No
No
Active
Description of the list item.
VARCHAR2
28545
Table: FORM_TEMPLATE_LIST
FORM_TEMPLATE_LIST
Published / External
Completed
A list of form templates wich have a corresponding user interface for data entry. Supports having different information collected BY Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A list of form templates wich have a corresponding user interface for data entry. Supports having different information collected BY Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.
1
FORM_TEMPLATE_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
FORM_TEMPLATE_NM
VARCHAR2
60
Yes
No
Active
Field to store the name of the Form Template. A Form Template is the online data collection form associated to a Paper Logbook (catch report) form.
VARCHAR2
3
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
4
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
5
IS_ENABLED
NUMBER
22
Yes
No
1
0
Active
Is the value enabled?
NUMBER
6
FORM_TEMPLATE_DESC
VARCHAR2
256
No
No
Active
Description of a Region.
VARCHAR2
7
SUBREGION_CD
VARCHAR2
30
No
No
Active
FK to Subregion List
VARCHAR2
CCL.SUBREGION_LIST
28546
Table: GEAR_LIST
GEAR_LIST
Published / External
Completed
A unique list of fishing gears such as Net or Trap.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of fishing gears such as Net or Trap.
1
GEAR_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
GEAR_TYPE_CD
VARCHAR2
30
Yes
No
Active
FK to GEAR_TYPE_LIST. Identifies the Type of gear for a specific gear, such as Net (Gear Type) for Gill Net (Gear).
VARCHAR2
CCL.GEAR_TYPE_LIST
3
GEAR_NM
VARCHAR2
60
Yes
No
Active
Unique Name for a gear. Alternate names for the gear can be found in the Dialect table.
VARCHAR2
4
GEAR_DESC
VARCHAR2
250
No
No
Active
Description of a Gear.
VARCHAR2
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
7
IS_ENABLED
NUMBER
22
Yes
No
1
0
Active
Is the value enabled for use.
NUMBER
28547
Table: GEAR_TYPE_LIST
GEAR_TYPE_LIST
Published / External
Completed
A list of Gear Types such as Net or Trap.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A list of Gear Types such as Net or Trap.
1
GEAR_TYPE_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
GEAR_TYPE_NM
VARCHAR2
60
Yes
No
Active
Unique name for a Gear Type, such as Net or Trap. There can be multiple gears associated with a Gear Type.
VARCHAR2
3
GEAR_TYPE_DESC
VARCHAR2
250
No
No
Active
Description of the list item.
VARCHAR2
4
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the value enabled for use.
NUMBER
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
28548
Table: ISLAND_LIST
ISLAND_LIST
Published / External
Completed
Table Of Islands in The Carribbean
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Table Of Islands in The Carribbean
1
ISLAND_CD
VARCHAR2
30
Yes
Yes
Active
PK Island Code
VARCHAR2
2
ISLAND_NM
VARCHAR2
60
No
No
Active
Island Name
VARCHAR2
3
ISLAND_DESC
VARCHAR2
256
No
No
Active
Island Description
VARCHAR2
4
IS_ENABLED
NUMBER
22
No
No
38
0
Active
Is the value enabled for use.
NUMBER
5
LU_DT
DATE
7
No
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
No
No
38
Active
Last update user.
NUMBER
7
SUBREGION_CD
VARCHAR2
30
No
No
Active
FK to subregion
VARCHAR2
CCL.SUBREGION_LIST
28549
Table: LANDING_LOCATION_LIST
LANDING_LOCATION_LIST
Published / External
Completed
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
1
LANDING_LOCATION_CD
VARCHAR2
30
No
No
Active
PK Landing location CD
VARCHAR2
2
LANDING_LOCATION_NM
VARCHAR2
60
No
No
Active
Landing location name
VARCHAR2
3
LANDING_LOCATION_COUNTY
VARCHAR2
60
No
No
Active
Landing location County
VARCHAR2
4
ISLAND_CD
VARCHAR2
30
No
No
Active
FK to Island list
VARCHAR2
5
IS_ENABLED
NUMBER
22
No
No
1
0
Active
Flag to indicate if the location is enabled
NUMBER
6
LU_DT
DATE
7
No
No
Active
Last update date
DATE
7
LU_USER_ID
NUMBER
22
No
No
38
Active
Last update user.
NUMBER
28550
Table: LOV_LIST
LOV_LIST
Published / External
Completed
Table Of List Of Values Used In This application
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Table Of List Of Values Used In This application
1
LOV_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
LOV_NM
VARCHAR2
60
Yes
No
Active
Unique name of LOV lists.
VARCHAR2
3
LOV_DESC
VARCHAR2
250
No
No
Active
Description of the value (list).
VARCHAR2
4
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the list item enabled?
NUMBER
5
LOV_GROUP_CD
VARCHAR2
30
No
No
Active
Generic field for list item group code when applicable
VARCHAR2
6
LOV_ALT_CD
VARCHAR2
30
No
No
Active
Generic field for list item alternate code value such as species ERDMAN code
VARCHAR2
7
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
8
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
9
SEQ
NUMBER
22
No
No
2
0
Active
Display Sequence
NUMBER
10
LOV_GROUP_TYPE
VARCHAR2
30
No
No
Active
Single (drop-down-list) or Multiple choice group list
VARCHAR2
11
LOV_GROUP_NM
VARCHAR2
60
No
No
Active
The list to dipslay where there is a group (LOV_GROUP_TYPE)
VARCHAR2
12
IS_CORE
VARCHAR2
1
No
No
Active
Flag to indicate if the list can be edited only by administrator
VARCHAR2
28551
Table: LOV_REGION
LOV_REGION
Published / External
Completed
Control Table Giving Of List Of Values Used For Each Region
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Control Table Giving Of List Of Values Used For Each Region
1
LOV_CD
VARCHAR2
30
Yes
Yes
Active
Name Of The LOV Value
VARCHAR2
CCL.LOV_LIST
2
REGION_CD
VARCHAR2
30
Yes
Yes
Active
Name Of The Region
VARCHAR2
CCL.REGION_LIST
28552
Table: REGION_LIST
REGION_LIST
Published / External
Completed
A unique list of regions such as Puerto Rico or the USVI.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of regions such as Puerto Rico or the USVI.
1
REGION_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
REGION_NM
VARCHAR2
60
Yes
No
Active
A unique name of a Region.
VARCHAR2
3
REGION_DESC
VARCHAR2
250
No
No
Active
Description of a Region.
VARCHAR2
4
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the value enabled for use.
NUMBER
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
28553
Table: SPECIES_CLASS_LIST
SPECIES_CLASS_LIST
Published / External
Completed
A unique list of Species Classes. Species Class is used as a filter to group Species by Class.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of Species Classes. Species Class is used as a filter to group Species by Class.
1
SPECIES_CLASS_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
SPECIES_CLASS_NM
VARCHAR2
60
Yes
No
Active
Unique name for a Species.
VARCHAR2
3
SPECIES_CLASS_DESC
VARCHAR2
250
No
No
Active
Description of a Species.
VARCHAR2
4
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the value enabled for use.
NUMBER
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
28554
Table: SPECIES_FAMILY_LIST
SPECIES_FAMILY_LIST
Published / External
Completed
A unique list of Species Families, such as Groupers or Jacks.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of Species Families, such as Groupers or Jacks.
1
SPECIES_FAMILY_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
SPECIES_FAMILY_NM
VARCHAR2
60
Yes
No
Active
Unique name for the Species Family, such as Grouper(s).
VARCHAR2
3
SPECIES_FAMILY_DESC
VARCHAR2
250
No
No
Active
Description of the Species Family.
VARCHAR2
4
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the value enabled for use.
NUMBER
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
28555
Table: SPECIES_LIST
SPECIES_LIST
Published / External
Completed
A unique list of Species.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of Species.
1
SPECIES_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
SPECIES_FAMILY_CD
VARCHAR2
30
Yes
No
Active
FK to SPECIES_FAMILY_LIST. Identify the Species Family for the Species. Multiple Species can be associated to a Species Family, such as Coney and Graysby are both Groupes.
VARCHAR2
CCL.SPECIES_FAMILY_LIST
3
ERDMANS_CD
VARCHAR2
30
No
No
Active
The 3 digit Erdmans code for the species.
VARCHAR2
4
SPECIES_NM
VARCHAR2
60
Yes
No
Active
Unique Name for a Species.
VARCHAR2
5
SPECIES_DESC
VARCHAR2
250
No
No
Active
Description of a Species.
VARCHAR2
6
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
7
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
8
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the value enabled for use.
NUMBER
28556
Table: SUBREGION_LIST
SUBREGION_LIST
Published / External
Completed
To keep a logical separation of a region
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
To keep a logical separation of a region
1
SUBREGION_CD
VARCHAR2
30
Yes
Yes
Active
PK for SUBREGION Table
VARCHAR2
2
SUBREGION_NM
VARCHAR2
60
Yes
No
Active
Subregion Name
VARCHAR2
3
SUBREGION_DESC
VARCHAR2
256
No
No
Active
Subregion Description
VARCHAR2
4
REGION_CD
VARCHAR2
30
Yes
No
Active
FK to region table
VARCHAR2
CCL.REGION_LIST
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
7
IS_ENABLED
NUMBER
22
Yes
No
1
0
Active
Is the value enabled for use.
NUMBER
28557
Table: TRIP
TRIP
Published / External
Completed
A unique list of Fishing Trips. One record for each Fishing Trip reported.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of Fishing Trips. One record for each Fishing Trip reported.
1
TRIP_ID
NUMBER
22
Yes
Yes
38
Active
Primary key for this table.
NUMBER
2
FORM_TEMPLATE_CD
VARCHAR2
30
Yes
No
Active
FK to FORM_TEMPLATE_LIST. Identifies the Form Template (both paper and online) used to record the Fishing Trip information.
VARCHAR2
CCL.FORM_TEMPLATE_LIST
3
VESSEL_CD
VARCHAR2
30
No
No
Active
Vessel identification value
VARCHAR2
4
TRIP_DT
DATE
7
Yes
No
Active
Trip report date
DATE
5
TRIP_TICKET_NUM
VARCHAR2
30
Yes
No
Active
Preprinted Trip Ticket number
VARCHAR2
6
TRIP_LANDING_LOCATION
VARCHAR2
60
No
No
Active
Location where the Trip landed the catch.
VARCHAR2
7
IS_DATA_TAKEN
NUMBER
22
No
No
38
0
Active
Trip Surveyed/sampled by DFW Sampler
NUMBER
8
IS_DAY_TRIP
NUMBER
22
No
No
1
0
Active
Did the fishing trip take place mainly during the day?.1 = Day fishing trip..
NUMBER
9
IS_FEDERAL_WATERS
NUMBER
22
No
No
1
0
Active
Was the Fishing Trip in Federal Waters. Yes, if more than 3 miles off shore for USVI and more than 9 miles off shore for Puerto Rico.
NUMBER
10
IS_TRIP_LEASED
NUMBER
22
No
No
1
0
Active
Is the Trip leased with paying customers.
NUMBER
11
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
12
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
13
TRIP_LANDING_CENTER
VARCHAR2
60
No
No
Active
Specific place where the Trip landed the catch (Port for Puerto Rico)
VARCHAR2
14
TRIP_HELPERS_NUM
NUMBER
22
No
No
38
0
Active
Number of helpers (excluding partners) on the trip
NUMBER
15
USVI_ISLAND_CD
CHAR
1
No
No
Active
Identifies which island for USVI catch reports..C) St. Croix.T) St. Thomas.J) St. John
CHAR
16
IS_SPLIT_CATCH
NUMBER
22
No
No
38
0
Active
Did other Permit Holders Split Catch 0 No, 1 Yes
NUMBER
17
TOTAL_TRIP_POUNDS
NUMBER
22
No
No
Active
Total trip pounds
NUMBER
18
TOTAL_TRAPS_IN_WATER
NUMBER
22
No
No
38
Active
Total # of Traps in water
NUMBER
19
IS_INCOMPLETE
NUMBER
22
No
No
1
0
Active
Flag to indicate if the logbook was saved as incomplete.
NUMBER
20
TRIP_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
6
0
Active
Number Of days that the gear was in the water
NUMBER
21
CREATED_DT
DATE
7
No
No
Active
Date when the record was originally created
DATE
22
CREATED_BY_USER_ID
NUMBER
22
No
No
Active
User who created the record
NUMBER
23
LOGBOOK_RECEIVED_DT
DATE
7
No
No
Active
Date the logbook was received at the office
DATE
28558
Table: TRIP_AREA
TRIP_AREA
Published / External
Completed
A table of Fishing Areas associated to a Fishing Trip. May also be Fishing Areas associated to a Gear Type used on a Fishing Trip, depending on the relationship to TRIP or TRIP_GEAR_TYPE.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table of Fishing Areas associated to a Fishing Trip. May also be Fishing Areas associated to a Gear Type used on a Fishing Trip, depending on the relationship to TRIP or TRIP_GEAR_TYPE.
1
TRIP_AREA_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
TRIP_ID
NUMBER
22
No
No
38
Active
TrI Area Code
NUMBER
CCL.TRIP
3
TRIP_GEAR_TYPE_ID
NUMBER
22
No
No
Active
This field is used to identify the Gear was used for a particular fishing Area of a Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
4
AREA_CD
VARCHAR2
30
No
No
Active
A code identifying the area where fishing occured for a given Trip. Can be more than one fishing area.
VARCHAR2
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
7
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
8
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
NUMBER
28559
Table: TRIP_CATCH
TRIP_CATCH
Published / External
Completed
Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.
1
TRIP_CATCH_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
No
38
Active
FK to TRIP_GEAR. Identifies the Gear used to Catch the Species.
NUMBER
CCL.TRIP_GEAR_TYPE
3
SPECIES_CD
VARCHAR2
30
Yes
No
Active
FK to SPECIES_LIST. Identifies the Species caught on the Trip.
VARCHAR2
CCL.SPECIES_LIST
4
TRIP_GEAR_TYPE_GEAR_ID
NUMBER
22
No
No
38
Active
When we know the catch by gear, as apposed to knowing the catch by gear type, we record it here.
NUMBER
CCL.TRIP_GEAR_TYPE_GEAR
5
CATCH_LBS
NUMBER
22
No
No
8
2
Active
Records the pounds of fish caught for a particular Catch, Gear, and Species. In Puerto Rico the form does not specify the condition. In the USVI there is a seperate field for gutted lbs. So, for USVI this field (catch_lbs) represents whole.
NUMBER
6
PRICE_PER_LBS
NUMBER
22
No
No
5
2
Active
Records the price per lbs for the fish.
NUMBER
7
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
8
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
9
CATCH_GUTTED_LBS
NUMBER
22
No
No
8
2
Active
USVI gutted catch in pounds of fish caught for a particular Catch, Gear, and Species.
NUMBER
10
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
11
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
NUMBER
28560
Table: TRIP_DISCARD
TRIP_DISCARD
Published / External
Completed
Records the count of fish/lobsters discarded during a fishing trip.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Records the count of fish/lobsters discarded during a fishing trip.
1
TRIP_DISCARD_ID
NUMBER
22
Yes
Yes
38
Active
Primary key for this table.
NUMBER
2
TRIP_ID
NUMBER
22
Yes
No
Active
FK to Trip.
NUMBER
CCL.TRIP
3
TRIP_GEAR_TYPE_ID
NUMBER
22
No
No
38
Active
FK to optional gear type.
NUMBER
CCL.TRIP_GEAR_TYPE
4
FISH_LIVE_CNT
NUMBER
22
No
No
4
0
Active
The number (count) of live fish discarded during the trip, regardless of species.
NUMBER
5
FISH_DEAD_CNT
NUMBER
22
No
No
4
0
Active
The number (count) of dead fish discarded during the trip, regardless of species.
NUMBER
6
LOBSTER_LIVE_CNT
NUMBER
22
No
No
4
0
Active
The number (count) of live lobster discarded during the trip.
NUMBER
7
LOBSTER_DEAD_CNT
NUMBER
22
No
No
4
0
Active
The number (count) of dead lobster discarded during the trip.
NUMBER
8
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
9
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
10
OTHER_CNT
NUMBER
22
No
No
38
Active
The number (count) of unspecified species discard ed during the trip.
NUMBER
11
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
12
CREATED_BY_USER_ID
NUMBER
22
No
No
Active
NUMBER
28561
Table: TRIP_FISHER
TRIP_FISHER
Published / External
Completed
A table to support a many-to-many relationship between TRIP and FISHER_PERMIT. The table stores all the Fishers who participated on a Fishing Trip and their Role on the Trip, such as primary/owner or partner.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table to support a many-to-many relationship between TRIP and FISHER_PERMIT. The table stores all the Fishers who participated on a Fishing Trip and their Role on the Trip, such as primary/owner or partner.
1
TRIP_FISHER_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
TRIP_ID
NUMBER
22
Yes
No
38
Active
Foreign Key to Trip Table
NUMBER
CCL.TRIP
3
FISHER_PERMIT_ID
NUMBER
22
Yes
No
Active
FK to FISHER_PERMIT. Identifies the Fisher in the many-to-many relationship between Fishers (permits) and Trips.
NUMBER
CCL.FISHER_PERMIT
4
FISHER_ROLE_CD
VARCHAR2
30
Yes
No
Active
FK to FISHER_ROLE. Identifies the role of the Fisher on the Trip, such as primary or partner.
VARCHAR2
CCL.FISHER_ROLE_LIST
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
7
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
8
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving toracle usercode of creater of the record
NUMBER
28562
Table: TRIP_GEAR_HOOK_LINE_DETAIL
TRIP_GEAR_HOOK_LINE_DETAIL
Published / External
Completed
When the Gear used on a Fishing Trip is Hook and Line, this table stores addition details about the Gear such as Line count or Hook count.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
When the Gear used on a Fishing Trip is Hook and Line, this table stores addition details about the Gear such as Line count or Hook count.
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Foreighn/Primary key for this table. This table stores addition information specific to the HOOK and LINE gear used used on the Fishing Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
2
LINES_CNT
NUMBER
22
No
No
38
0
Active
The number of lines used when fishing.
NUMBER
3
HOOKS_PER_LINE_CNT
NUMBER
22
No
No
3
0
Active
The number of hooks per line.
NUMBER
4
FAD_NUM
VARCHAR2
30
No
No
Active
Amn attribute of Hook and Line Gear/Fishing for USVI.
VARCHAR2
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
7
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
8
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of records creater
NUMBER
28563
Table: TRIP_GEAR_NET_DETAIL
TRIP_GEAR_NET_DETAIL
Published / External
Completed
When the Gear used on a Fishing Trip is Net, this table stores addition details about the Gear such as Length of net or Hours soaked.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
When the Gear used on a Fishing Trip is Net, this table stores addition details about the Gear such as Length of net or Hours soaked.
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Foreighn/Primary key for this table. This table stores addition information specific to the NET gear used used on the Fishing Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
2
LENGTH
NUMBER
22
No
No
38
0
Active
Length of the net in length_uom (Fathoms/Feet)
NUMBER
3
MESH_IN
NUMBER
22
No
No
5
2
Active
Mesh size of the net in inches.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
NET_CNT
NUMBER
22
No
No
5
2
Active
Net count
NUMBER
7
LENGTH_UOM
VARCHAR2
30
No
No
Active
Net length unit of measure
VARCHAR2
8
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
9
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of records creater
NUMBER
28564
Table: TRIP_GEAR_SPEAR_DETAIL
TRIP_GEAR_SPEAR_DETAIL
Published / External
Completed
When the Gear used on a Fishing Trip is Spear or By Hand, this table stores addition details about the Gear such as number of Divers?
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
When the Gear used on a Fishing Trip is Spear or By Hand, this table stores addition details about the Gear such as number of Divers?
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Foreighn/Primary key for this table. This table stores addition information specific to the SPEAR or HAND gear used used on the Fishing Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
2
DIVERS_CNT
NUMBER
22
No
No
38
0
Active
The count of divers (number of people diving) on this fishing trip.
NUMBER
3
DIVES_CNT
NUMBER
22
No
No
3
0
Active
The count of dives which took place while fishing on this trip.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
IS_SCUBA
NUMBER
22
No
No
1
0
Active
Check flag for scuba diving
NUMBER
7
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
8
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of the creater of the record
NUMBER
28565
Table: TRIP_GEAR_TRAP_DETAIL
TRIP_GEAR_TRAP_DETAIL
Published / External
Completed
When the Gear used on a Fishing Trip is Trap, this table stores addition details about the Gear such as number of traps or how long the traps soaked.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
When the Gear used on a Fishing Trip is Trap, this table stores addition details about the Gear such as number of traps or how long the traps soaked.
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Foreighn/Primary key for this table. This table stores addition information specific to the TRAP gear used used on the Fishing Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
2
LOBSTER_TRAPS_HAULED
NUMBER
22
No
No
38
0
Active
The count of lobster traps hauled on the fishing trip.
NUMBER
3
FISH_TRAPS_HAULED
NUMBER
22
No
No
3
0
Active
The count of fish traps hauled on the fishing trip.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
FISH_TRAPS_HOURS_SOAKED
NUMBER
22
No
No
6
2
Active
Soak time for Fish Traps in hours -- hours fished in trip_gear_type are is for lobster time in hours
NUMBER
7
LOBSTER_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
6
2
Active
Soak time for Lobster Traps in days
NUMBER
8
FISH_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
6
2
Active
Soak time for Fish Traps in days
NUMBER
9
CREATED_DT
DATE
7
No
No
Active
Time stamp of the creationof the record
DATE
10
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Controp column giving oracle userid of the creator of this record
NUMBER
28566
Table: TRIP_GEAR_TYPE
TRIP_GEAR_TYPE
Published / External
Completed
A table of Gear types used on a Fishing Trip. A one-to-many => TRIP to TRIP_GEAR_TYPE.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table of Gear types used on a Fishing Trip. A one-to-many => TRIP to TRIP_GEAR_TYPE.
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
TRIP_ID
NUMBER
22
Yes
No
38
Active
FK to TRIP. Identifies the Trip which used these Trip Gears.
NUMBER
CCL.TRIP
3
GEAR_TYPE_CD
VARCHAR2
30
No
No
Active
FK to GEAR_TYPE_LIST. The type of gear used on the fishing trip, such as Net or Trap. Both catch reports record the type of gear used on a fishing trip, in addition to the specific gear within the type. However, multiple gears can be identified so they are stored in a seperate table. Example: Net - Seine and Gill.
VARCHAR2
CCL.GEAR_TYPE_LIST
4
HOURS_FISHED
NUMBER
22
No
No
38
2
Active
The amount of hours the Fisher fished on a Trip OR how long the Traps soaked between hauls recorded in hours.
NUMBER
5
DEPTH
NUMBER
22
No
No
8
2
Active
Fishing gear depth
NUMBER
6
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
7
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
8
GEAR_QTY_SIZE
NUMBER
22
No
No
8
2
Active
Stores a number which represents the gear size or quantity. The value is understood depending on the gear used. (the paper for has no unit of measure)
NUMBER
9
DEPTH_UOM
VARCHAR2
30
No
No
Active
Unit of Measure for Depth Choices Fathoms and Feet
VARCHAR2
10
SPECIES_CLASS_CD
VARCHAR2
30
No
No
Active
Species class is used here to identify the user chosen species class when filling out the logbook/catch report forms. When OTHER species are recorded, the user interface stores the species class chosen by the user (whether it is correct or not). This value will also allow the UI to redraw the values where they were entered when editing a logbook/catch report.
VARCHAR2
CCL.SPECIES_CLASS_LIST
11
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
12
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of records creater
NUMBER
28567
Table: TRIP_GEAR_TYPE_GEAR
TRIP_GEAR_TYPE_GEAR
Published / External
Completed
Records which gears of the type identified for the trip were used. The USVI logbook paper form allows more than one gear to be recorded for a catch. Such as, "These species were caught using these kinds of Nets." Exmaple: Net - Gill AND Seine.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Records which gears of the type identified for the trip were used. The USVI logbook paper form allows more than one gear to be recorded for a catch. Such as, "These species were caught using these kinds of Nets." Exmaple: Net - Gill AND Seine.
1
TRIP_GEAR_TYPE_GEAR_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
No
38
Active
FK to TRIP_GEAR_TYPE. Indetified the type of gear used on the fishing trip while catching the TRIP_CATCH species.
NUMBER
CCL.TRIP_GEAR_TYPE
3
GEAR_CD
VARCHAR2
30
Yes
No
Active
FK to TRIP_GEAR_TYPE. Indetified the type of gear used on the fishing trip while catching the TRIP_CATCH species.
VARCHAR2
CCL.GEAR_LIST
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
Active
Control column giving oracle usercode of the last one that changed this record
NUMBER
6
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
7
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of records creater
NUMBER
Data Steward
2012
Person
Gloeckner, David
David.Gloeckner@noaa.gov
75 Virginia Beach Drive
Miami
FL
33139
305-361-4257
305-361-4460
Data Steward
2011-07-01
2017
Person
Bennett, Joshua
Distributor
2011
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Metadata Contact
2011-07-01
Person
Gloeckner, David
David.Gloeckner@noaa.gov
75 Virginia Beach Drive
Miami
FL
33139
305-361-4257
305-361-4460
305-361-4257 (w)
Contact by email preferred.
Metadata Contact
2011-07-01
2017
Person
Bennett, Joshua
Point of Contact
2011-07-01
2017
Person
Bennett, Joshua
Process Contact
2011-07-01
Person
Gloeckner, David
David.Gloeckner@noaa.gov
75 Virginia Beach Drive
Miami
FL
33139
305-361-4257
305-361-4460
-68.16666666667
-64
19.25
17.33333333333
The bounds include territorial waters and waters in the Exclusive Economic Zone for Puerto Rico and the US Virgin Islands as displayed on the log report look-up maps for those islands. Some areas falling within the general boundaries (British Virgin Islands waters for example), are not included. Boundaries specific to each form are recorded separately.
Continuing
2011-07
US Virgin Islands data start on 07/01/2011. Puerto Rico data starts 01/01/2012.
Sensitive
Password Restricted. Rule of 3: Data summaries must include at least 3 dealers to be considered non-sensitive. See:
NOAA FORM 58-5 (1-84) TRANSMITTAL 127,
National Oceanic and Atmospheric Administration
NOAA Administrative Order 216-100
NOAA ADMINISTRATIVE ORDER SERIES
Date of Issuance: July 26, 1994
Sensitive data may only be released to entities having a signed non-disclosure agreement on file with the Director of the Information Resources Management Division (IRMD). Otherwise, sensitivity may be suppressed by the following methods used for aggregation of sensitive data:
Data that are submitted as sensitive can be released to the public under the following circumstances:
1. Combined or aggregated data. Sensitive data can be released if the data are aggregated or summarized in a manner that prevents the identification of the person or organization that submitted the data. The "rule of three" and identification of majority allocations" are the primary data suppression methods.
2. Obscure (scramble) or remove the data identifier. For some types of data, sensitive data Can be released as non-sensitive if the identity of the person, vessel, company, etc. that submitted the data is not included or is scrambled as part of the data that are released.
3. Submitter. Sensitive data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that sUbmitted the data.
4. Sensitive data waived. The protection of sensitive data can be waived by the person or business that submitted the data.
See NOAA Administrative Order 216-100
NOAA ADMINISTRATIVE ORDER SERIES
Date of Issuance: July 26, 1994
These standards and procedures apply to all employees of the SEFSC that need access to sensitive fisheries statistics. This includes full time or term employees, contractors, volunteers, and/or other employees associated with the SEFSC, but not directly employed by either organization. Any SEFSC employee that needs or desires access to sensitive data must have read NOA 216-100 and submitted a signed nondisclosure statement to the Director, Information Resources Management Division (IRMD). The non-disclosure statement must be approved by the Director of IRMD and maintained on file by IRMD. It is the responsibility of the Director of IRMD to certifY upon request, that a person or organization that requests access to sensitive data is authorized access to those data. All employees that have access to and/or use sensitive data (federal and nonfederal) are responsible to protect those data from unauthorized access or release. Contractors or grantees that have an agreement with NMFS can be granted
access to sensitive data as an authorized user (See NOA 216-100 1 Section 6.03e). It should be clearly understood that sensitive data cannot be released simply by an individual signing a nondisclosure statement. There must be a clear and demonstrable need for the sensitive data that are requested as part of a contract or grant. Sensitive data can only be released for the specific contract or grant. Upon completion of the contract or grant, the recipient must either return the data or state that it has been destroyed. The contractor or grantee cannot use the data for any purpose other than the uses stated in the agreement. The Contracting Officers Technical Representative (COTR) or the Technical Monitor (TM) that has been assigned to the contract or grant, respectively, has the following? responsibilities:
1. The COTR/TM has the responsibility to determine whether the contractor/grantee is eligible to receive the sensitive data that are requested in the agreement.
2. The COTR/TM has the responsibility to assure that all persons included in the agreement have read NOA 2l6-l00 and have signed a nondisclosure statement. A statement must be signed by each person that will have access to the sensitive data under the agreement, i.e., a blanket statement cannot be used for the company or firm. The COTR/TM also has the responsibility to make sure that the Director, IRMD has signed and approved the nondisclosure statement and the statement is on file with IRMD.
3. The COTR/TM has the responsibility to assure that sensitive data are not released in any publication, report, oral presentation, or other means to the public by the contractor or grantee.
To access sensitive data a completed non-disclosure agreement must be on file with NOAA-SEFSC. Otherwise Data that are submitted as sensitive can be released to the public under the following circumstances:
1. Combined or aggregated data. Sensitive data can be released if the data are aggregated or summarized in a manner that prevents the identification of the person or organization that submitted the data. The "rule of three" and identification of majority allocations" are the primary data suppression methods.
2. Obscure (scramble) or remove the data identifier. For some types of data, sensitive data Can be released as non-sensitive if the identity of the person, vessel, company, etc. that submitted the data is not included or is scrambled as part of the data that are released.
3. Submitter. Sensitive data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that submitted the data.
4. Sensitive data waived. The protection of sensitive data can be waived by the person or business that submitted the data.
Sensitive data are not to be released in any publication, report, oral presentation, or other means to the public.
Non-published Metadata access is restricted. Published Metadata is available to the public.
Use Published Metadata only.
http://sedarweb.org/
Online Resource
The Southeast Data Assessment and Review documents for various marine species of interest.
https://www.sefsc.noaa.gov/fisheries/caribbean.html
Online Resource
pdf
Reporting forms, maps, and instructions for US Caribbean fisheries
Pounds landed from surveys are intended to represent actual pounds landed; however, under- and/or non-reporting by fishers compels additional survey data from dockside observations to be applied in order to generate an estimation of actual pounds landed. This is latter process is currently being done for Puerto Rico only.
This is industry reported data. Pounds landed by species generally are estimated from hold capacities of the fish containers with an estimated percentage applied as to the pounds by species or species group. There is no sales ticket where actual species weights are listed. Species weights are sometimes mis-recorded on the forms (placed in an adjacent field for example). Dockside surveys done by territorial or commonwealth port agents can be compared to the industry reported landings for accuracy.
Refer to by SEDAR documentation link at URLs section of metadata.
Refer to by SEDAR documentation link at URLs section of metadata.
Reporting bias varies by fisher. Dockside trip samples by official port agents can be of help here.
Fishery regulations, weather, economic factors, gear modifications need to be considered when comparing the data on a year by year basis.
Compliance Report by month
Precision is left to the fisher. Rounded pounds to the tens or hundreds occur alongside decimal entries to the hundredth pound. Data entry enters data as recorded.
Refer to by SEDAR documentation link at URLs section of metadata.
Precision is left to the fisher. Rounded pounds to the tens or hundreds occur alongside decimal entries to the hundredth pound. Data entry enters data as recorded.
Hold capacity estimates by container(s). Containers not standardized.
Best estimate: 0.25 pounds
Compliance Report by Month, Dockside survey data applied in Puerto Rico.
Look-up tables and checks for large and small pounds and price by fisher, species. Posted to US Caribbean by SEFSC.
Yes
Unknown
Yes
Yes
No
2 months
Fishers have 60 days to submit report entry time possibly delayed due to manpower of US Caribbean Agencies.
To Be Determined
60 days
User id and password
Industry generated logbook report from fisher goes to US Caribbean Fishing Agency for processing and entry into web based application. Edit checks on entry by look-up tables. Edit Checks and feedback as well as compliance report made available to agency by SEFSC
28532
Entity
Table: AREA_LIST
28533
Entity
Table: DIALECT_GEAR_LIST
28534
Entity
Table: DIALECT_LIST
28535
Entity
Table: DIALECT_SPECIES_CLASS_LIST
28536
Entity
Table: DIALECT_SPECIES_LIST
28537
Entity
Table: DID_NOT_FISH
28538
Entity
Table: DNF_REASON_LIST
28539
Entity
Table: FILTER
28540
Entity
Table: FILTER_CLASS_SPECIES_LIST
28541
Entity
Table: FILTER_GEAR_SPECIES_LIST
28542
Entity
Table: FISHER_PERMIT
28543
Entity
Table: FISHER_ROLE_LIST
28544
Entity
Table: FISHER_TYPE_LIST
28545
Entity
Table: FORM_TEMPLATE_LIST
28546
Entity
Table: GEAR_LIST
28547
Entity
Table: GEAR_TYPE_LIST
28548
Entity
Table: ISLAND_LIST
28549
Entity
Table: LANDING_LOCATION_LIST
28550
Entity
Table: LOV_LIST
28551
Entity
Table: LOV_REGION
28552
Entity
Table: REGION_LIST
28553
Entity
Table: SPECIES_CLASS_LIST
28554
Entity
Table: SPECIES_FAMILY_LIST
28555
Entity
Table: SPECIES_LIST
28556
Entity
Table: SUBREGION_LIST
28557
Entity
Table: TRIP
28558
Entity
Table: TRIP_AREA
28559
Entity
Table: TRIP_CATCH
28560
Entity
Table: TRIP_DISCARD
28561
Entity
Table: TRIP_FISHER
28562
Entity
Table: TRIP_GEAR_HOOK_LINE_DETAIL
28563
Entity
Table: TRIP_GEAR_NET_DETAIL
28564
Entity
Table: TRIP_GEAR_SPEAR_DETAIL
28565
Entity
Table: TRIP_GEAR_TRAP_DETAIL
28566
Entity
Table: TRIP_GEAR_TYPE
28567
Entity
Table: TRIP_GEAR_TYPE_GEAR
gov.noaa.nmfs.inport:27501
Joshua Bennett
2015-09-25T15:31:31
Bryson Anderson
2023-01-27T17:10:55
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06