Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Stores detailed data on the discard of species during a Fishing trip.

Notes:

Loaded by batch 2123, 02-29-2008 11:45

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None discards
None grouper
None header data
None mackerel
None reef fish

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 2001-present

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None gulf of mexico
None south atlantic

Entity Information

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

Stores detailed data on the discard of species during a Fishing trip.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
LOGBOOK_KEY NUMBER Sequential Key
100
BATCH_NUMBER VARCHAR2 An arbitrary sequential number that identifies a group of logbooks that is sent to the data entry contractor. This number is assigned by the Fisheries Logbook manager or any of his team members. All logbooks loaded as part of the same batch have the same batch number.Validation:Cannot be duplicate.
100
Primary Key DISCARD_SCHEDULE_NUMBER VARCHAR2 Schedule Number On The Discard Form
100
SCHEDULE_NUMBER VARCHAR2 The same Schedule number that is assigned to the trip logbook.VALIDATION:This number must be uniquefor the entire database. The Vessel Id and Start Date has to match the same Vessel Id and Start Date for the same Schedule Number in the logbook data.
100
VESSEL_ID VARCHAR2 Unique identifier that distiguishes each vessel. This identification number is generally assigned either by the Coast Guard or the state. This is the number that is used by the Sotheast Regional Office (SERO) to issue permits.Validation:The Vessel Id number has to be a valid number. It must match the vessel number in the logbook data with the same Schedule and Start date.
100
PHONE_NUMBER VARCHAR2 Contact Number For Vessel Owner or Operator
100
START_DATE DATE Date when the vessel set sail to begin the trip. It is also referred to as Departure Date.Validation:The date must be valid. It cannot be null. It must match the start date in the logbook data with the same Schedule, Vessel Id.The format of the date is YYYYMMDD, which is the standard format of all character fields that contain dates (this is done to simplify sorting by date.)
100
DISCARD_NONE VARCHAR2 Indicates Whether Or Not there wera any discards
100
RECEIVED_DATE DATE Date Form Was Received By Logbook Processing Team
100
FORM_ID VARCHAR2 Number which identify each form.
100
SOURCE_FILE VARCHAR2 Name Of The SOurce File used to load this record

Attribute Details

LOGBOOK_KEY

CC ID: 27495
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Sequential Key

General Data Type: NUMBER

BATCH_NUMBER

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

An arbitrary sequential number that identifies a group of logbooks that is sent to the data entry contractor. This number is assigned by the Fisheries Logbook manager or any of his team members. All logbooks loaded as part of the same batch have the same batch number.Validation:Cannot be duplicate.

General Data Type: VARCHAR2

DISCARD_SCHEDULE_NUMBER

CC ID: 27497
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: Yes
Status: Active
Description:

Schedule Number On The Discard Form

General Data Type: VARCHAR2

SCHEDULE_NUMBER

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

The same Schedule number that is assigned to the trip logbook.VALIDATION:This number must be uniquefor the entire database. The Vessel Id and Start Date has to match the same Vessel Id and Start Date for the same Schedule Number in the logbook data.

General Data Type: VARCHAR2

VESSEL_ID

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

Unique identifier that distiguishes each vessel. This identification number is generally assigned either by the Coast Guard or the state. This is the number that is used by the Sotheast Regional Office (SERO) to issue permits.Validation:The Vessel Id number has to be a valid number. It must match the vessel number in the logbook data with the same Schedule and Start date.

General Data Type: VARCHAR2

PHONE_NUMBER

CC ID: 27500
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Contact Number For Vessel Owner or Operator

General Data Type: VARCHAR2

START_DATE

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

Date when the vessel set sail to begin the trip. It is also referred to as Departure Date.Validation:The date must be valid. It cannot be null. It must match the start date in the logbook data with the same Schedule, Vessel Id.The format of the date is YYYYMMDD, which is the standard format of all character fields that contain dates (this is done to simplify sorting by date.)

General Data Type: DATE

DISCARD_NONE

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

Indicates Whether Or Not there wera any discards

General Data Type: VARCHAR2

RECEIVED_DATE

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

Date Form Was Received By Logbook Processing Team

General Data Type: DATE

FORM_ID

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

Number which identify each form.

General Data Type: VARCHAR2

SOURCE_FILE

CC ID: 27505
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name Of The SOurce File used to load this record

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7188
GUID: gov.noaa.nmfs.inport:7188
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-29 11:45+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