Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FLS_TRIPS
Short Name: FLS_TRIPS
Status: Completed
Abstract:

Contains trip information per fishing trip.

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

Contains trip information per fishing trip.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key 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: 27363
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: 27364
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: 27365
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: 27366
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: 27367
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: 27368
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: 27369
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: 27370
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: 27371
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: 27372
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: 27373
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: 27374
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: 27375
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: 27376
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: 27377
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: 27378
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: 27379
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: 27380
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: 27381
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: 27382
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: 27383
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: 27384
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: 27385
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: 7172
GUID: gov.noaa.nmfs.inport:7172
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07