Table: EXTRACT_FROM_CCL_USVI
Southeast Fisheries Science Center
Entity
(ENT)
| ID: 37481
| Published / External
Created: 2017-03-29
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 1920
ID: 37481
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: EXTRACT_FROM_CCL_USVI |
---|---|
Short Name | EXTRACT_FROM_CCL_USVI |
* Status | In Work |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This table is an extract from the Caribbean Commercial landings (CCL) system. It is for data from July 2011 to-date. It represents all data available in the CCL tables. It can be accessed through the APEX application as report CCL_MAIN_EXTRACT_FOR_USVI. Data are sensitive. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | Commercial Landings |
None | fish |
None | Fisheries |
Temporal Keywords
Thesaurus | Keyword |
---|---|
None | 1974 |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | Carribbean |
None | EEZ |
None | Puerto Rico |
None | territorial waters |
None | Virgin Islands |
Stratum Keywords
Thesaurus | Keyword |
---|---|
None | area |
None | Catch |
None | fishing gear |
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Southeast Fisheries Science Center |
---|---|
• » City | Miami |
• » State/Province | FL |
• Country | USA |
• » Location Description |
75 Virginia Beach Drive Miami, FL 33149 |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | JBENNETT |
» Description |
This table is a compilation of data entered into the Caribbean Commercial Landings (CCL) data set. It contains sensitive detailed information from the logbook reports submitted by the fishers to the USVI DFW. The table may be accessed through the APEX application on the web by those having proper credentials. The data are currently collected from 2 form types. One for St. Thomas/St. John and the other for St. Croix, USVI. |
Change Summary |
Prior to the adoption of the current reporting forms, there were 3 forms. One for St. Croix and two for St. Thomas (one for traps only and one for the remaining gear types: Hook and Line, Dive gear, and Nets). In July 2016 the St. Thomas forms were consolidated into a single form. There have been some species and gears added since the original forms in 2011, but the data set structure has remained the same. See the parent entity for more details. |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | Yes | TRIP_ID | NUMBER | The ID number of the trip. This is generated by the program. |
100 | No | No | TRIP_GEAR_TYPE_ID | NUMBER | Primary Key to the CCL.Trip_gear_type table. Foreign key to the ccl.trip_catch and ccl.trip_gear_type_gear tables. Program generated. |
100 | No | No | TRIP_WEEK | VARCHAR2 | The week number wherein the trip took place. (1-52) |
100 | No | No | TRIP_MONTH | VARCHAR2 | The month wherein the trip took place. |
100 | No | No | TRIP_YEAR | VARCHAR2 | The year wherein the trip landed. |
100 | No | No | TRIP_DAY | VARCHAR2 | The day wherein the trip landed. |
100 | No | No | TRIP_DATE | VARCHAR2 | The landing date of the trip. |
100 | No | No | VESSEL_CD | VARCHAR2 | The state (territorial) id or the USCG id of the fishing craft. |
100 | No | No | TRIP_TICKET_NUM | VARCHAR2 | The trip ticket number is entered on the reporting form when the report is received by USVI DFW. This is different from the trip_id which is assigned by the program when the data are entered. |
100 | No | No | IS_DATA_TAKEN | VARCHAR2 | Indicates whether or not a dockside sample was taken for this trip. |
100 | No | No | IS_DAY_TRIP | VARCHAR2 | Did the majority of the fishing take place at night or during the day? |
100 | No | No | IS_FEDERAL_WATERS | VARCHAR2 | If any part of the trip took place within an area (grid) or distance from shore which is exclusively within federal waters, it is designated as a federal waters trip. |
100 | No | No | IS_TRIP_LEASED | VARCHAR2 | Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips. |
100 | No | No | TRIP_HELPERS_NUM | NUMBER | Number of fishers and/or helpers on board besides the primary fisher. |
100 | No | No | USVI_ISLAND_CD | CHAR | The code for the island or island group where the catch was landed. |
100 | No | No | TRIP_LANDING_LOCATION | VARCHAR2 | The code of the location where the catch was landed. |
100 | No | No | LANDING_LOCATION_NM | VARCHAR2 | The name of the location where the catch was landed. |
100 | No | No | LANDING_LOCATION_COUNTY | VARCHAR2 | The Island (not a county) where the catch was landed. |
100 | No | No | LOCATION_ISLAND | VARCHAR2 | The code for the island on which the catch was landed. |
100 | No | No | IS_SPLIT_CATCH | VARCHAR2 | Was part of the catch from this trip recorded on another fisher's report? |
100 | No | No | TOTAL_TRIP_POUNDS | NUMBER | The total pounds landed for the trip. Since these data are entered separately from the landed pounds by gear and species, some differences may exist. This column is not additive. It should be grouped by trip prior to summation. |
100 | No | No | TOTAL_TRAPS_IN_WATER | NUMBER | The total number of the traps soaking during the time the trip took place. This is not always the same as the number of traps hauled. This field is not additive and should be grouped rather than summed. Traps hauled is summable. |
100 | No | No | IS_INCOMPLETE | VARCHAR2 | Is trip completely entered? |
100 | No | No | GEAR_TYPE_CD | VARCHAR2 | Code for the general gear type. |
100 | No | No | GEAR_TYPE_NM | VARCHAR2 | Name of the general gear type fished. |
100 | No | No | GEAR_CD | VARCHAR2 | The code for the specific gear fished. |
100 | No | No | GEAR_NM | VARCHAR2 | The name for the specific gear fished. |
100 | No | No | HOURS_FISHED | NUMBER | Hours actively fishing on the fishing grounds. This field is also used for lobster traps hours soaked. |
100 | No | No | DEPTH | NUMBER | The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom). |
100 | No | No | DEPTH_UOM | VARCHAR2 | Designates the bottom depth units in feet or fathoms. |
100 | No | No | SPECIES_CD | VARCHAR2 | The ITIS species code. |
100 | No | No | SPECIES_NM | VARCHAR2 | The common name for the species or other taxa. |
100 | No | No | ERDMANS_CD | VARCHAR2 | The code assigned to the species by Dr. Donald Erdman who classified much of the area catch. |
100 | No | No | SPECIES_FAMILY_CD | VARCHAR2 | The common name for the species family or higher taxa. |
100 | No | No | CATCH_LBS | NUMBER | The catch for the species and gear in pounds round (whole). |
100 | No | No | CATCH_GUTTED_LBS | NUMBER | The portion of the catch landed in gutted pounds (no longer on the form). |
100 | No | No | FORM_TEMPLATE_NM | VARCHAR2 | The reporting form type since July 2011. |
100 | No | No | SUBREGION_CD | VARCHAR2 | General catch area by island grouping |
100 | No | No | LU_DATE | DATE | Last date the trip was updated. |
100 | No | No | LU_USER_ID | NUMBER | Last userid to update the trip. |
100 | No | No | GUTTED_TO_WHOLE_POUNDS | NUMBER | Catch in gutted pounds converted to whole pounds (POUNDS column). |
100 | No | No | POUNDS | NUMBER | Round (whole) pounds (including converted gutted pounds) for species caught. |
100 | No | No | PRICE_PER_LBS | NUMBER | Price for landed pounds in dollars. |
100 | No | No | CATCH_VALUE | NUMBER | The POUNDS * the price per pound. |
100 | No | No | PRICE_SOURCE | VARCHAR2 | How was price obtained? |
100 | No | No | LINES_CNT | NUMBER | total number of fishing lines |
100 | No | No | HOOKS_PER_LINE_CNT | NUMBER | Average number of hooks per line |
100 | No | No | FAD_NUM | VARCHAR2 | The number code for the Fish Attraction Device fished. |
100 | No | No | LOBSTER_TRAPS_HAULED | NUMBER | The number of lobster traps hauled during trip, |
100 | No | No | FISH_TRAPS_HAULED | NUMBER | The number of fish traps hauled during trip. |
100 | No | No | FISH_TRAPS_HOURS_SOAKED | NUMBER | The time the fish traps were in the water prior to haul (only for traps hauled this trip). |
100 | No | No | LOBSTER_TRAPS_DAYS_SOAKED | NUMBER | The number of days the lobster traps were in the water prior to haul (only for traps hauled this trip). |
100 | No | No | FISH_TRAPS_DAYS_SOAKED | NUMBER | The number of days fish traps were soaking in the water prior to haul (only for traps hauled this trip). |
100 | No | No | NET_LENGTH | NUMBER | length of net in feet or fathoms. See net_length_uom. |
100 | No | No | MESH_IN | NUMBER | Diagonal mesh size of net in inches. |
100 | No | No | NET_CNT | NUMBER | The number of nets used on the trip. |
100 | No | No | LENGTH_UOM | VARCHAR2 | Net length unit (feet or fathoms). |
100 | No | No | DIVERS_CNT | NUMBER | The total number of divers. |
100 | No | No | DIVES_CNT | NUMBER | The total number of dives. |
100 | No | No | IS_SCUBA | NUMBER | Did the divers use SCUBA? |
100 | No | No | AREA_CD1 | VARCHAR2 | Since July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD2 | VARCHAR2 | See description of area_code1. |
100 | No | No | AREA_CD3 | VARCHAR2 | See description of area_code1. |
100 | No | No | AREA_CD4 | VARCHAR2 | See description of area_code1. |
100 | No | No | AREA_CD5 | VARCHAR2 | See description of area_code1. |
100 | No | No | AREA_CD6 | VARCHAR2 | See description of area_code1. |
100 | No | No | AREA_CD7 | VARCHAR2 | See description of area_code1. |
100 | No | No | AREA_CD8 | VARCHAR2 | See description of area_code1. |
100 | No | No | AREA_CD9 | VARCHAR2 | See description of area_code1. |
100 | No | No | AREA_CD10 | VARCHAR2 | See description of area_code1. |
100 | No | No | DISCARD_FISH_LIVE_CNT | NUMBER | Sum of numbers (not pounds) of discarded fish (live). |
100 | No | No | DISCARD_FISH_DEAD_CNT | NUMBER | Sum of numbers (not pounds) of discarded fish (dead). |
100 | No | No | DISCARD_LOBSTER_LIVE_CNT | NUMBER | Sum of numbers (not pounds) of discarded lobsters (live). |
100 | No | No | DISCARD_LOBSTER_DEAD_CNT | NUMBER | Sum of numbers (not pounds) of discarded lobsters (dead). |
100 | No | No | TRIP_FISHER_ID | NUMBER | The primary key to the ccl.trip_fisher table. |
100 | No | No | FISHER_PERMIT_ID | NUMBER | The primary key to the fisher permit table. |
100 | No | No | FISHER_ROLE_CD | VARCHAR2 | The code for the fisher role (primary fisher or partner). |
100 | No | No | REGION_PERMIT_NUM | VARCHAR2 | The fisher permit number. |
100 | No | No | FISHER_FIRST_NM | VARCHAR2 | The fisher first name. |
100 | No | No | FISHER_LAST_NM | VARCHAR2 | The fisher last name. |
100 | No | No | BUSINESS_NM | VARCHAR2 | The business name (if entity is a business). |
100 | No | No | HMS_PERMIT_NUM | VARCHAR2 | The highly migratory species permit number. |
100 | No | No | CONCH_PERMIT_NUM | VARCHAR2 | The special conch permit number. |
100 | No | No | LOBSTER_PERMIT_NUM | VARCHAR2 | The spiny lobster permit number. |
100 | No | No | PHONE_NUM | VARCHAR2 | The fisher phone number. |
100 | No | No | FISHER_PERMIT_EXP_DT | DATE | The expiration date of the fisher permit. |
100 | No | No | FISHER_ISLAND_CD | VARCHAR2 | The code for the island on which the fisher is registered. |
100 | No | No | ENTITY_ID | NUMBER | Links the fisherman's various regional permit numbers together so he can be traced throughout the data set. |
100 | No | No | IS_INACTIVE | NUMBER | Is the permit inactive? |
100 | No | No | FISHER_ROLE_CD_PARTNER1 | VARCHAR2 | Code indicates PARTNER role. Partners are ranked according to order of entry. |
100 | No | No | FISHER_TYPE_CD_PARTNER1 | VARCHAR2 | Indicates whether partner entity is an individual or a business. |
100 | No | No | REGION_PERMIT_NUM_PARTNER1 | VARCHAR2 | Permit number for partner 1. |
100 | No | No | FISHER_FIRST_NM_PARTNER1 | VARCHAR2 | First name of partner 1. |
100 | No | No | FISHER_LAST_NM_PARTNER1 | VARCHAR2 | Last name of partner 1. |
100 | No | No | FISHER_ROLE_CD_PARTNER2 | VARCHAR2 | Indicates fisher is a partner. |
100 | No | No | FISHER_TYPE_CD_PARTNER2 | VARCHAR2 | Indicates whether fisher entity is an individual or a business. |
100 | No | No | REGION_PERMIT_NUM_PARTNER2 | VARCHAR2 | Permit number for partner 2. |
100 | No | No | FISHER_FIRST_NM_PARTNER2 | VARCHAR2 | First name of partner 2. |
100 | No | No | FISHER_LAST_NM_PARTNER2 | VARCHAR2 | Last name of partner 2. |
100 | No | No | SUBREGION_NM | VARCHAR2 | General island area fished. |
100 | No | No | REGION_CD | VARCHAR2 | Code for region (USVI). |
100 | No | No | REGION_NM | VARCHAR2 | Name for region (U.S. Virgin Islands). |
100 | No | No | FISHER_ISLAND_NM | VARCHAR2 | Name of island by which fisher is permitted. |
100 | No | No | SPECIES_FAMILY_NM | VARCHAR2 | The common name for the family of species in catch. |
100 | No | No | DIALECT_SPECIES_NM1 | VARCHAR2 | Species common name in English. |
100 | No | No | DIALECT_SPCD1 | VARCHAR2 | The code for the dialect. (ex. EN01 is primary English dialect, SP01 is spanish dialect). |
100 | No | No | DIALECT_SPECIES_NM2 | VARCHAR2 | The Spanish name for the species. |
100 | No | No | DIALECT_SPCD2 | VARCHAR2 | Code for the spanish dialect (SP01). |
100 | No | No | DIALECT_SPECIES_NM3 | VARCHAR2 | This is a null column which could be filled with USVI colloquial names. |
100 | No | No | DIALECT_SPCD3 | VARCHAR2 | A null column which could be filled with additional dialect codes. |
100 | No | No | NOTES | VARCHAR2 | Any special notes or comments which accompany the record. |
100 | No | No | NMFS_CODE | VARCHAR2 | The column is null. NMFS species code not yet updated. |
100 | No | No | DATE_OF_EXTRACT | DATE | The date that the data were extracted from the Caribbean Commercial Landings data set. Not the same as the file access date. Extracts typically occur bi-weekly. |
100 | No | No | LOGBOOK_RECEIVED_DT | DATE | Date that the logbook report was received by USVI DFW. |
100 | No | No | FAD_NM | VARCHAR2 | Name of the Fish Attraction Device fished (if any). |
100 | No | No | BOTTOM_DEPTH_MIN | NUMBER | The minimum bottom depth fished during the trip. |
100 | No | No | BOTTOM_DEPTH_MAX | NUMBER | The maximum bottom depth fished during the trip. |
100 | No | No | TOTAL_LOBSTER_TRAPS_IN_WATER | NUMBER | The total number of lobster traps soaking at the time of the trip (not always the same as traps hauled). |
100 | No | No | TOTAL_FISH_TRAPS_IN_WATER | NUMBER | The total fish traps soaking at the time of the trip. (not always the same as the number of traps hauled). |
100 | No | No | DISCARD_SPECIES_CD | VARCHAR2 | ITIS code for discarded species during trip. |
100 | No | No | DISCARDED_CNT | NUMBER | Number of discard species during trip. |
100 | No | No | TRIP_MAY_BE_DUPLICATE | VARCHAR2 | It has been determined that this trip may be a duplicate in the data set. These records are flagged with a 'Y' and may be filtered out if desired. |
Attribute Details
Attribute Name | TRIP_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
The ID number of the trip. This is generated by the program. |
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 | TRIP_GEAR_TYPE_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary Key to the CCL.Trip_gear_type table. Foreign key to the ccl.trip_catch and ccl.trip_gear_type_gear tables. Program generated. |
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 | TRIP_WEEK |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The week number wherein the trip took place. (1-52) |
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 | TRIP_MONTH |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The month wherein the trip took place. |
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 | TRIP_YEAR |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The year wherein the trip landed. |
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 | TRIP_DAY |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The day wherein the trip landed. |
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 | TRIP_DATE |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The landing date of the trip. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | YYYYMMDD |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_CD |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The state (territorial) id or the USCG id of the fishing craft. |
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 | TRIP_TICKET_NUM |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The trip ticket number is entered on the reporting form when the report is received by USVI DFW. This is different from the trip_id which is assigned by the program when the data are entered. |
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 | IS_DATA_TAKEN |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether or not a dockside sample was taken for this trip. |
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 | IS_DAY_TRIP |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Did the majority of the fishing take place at night or during the day? |
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 | IS_FEDERAL_WATERS |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If any part of the trip took place within an area (grid) or distance from shore which is exclusively within federal waters, it is designated as a federal waters trip. |
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 | IS_TRIP_LEASED |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips. |
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 | TRIP_HELPERS_NUM |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of fishers and/or helpers on board besides the primary fisher. |
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 | USVI_ISLAND_CD |
---|---|
Seq. Order | 15 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the island or island group where the catch was landed. |
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 | TRIP_LANDING_LOCATION |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code of the location where the catch was landed. |
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 | LANDING_LOCATION_NM |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the location where the catch was landed. |
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 | LANDING_LOCATION_COUNTY |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Island (not a county) where the catch was landed. |
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 | LOCATION_ISLAND |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the island on which the catch was landed. |
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 | IS_SPLIT_CATCH |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was part of the catch from this trip recorded on another fisher's report? |
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 | TOTAL_TRIP_POUNDS |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total pounds landed for the trip. Since these data are entered separately from the landed pounds by gear and species, some differences may exist. This column is not additive. It should be grouped by trip prior to summation. |
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 | TOTAL_TRAPS_IN_WATER |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total number of the traps soaking during the time the trip took place. This is not always the same as the number of traps hauled. This field is not additive and should be grouped rather than summed. Traps hauled is summable. |
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 | IS_INCOMPLETE |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Is trip completely entered? |
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 | GEAR_TYPE_CD |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the general gear type. |
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 | GEAR_TYPE_NM |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the general gear type fished. |
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 | GEAR_CD |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the specific gear fished. |
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 | GEAR_NM |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name for the specific gear fished. |
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 | HOURS_FISHED |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hours actively fishing on the fishing grounds. This field is also used for lobster traps hours soaked. |
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 | DEPTH |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom). |
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 | DEPTH_UOM |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Designates the bottom depth units in feet or fathoms. |
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 | SPECIES_CD |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The ITIS species code. |
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 | SPECIES_NM |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The common name for the species or other taxa. |
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 | ERDMANS_CD |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code assigned to the species by Dr. Donald Erdman who classified much of the area catch. |
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 | SPECIES_FAMILY_CD |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The common name for the species family or higher taxa. |
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 | CATCH_LBS |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The catch for the species and gear in pounds round (whole). |
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 | CATCH_GUTTED_LBS |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The portion of the catch landed in gutted pounds (no longer on the form). |
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 | FORM_TEMPLATE_NM |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The reporting form type since July 2011. |
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 | SUBREGION_CD |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
General catch area by island grouping |
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 | LU_DATE |
---|---|
Seq. Order | 39 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last date the trip was updated. |
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 | LU_USER_ID |
---|---|
Seq. Order | 40 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last userid to update the trip. |
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 | GUTTED_TO_WHOLE_POUNDS |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Catch in gutted pounds converted to whole pounds (POUNDS column). |
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 | POUNDS |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Round (whole) pounds (including converted gutted pounds) for species caught. |
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 | PRICE_PER_LBS |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Price for landed pounds in dollars. |
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 | CATCH_VALUE |
---|---|
Seq. Order | 44 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The POUNDS * the price per pound. |
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 | PRICE_SOURCE |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
How was price obtained? |
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 | LINES_CNT |
---|---|
Seq. Order | 46 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
total number of fishing lines |
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 | HOOKS_PER_LINE_CNT |
---|---|
Seq. Order | 47 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average number of hooks per line |
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 | FAD_NUM |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number code for the Fish Attraction Device fished. |
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 | LOBSTER_TRAPS_HAULED |
---|---|
Seq. Order | 49 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of lobster traps hauled during trip, |
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 | FISH_TRAPS_HAULED |
---|---|
Seq. Order | 50 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of fish traps hauled during trip. |
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 | FISH_TRAPS_HOURS_SOAKED |
---|---|
Seq. Order | 51 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The time the fish traps were in the water prior to haul (only for traps hauled this trip). |
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 | LOBSTER_TRAPS_DAYS_SOAKED |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of days the lobster traps were in the water prior to haul (only for traps hauled this trip). |
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 | FISH_TRAPS_DAYS_SOAKED |
---|---|
Seq. Order | 53 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of days fish traps were soaking in the water prior to haul (only for traps hauled this trip). |
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 | NET_LENGTH |
---|---|
Seq. Order | 54 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
length of net in feet or fathoms. See net_length_uom. |
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 | MESH_IN |
---|---|
Seq. Order | 55 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Diagonal mesh size of net in inches. |
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 | NET_CNT |
---|---|
Seq. Order | 56 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of nets used on the trip. |
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 | LENGTH_UOM |
---|---|
Seq. Order | 57 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Net length unit (feet or fathoms). |
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 | DIVERS_CNT |
---|---|
Seq. Order | 58 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total number of divers. |
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 | DIVES_CNT |
---|---|
Seq. Order | 59 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total number of dives. |
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 | IS_SCUBA |
---|---|
Seq. Order | 60 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Did the divers use SCUBA? |
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 | AREA_CD1 |
---|---|
Seq. Order | 61 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Since July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
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 | AREA_CD2 |
---|---|
Seq. Order | 62 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | AREA_CD3 |
---|---|
Seq. Order | 63 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | AREA_CD4 |
---|---|
Seq. Order | 64 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | AREA_CD5 |
---|---|
Seq. Order | 65 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | AREA_CD6 |
---|---|
Seq. Order | 66 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | AREA_CD7 |
---|---|
Seq. Order | 67 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | AREA_CD8 |
---|---|
Seq. Order | 68 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | AREA_CD9 |
---|---|
Seq. Order | 69 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | AREA_CD10 |
---|---|
Seq. Order | 70 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
See description of area_code1. |
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 | DISCARD_FISH_LIVE_CNT |
---|---|
Seq. Order | 71 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sum of numbers (not pounds) of discarded fish (live). |
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 | DISCARD_FISH_DEAD_CNT |
---|---|
Seq. Order | 72 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sum of numbers (not pounds) of discarded fish (dead). |
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 | DISCARD_LOBSTER_LIVE_CNT |
---|---|
Seq. Order | 73 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sum of numbers (not pounds) of discarded lobsters (live). |
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 | DISCARD_LOBSTER_DEAD_CNT |
---|---|
Seq. Order | 74 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sum of numbers (not pounds) of discarded lobsters (dead). |
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 | TRIP_FISHER_ID |
---|---|
Seq. Order | 75 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The primary key to the ccl.trip_fisher table. |
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 | FISHER_PERMIT_ID |
---|---|
Seq. Order | 76 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The primary key to the fisher permit table. |
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 | FISHER_ROLE_CD |
---|---|
Seq. Order | 77 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the fisher role (primary fisher or partner). |
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 | REGION_PERMIT_NUM |
---|---|
Seq. Order | 78 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The fisher permit number. |
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 | FISHER_FIRST_NM |
---|---|
Seq. Order | 79 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The fisher first name. |
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 | FISHER_LAST_NM |
---|---|
Seq. Order | 80 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The fisher last name. |
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 | BUSINESS_NM |
---|---|
Seq. Order | 81 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The business name (if entity is a business). |
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 | HMS_PERMIT_NUM |
---|---|
Seq. Order | 82 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The highly migratory species permit number. |
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 | CONCH_PERMIT_NUM |
---|---|
Seq. Order | 83 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The special conch permit number. |
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 | LOBSTER_PERMIT_NUM |
---|---|
Seq. Order | 84 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The spiny lobster permit number. |
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 | PHONE_NUM |
---|---|
Seq. Order | 85 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The fisher phone number. |
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 | FISHER_PERMIT_EXP_DT |
---|---|
Seq. Order | 86 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The expiration date of the fisher permit. |
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 | FISHER_ISLAND_CD |
---|---|
Seq. Order | 87 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the island on which the fisher is registered. |
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 | ENTITY_ID |
---|---|
Seq. Order | 88 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Links the fisherman's various regional permit numbers together so he can be traced throughout the data set. |
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 | IS_INACTIVE |
---|---|
Seq. Order | 89 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Is the permit inactive? |
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 | FISHER_ROLE_CD_PARTNER1 |
---|---|
Seq. Order | 90 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code indicates PARTNER role. Partners are ranked according to order of entry. |
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 | FISHER_TYPE_CD_PARTNER1 |
---|---|
Seq. Order | 91 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether partner entity is an individual or a business. |
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 | REGION_PERMIT_NUM_PARTNER1 |
---|---|
Seq. Order | 92 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Permit number for partner 1. |
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 | FISHER_FIRST_NM_PARTNER1 |
---|---|
Seq. Order | 93 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First name of partner 1. |
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 | FISHER_LAST_NM_PARTNER1 |
---|---|
Seq. Order | 94 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last name of partner 1. |
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 | FISHER_ROLE_CD_PARTNER2 |
---|---|
Seq. Order | 95 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates fisher is a partner. |
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 | FISHER_TYPE_CD_PARTNER2 |
---|---|
Seq. Order | 96 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether fisher entity is an individual or a business. |
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 | REGION_PERMIT_NUM_PARTNER2 |
---|---|
Seq. Order | 97 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Permit number for partner 2. |
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 | FISHER_FIRST_NM_PARTNER2 |
---|---|
Seq. Order | 98 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First name of partner 2. |
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 | FISHER_LAST_NM_PARTNER2 |
---|---|
Seq. Order | 99 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last name of partner 2. |
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 | SUBREGION_NM |
---|---|
Seq. Order | 100 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
General island area fished. |
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 | REGION_CD |
---|---|
Seq. Order | 101 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for region (USVI). |
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 | REGION_NM |
---|---|
Seq. Order | 102 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name for region (U.S. Virgin Islands). |
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 | FISHER_ISLAND_NM |
---|---|
Seq. Order | 103 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of island by which fisher is permitted. |
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 | SPECIES_FAMILY_NM |
---|---|
Seq. Order | 104 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The common name for the family of species in catch. |
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 | DIALECT_SPECIES_NM1 |
---|---|
Seq. Order | 105 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species common name in English. |
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 | DIALECT_SPCD1 |
---|---|
Seq. Order | 106 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the dialect. (ex. EN01 is primary English dialect, SP01 is spanish dialect). |
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 | DIALECT_SPECIES_NM2 |
---|---|
Seq. Order | 107 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Spanish name for the species. |
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 | DIALECT_SPCD2 |
---|---|
Seq. Order | 108 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the spanish dialect (SP01). |
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 | DIALECT_SPECIES_NM3 |
---|---|
Seq. Order | 109 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
This is a null column which could be filled with USVI colloquial names. |
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 | DIALECT_SPCD3 |
---|---|
Seq. Order | 110 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A null column which could be filled with additional dialect codes. |
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 | NOTES |
---|---|
Seq. Order | 111 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any special notes or comments which accompany the record. |
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 | NMFS_CODE |
---|---|
Seq. Order | 112 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | In Development |
Description |
The column is null. NMFS species code not yet updated. |
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 | DATE_OF_EXTRACT |
---|---|
Seq. Order | 113 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date that the data were extracted from the Caribbean Commercial Landings data set. Not the same as the file access date. Extracts typically occur bi-weekly. |
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 | LOGBOOK_RECEIVED_DT |
---|---|
Seq. Order | 114 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date that the logbook report was received by USVI DFW. |
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 | FAD_NM |
---|---|
Seq. Order | 115 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the Fish Attraction Device fished (if any). |
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 | BOTTOM_DEPTH_MIN |
---|---|
Seq. Order | 116 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The minimum bottom depth fished during the trip. |
General Data Type | |
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 | BOTTOM_DEPTH_MAX |
---|---|
Seq. Order | 117 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The maximum bottom depth fished during the trip. |
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 | TOTAL_LOBSTER_TRAPS_IN_WATER |
---|---|
Seq. Order | 118 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total number of lobster traps soaking at the time of the trip (not always the same as traps hauled). |
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 | TOTAL_FISH_TRAPS_IN_WATER |
---|---|
Seq. Order | 119 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total fish traps soaking at the time of the trip. (not always the same as the number of traps hauled). |
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 | DISCARD_SPECIES_CD |
---|---|
Seq. Order | 120 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
ITIS code for discarded species during trip. |
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 | DISCARDED_CNT |
---|---|
Seq. Order | 121 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of discard species during trip. |
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 | TRIP_MAY_BE_DUPLICATE |
---|---|
Seq. Order | 122 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
It has been determined that this trip may be a duplicate in the data set. These records are flagged with a 'Y' and may be filtered out if desired. |
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 | Data Steward |
---|---|
* » Date Effective From | 2006-07-31 |
Date Effective To | 2017 |
Person | Bennett, Joshua |
Email Address | |
Phone | |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
email: joshua.bennett@noaa.gov |
* » Support Role | Metadata Contact |
---|---|
* » Date Effective From | 2006-07-31 |
Date Effective To | 2017 |
Person | Bennett, Joshua |
Email Address | |
Phone | |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Point of Contact |
---|---|
* » Date Effective From | 2006-07-31 |
Date Effective To | 2017 |
Person | Bennett, Joshua |
Email Address | |
Phone | |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
Contact by email at joshua.bennett@noaa.gov |
* » 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 |
Fishing areas surrounding the US Virgin Islands. Territorial waters to 3 miles and Federal waters from 3-200 miles out where not bounded by waters belonging to other countries. For the purpose of this map the area encompasses the fishing area code maps given to the fishers to report their position. These maps are available through a link to US Caribbean fisheries forms listed separately in URLs section of these metadata. |
---|
Extent Group 1 / Geographic Area 1
* » W° Bound | -65.66666666667 |
---|---|
* » E° Bound | -64 |
* » N° Bound | 18.75 |
* » S° Bound | 17 |
* » Description |
Fishing areas surrounding the US Virgin Islands. Territorial waters to 3 miles and Federal waters from 3-200 miles out where not bounded by waters belonging to other countries. For the purpose of this map the area encompasses the fishing area code maps given to the fishers to report their position. These maps are available through a link listed separately in these metadata. |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame 1
* » Time Frame Type | Continuing |
---|---|
* » Start | 1974-07-01 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
Commercial Landings from the USVI. |
Access Information
* » Security Class | Sensitive |
---|---|
* Security Classification System |
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 |
Security Handling Description |
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. |
• Data Access Policy |
See NOAA Administrative Order 216-100 NOAA ADMINISTRATIVE ORDER SERIES Date of Issuance: July 26, 1994 |
» Data Access Procedure |
These standards and procedures apply to all employees of the SEFSC that need access to confidential 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 NOAA 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 non-federal) 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 NOAA 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 confidential 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. |
• » Data Access Constraints |
To access confidential (sensitive) data a completed non-disclosure agreement must be on file with NOAA-SEFSC. Otherwise Data that are submitted as confidential can be released to the public under the following circumstances: 1. Combined or aggregated data. Confidential (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, confidential data Can be released as non-confidential 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. Confidential (sensitive) data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that submitted the data. 4. Confidential (sensitive) data waived. The protection of confidential data can be waived by the person or business that submitted the data. |
• Data Use Constraints |
Senisitve data are not to be released in any publication, report, oral presentation, or other means to the public. |
Metadata Access Constraints |
Non-published Metadata access is restricted. Published Metadata is available to the public. |
Metadata Use Constraints |
Use only Published Metadata. |
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 | 37481 |
---|---|
Metadata Record Created By | Joshua Bennett |
Metadata Record Created | 2017-03-29 09:46+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2021-05-06 |
Owner Org | SEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2021-05-06 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-05-06 |
Tags |
---|