Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: FLS_FISHING_ACTIVITIES

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6868  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data Table containg information on the location of fishing effort

Description

Data Table containg information on the location of fishing effort

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISHING_ACTIVITY_KEY
NUMBER 		Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value
FORM_NUMBER
VARCHAR2 		The number that is physically printed on the logbook form by the printer. The number is different in the original and duplicate form.Validation:A unique key prevents duplicate form numbers. The column is optional and may be left null.
SET_DATE
DATE 		Date when gear was tended.Validation:This field must be a valid date.
SET_QUARTER
VARCHAR2 		A generated field derived from the date of set (SET_DATE) that indicates which part of the year under which the logbook falls. This is created to facility reporting.Validation:This column is validated using the domain QUARTER, which prevents any codes not previously defined from being entered.
BEGIN_SET_TIME
NUMBER 		Date on which the gear was deployed.Validation: Information in this column must be numeric and up to four digits long.
BEGIN_SET_MERIDIAN
VARCHAR2 		Time meridian (AM or PM) of the beginning set time.Validation:This column is validated using the domain MERIDIAN.
END_SET_TIME
NUMBER 		Time at which the gear deployment ended.Validation:Information in this column must be numeric and up to four digits long.
END_SET_MERIDIAN
VARCHAR2 		Time meridian (AM or PM) of the ending set time.Validation:This column is validated using the domain MERIDIAN.
HAULBACK_DATE
DATE 		Date on which gear was hauled back.Validation:This field must be a valid date.
BEGIN_HAULBACK_TIME
NUMBER 		Time at which haulback began. This time is converted to military time before data are distributed to the master tables.Validation: Information in this column must be numeric and up to four digits long.
BEGIN_HAULBACK_MERIDIAN
VARCHAR2 		Meridian of the begining haulback time, used to convert data to military time.Validation: This column is validated using the domain MERIDIAN.
END_HAULBACK_TIME
NUMBER 		Time at which haulback ended. This time is converted to military time before data are distributed to the master tables.Validation: Information in this column must be numeric and up to four digits long.
END_HAULBACK_MERIDIAN
VARCHAR2 		Meridian of the ending haulback time. It is used to convert the ending haulback time to military time.Validation:This column is validated using the domain MERIDIAN.
LATITUDE_DEGREES
NUMBER 		Latitude degrees where the fishing activity took place.Validation: Information in this column must be numeric and its value less than 50.
LATITUDE_HEMISPHERE
VARCHAR2 		Latitude hemisphere for the latitude degrees.Validation:This column is validated using the domain LATITUDE_HEMISPHERE.
LONGITUDE_DEGREES
NUMBER 		Degrees of longitude where the fishing activity took place.Validation:Information in this column must be numeric and the value must be between 20 and 100.
LONGITUDE_HEMISPHERE
VARCHAR2 		Hemisphere of the longitude degrees where the fishing activity occurred.Validation:This column is validated using the domain LONGITUDE_HEMISPHERE .
LORAN1
VARCHAR2 		Loran radio signal from first radio station.Validation:None.
LORAN2
VARCHAR2 		Loran radio signal from first radio station.Validation:None.
SURFACE_WATER_TEMPERATURE
NUMBER 		Surface Water Tamperature expressed in degrees Fahrenheit.
TEMPERATURE_MSU
VARCHAR2 		Standard Measuring Unit For temperature
ORIGINAL_BATCH_SEQUENCE_NUMBER
VARCHAR2 		Original Batch Sequence Number On The logbook form
LOGBOOK_KEY
NUMBER 		Foreign key to the FLS_TRIPS and other master tables.Validation:A foreign key enforces that trip information must have been entered into the FLS_TRIP table before fishing activity data can be added.
LATITUDE_MINUTES
NUMBER 		Latitude minutes where the fishing activity took place.
LONGITUDE_MINUTES
NUMBER 		Longitude minutes where the fishing activity took place
ORIGINAL_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:A foreign key to the table FLS_VESSEL_LIST ensures that the vessel IDs have been permitted by SERO.
SET_DATE_STRING
VARCHAR2 		Set date shown as a character value
HAULBACK_DATE_STRING
VARCHAR2 		Haulback date shown as a character value
GT_24_HRS
VARCHAR2 		GT 24 Hours

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

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

Data Table containg information on the location of fishing effort
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:

