Table: FLS_TRIPS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6872 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: FLS_TRIPS |
|---|---|
| Short Name: | FLS_TRIPS |
| Status: | Completed |
| Abstract: |
Contains trip information per fishing trip. |
| Notes: |
Loaded by batch 2043, 12-20-2007 08:10 |
Physical Location
| Organization: | Southeast Fisheries Science Center |
|---|---|
| City: | Miami |
| State/Province: | FL |
| Country: | USA |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | FLS |
| Description: |
Contains trip information per fishing trip. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
LOGBOOK_KEY | NUMBER | Automatic sequence that links all the tables that hold information related to trips. |
|
100
|
SCHEDULE_NUMBER | VARCHAR2 | A number stamped on each logbook form. | |
|
100
|
VESSEL_ID | VARCHAR2 | Vessel Identifier | |
|
100
|
VESSEL_NAME | VARCHAR2 | Name of the vessel that matches the vessel id. | |
|
100
|
TELEPHONE | VARCHAR2 | Phone number that appears on the logbook. | |
|
100
|
DAYS_FISHED | NUMBER | Number of days during which fishing occurred. | |
|
100
|
DAYS_AWAY | NUMBER | Number of days from, departure to landing, the vessel was away from port. | |
|
100
|
FIRST_SET_DATE | DATE | Date on which the first set occurred, i.e., when gear was first deployed. | |
|
100
|
LAST_SET_DATE | DATE | Date on which the last set of gear were retrieved before saling back to port. | |
|
100
|
LANDING_DATE | DATE | Date when the catch was unloaded at a dealer | |
|
100
|
NUMBER_OF_CREW | NUMBER | Number of personnel engaged in fishing during the trip. | |
|
100
|
CARCASS_WEIGHT_SHEET | VARCHAR2 | Indicates whether a carcass weight (i.e., dealer weighout sheet) was attached. | |
|
100
|
FISHED_SAME_DAY | VARCHAR2 | Indicates whether there were more fishing trips on the same day. | |
|
100
|
VESSEL_VERIFIED | VARCHAR2 | Indicates whether the vessel id was verified. | |
|
100
|
ERRORS_IN_THIS_TABLE | VARCHAR2 | Validation errors in this record? | |
|
100
|
ERRORS_IN_THIS_LOGBOOK | VARCHAR2 | Indicates whether there were any rows with errors in any of the main data tables that hold data for a specific logbook | |
|
100
|
BATCH_NUMBER | VARCHAR2 | The batch number is the number of the batch where the trip was processed. | |
|
100
|
SOURCE_FILE | VARCHAR2 | Name of the file loaded into the system of which this logbook is a part. | |
|
100
|
UNLOAD_DATE | DATE | Unload Date | |
|
100
|
TRIP_TICKET | VARCHAR2 | Trip Ticket Number | |
|
100
|
FORMTYPE | VARCHAR2 | The form may change at the end of each year; therefore, a column is necessary to identify which form was used to collect the data | |
|
100
|
OPERATOR_NAME | VARCHAR2 | Operator Name | |
|
100
|
OPERATOR_NUMBER | VARCHAR2 | Operator Number |
Attribute Details
LOGBOOK_KEY
CC ID: 25011
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Automatic sequence that links all the tables that hold information related to trips. |
| General Data Type: | NUMBER |
SCHEDULE_NUMBER
CC ID: 25012
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
A number stamped on each logbook form. |
| General Data Type: | VARCHAR2 |
VESSEL_ID
CC ID: 25013
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel Identifier |
| General Data Type: | VARCHAR2 |
VESSEL_NAME
CC ID: 25014
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of the vessel that matches the vessel id. |
| General Data Type: | VARCHAR2 |
TELEPHONE
CC ID: 25015
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Phone number that appears on the logbook. |
| General Data Type: | VARCHAR2 |
DAYS_FISHED
CC ID: 25016
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of days during which fishing occurred. |
| General Data Type: | NUMBER |
DAYS_AWAY
CC ID: 25017
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of days from, departure to landing, the vessel was away from port. |
| General Data Type: | NUMBER |
FIRST_SET_DATE
CC ID: 25018
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date on which the first set occurred, i.e., when gear was first deployed. |
| General Data Type: | DATE |
LAST_SET_DATE
CC ID: 25019
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date on which the last set of gear were retrieved before saling back to port. |
| General Data Type: | DATE |
LANDING_DATE
CC ID: 25020
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date when the catch was unloaded at a dealer |
| General Data Type: | DATE |
NUMBER_OF_CREW
CC ID: 25021
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of personnel engaged in fishing during the trip. |
| General Data Type: | NUMBER |
CARCASS_WEIGHT_SHEET
CC ID: 25022
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates whether a carcass weight (i.e., dealer weighout sheet) was attached. |
| General Data Type: | VARCHAR2 |
FISHED_SAME_DAY
CC ID: 25023
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates whether there were more fishing trips on the same day. |
| General Data Type: | VARCHAR2 |
VESSEL_VERIFIED
CC ID: 25024
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates whether the vessel id was verified. |
| General Data Type: | VARCHAR2 |
ERRORS_IN_THIS_TABLE
CC ID: 25025
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Validation errors in this record? |
| General Data Type: | VARCHAR2 |
ERRORS_IN_THIS_LOGBOOK
CC ID: 25026
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates whether there were any rows with errors in any of the main data tables that hold data for a specific logbook |
| General Data Type: | VARCHAR2 |
BATCH_NUMBER
CC ID: 25027
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The batch number is the number of the batch where the trip was processed. |
| General Data Type: | VARCHAR2 |
SOURCE_FILE
CC ID: 25028
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of the file loaded into the system of which this logbook is a part. |
| General Data Type: | VARCHAR2 |
UNLOAD_DATE
CC ID: 25029
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unload Date |
| General Data Type: | DATE |
TRIP_TICKET
CC ID: 25030
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Trip Ticket Number |
| General Data Type: | VARCHAR2 |
FORMTYPE
CC ID: 25031
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 9 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The form may change at the end of each year; therefore, a column is necessary to identify which form was used to collect the data |
| General Data Type: | VARCHAR2 |
OPERATOR_NAME
CC ID: 25032
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Operator Name |
| General Data Type: | VARCHAR2 |
OPERATOR_NUMBER
CC ID: 25033
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Operator Number |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 6872 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:6872 |
| Metadata Record Created By: | Lee M Weinberger |
| Metadata Record Created: | 2007-12-20 08:10+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:10+0000 |
| Metadata Record Published: | 2021-05-07 |
| Owner Org: | SEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2021-05-07 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-05-07 |