Data Table containg information on the location of fishing effort

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key FISHING_ACTIVITY_KEY NUMBER Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value
100
 FORM_NUMBER VARCHAR2 The number that is physically printed on the logbook form by the printer. The number is different in the original and duplicate form.Validation:A unique key prevents duplicate form numbers. The column is optional and may be left null.
100
 SET_DATE DATE Date when gear was tended.Validation:This field must be a valid date.
100
 SET_QUARTER VARCHAR2 A generated field derived from the date of set (SET_DATE) that indicates which part of the year under which the logbook falls. This is created to facility reporting.Validation:This column is validated using the domain QUARTER, which prevents any codes not previously defined from being entered.
100
 BEGIN_SET_TIME NUMBER Date on which the gear was deployed.Validation: Information in this column must be numeric and up to four digits long.
100
 BEGIN_SET_MERIDIAN VARCHAR2 Time meridian (AM or PM) of the beginning set time.Validation:This column is validated using the domain MERIDIAN.
100
 END_SET_TIME NUMBER Time at which the gear deployment ended.Validation:Information in this column must be numeric and up to four digits long.
100
 END_SET_MERIDIAN VARCHAR2 Time meridian (AM or PM) of the ending set time.Validation:This column is validated using the domain MERIDIAN.
100
 HAULBACK_DATE DATE Date on which gear was hauled back.Validation:This field must be a valid date.
100
 BEGIN_HAULBACK_TIME NUMBER Time at which haulback began. This time is converted to military time before data are distributed to the master tables.Validation: Information in this column must be numeric and up to four digits long.
100
 BEGIN_HAULBACK_MERIDIAN VARCHAR2 Meridian of the begining haulback time, used to convert data to military time.Validation: This column is validated using the domain MERIDIAN.
100
 END_HAULBACK_TIME NUMBER Time at which haulback ended. This time is converted to military time before data are distributed to the master tables.Validation: Information in this column must be numeric and up to four digits long.
100
 END_HAULBACK_MERIDIAN VARCHAR2 Meridian of the ending haulback time. It is used to convert the ending haulback time to military time.Validation:This column is validated using the domain MERIDIAN.
100
 LATITUDE_DEGREES NUMBER Latitude degrees where the fishing activity took place.Validation: Information in this column must be numeric and its value less than 50.
100
 LATITUDE_HEMISPHERE VARCHAR2 Latitude hemisphere for the latitude degrees.Validation:This column is validated using the domain LATITUDE_HEMISPHERE.
100
 LONGITUDE_DEGREES NUMBER Degrees of longitude where the fishing activity took place.Validation:Information in this column must be numeric and the value must be between 20 and 100.
100
 LONGITUDE_HEMISPHERE VARCHAR2 Hemisphere of the longitude degrees where the fishing activity occurred.Validation:This column is validated using the domain LONGITUDE_HEMISPHERE .
100
 LORAN1 VARCHAR2 Loran radio signal from first radio station.Validation:None.
100
 LORAN2 VARCHAR2 Loran radio signal from first radio station.Validation:None.
100
 SURFACE_WATER_TEMPERATURE NUMBER Surface Water Tamperature expressed in degrees Fahrenheit.
100
 TEMPERATURE_MSU VARCHAR2 Standard Measuring Unit For temperature
100
 ORIGINAL_BATCH_SEQUENCE_NUMBER VARCHAR2 Original Batch Sequence Number On The logbook form
100
 LOGBOOK_KEY NUMBER Foreign key to the FLS_TRIPS and other master tables.Validation:A foreign key enforces that trip information must have been entered into the FLS_TRIP table before fishing activity data can be added.
100
 LATITUDE_MINUTES NUMBER Latitude minutes where the fishing activity took place.
100
 LONGITUDE_MINUTES NUMBER Longitude minutes where the fishing activity took place
100
 ORIGINAL_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:A foreign key to the table FLS_VESSEL_LIST ensures that the vessel IDs have been permitted by SERO.
100
 SET_DATE_STRING VARCHAR2 Set date shown as a character value
100
 HAULBACK_DATE_STRING VARCHAR2 Haulback date shown as a character value
100
 GT_24_HRS VARCHAR2 GT 24 Hours

Attribute Details

FISHING_ACTIVITY_KEY

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

Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value
General Data Type: NUMBER

FORM_NUMBER

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

The number that is physically printed on the logbook form by the printer. The number is different in the original and duplicate form.Validation:A unique key prevents duplicate form numbers. The column is optional and may be left null.
General Data Type: VARCHAR2

SET_DATE

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

Date when gear was tended.Validation:This field must be a valid date.
General Data Type: DATE

SET_QUARTER

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

A generated field derived from the date of set (SET_DATE) that indicates which part of the year under which the logbook falls. This is created to facility reporting.Validation:This column is validated using the domain QUARTER, which prevents any codes not previously defined from being entered.
General Data Type: VARCHAR2

BEGIN_SET_TIME

CC ID: 24832
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Date on which the gear was deployed.Validation: Information in this column must be numeric and up to four digits long.
General Data Type: NUMBER

BEGIN_SET_MERIDIAN

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

Time meridian (AM or PM) of the beginning set time.Validation:This column is validated using the domain MERIDIAN.
General Data Type: VARCHAR2

END_SET_TIME

CC ID: 24834
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Time at which the gear deployment ended.Validation:Information in this column must be numeric and up to four digits long.
General Data Type: NUMBER

END_SET_MERIDIAN

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

Time meridian (AM or PM) of the ending set time.Validation:This column is validated using the domain MERIDIAN.
General Data Type: VARCHAR2

HAULBACK_DATE

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

Date on which gear was hauled back.Validation:This field must be a valid date.
General Data Type: DATE

BEGIN_HAULBACK_TIME

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

Time at which haulback began. This time is converted to military time before data are distributed to the master tables.Validation: Information in this column must be numeric and up to four digits long.
General Data Type: NUMBER

BEGIN_HAULBACK_MERIDIAN

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

Meridian of the begining haulback time, used to convert data to military time.Validation: This column is validated using the domain MERIDIAN.
General Data Type: VARCHAR2

END_HAULBACK_TIME

CC ID: 24839
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Time at which haulback ended. This time is converted to military time before data are distributed to the master tables.Validation: Information in this column must be numeric and up to four digits long.
General Data Type: NUMBER

END_HAULBACK_MERIDIAN

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

Meridian of the ending haulback time. It is used to convert the ending haulback time to military time.Validation:This column is validated using the domain MERIDIAN.
General Data Type: VARCHAR2

LATITUDE_DEGREES

CC ID: 24841
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude degrees where the fishing activity took place.Validation: Information in this column must be numeric and its value less than 50.
General Data Type: NUMBER

LATITUDE_HEMISPHERE

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

Latitude hemisphere for the latitude degrees.Validation:This column is validated using the domain LATITUDE_HEMISPHERE.
General Data Type: VARCHAR2

LONGITUDE_DEGREES

CC ID: 24843
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Degrees of longitude where the fishing activity took place.Validation:Information in this column must be numeric and the value must be between 20 and 100.
General Data Type: NUMBER

LONGITUDE_HEMISPHERE

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

Hemisphere of the longitude degrees where the fishing activity occurred.Validation:This column is validated using the domain LONGITUDE_HEMISPHERE .
General Data Type: VARCHAR2

LORAN1

CC ID: 24845
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Loran radio signal from first radio station.Validation:None.
General Data Type: VARCHAR2

LORAN2

CC ID: 24846
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Loran radio signal from first radio station.Validation:None.
General Data Type: VARCHAR2

SURFACE_WATER_TEMPERATURE

CC ID: 24847
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Surface Water Tamperature expressed in degrees Fahrenheit.
General Data Type: NUMBER

TEMPERATURE_MSU

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

Standard Measuring Unit For temperature
General Data Type: VARCHAR2

ORIGINAL_BATCH_SEQUENCE_NUMBER

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

Original Batch Sequence Number On The logbook form
General Data Type: VARCHAR2

LOGBOOK_KEY

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

Foreign key to the FLS_TRIPS and other master tables.Validation:A foreign key enforces that trip information must have been entered into the FLS_TRIP table before fishing activity data can be added.
General Data Type: NUMBER

LATITUDE_MINUTES

CC ID: 24851
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude minutes where the fishing activity took place.
General Data Type: NUMBER

LONGITUDE_MINUTES

CC ID: 24852
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude minutes where the fishing activity took place
General Data Type: NUMBER

ORIGINAL_VESSEL_ID

CC ID: 24853
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
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:A foreign key to the table FLS_VESSEL_LIST ensures that the vessel IDs have been permitted by SERO.
General Data Type: VARCHAR2

SET_DATE_STRING

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

Set date shown as a character value
General Data Type: VARCHAR2

HAULBACK_DATE_STRING

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

Haulback date shown as a character value
General Data Type: VARCHAR2

GT_24_HRS

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

GT 24 Hours
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6868
GUID: gov.noaa.nmfs.inport:6868
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