Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Atlas Remote Client > AFSC/FMA/ATLAS Remote Client >

Table: NON_FISHING_DAY

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:7541  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This entitity represents the date and location of every day during a trip where fishing did not occur.

Description

This entitity represents the date and location of every day during a trip where fishing did not occur.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
NO_FISHING_DAY_SEQ
NUMBER 		Sequence generated unique identifier of a non-fishing day record
CRUISE_VESSEL_SEQ
NUMBER 		Sequence generated unique identifier for a cruise vessel. FK value to support no fishing port days.
NONFISH_DATE
DATE 		Date on which no fishing activity occured
LATITUDE_DEGREES
NUMBER 		Latitude of non fishing day (not time specfic) in degrees.
LATITUDE_MINUTES
NUMBER 		Latitude of non fishing day (not time specfic) in minutes
LATITUDE_SEC
NUMBER 		Latitude of non fishing day (not time specfic) in seconds
LONGITUDE_DEGREES
NUMBER 		Longitude of of non fishing day (not time specfic) in degrees.
LONGITUDE_MINUTES
NUMBER 		Longitude of non fishing day (not time specfic) in minutes
LONGITUDE_SEC
NUMBER 		Longitude of non fishing day (not time specfic)
LONGITUDE_EW
VARCHAR2 		East West Longitude indicator for a non fishing day locaton.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

This entitity represents the date and location of every day during a trip where fishing did not occur.
Notes:

Loaded by batch 2204, 03-28-2008 14:09

Entity Information

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

This entitity represents the date and location of every day during a trip where fishing did not occur.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key NO_FISHING_DAY_SEQ NUMBER Sequence generated unique identifier of a non-fishing day record
100
 CRUISE_VESSEL_SEQ NUMBER Sequence generated unique identifier for a cruise vessel. FK value to support no fishing port days.
100
 NONFISH_DATE DATE Date on which no fishing activity occured
100
 LATITUDE_DEGREES NUMBER Latitude of non fishing day (not time specfic) in degrees.
100
 LATITUDE_MINUTES NUMBER Latitude of non fishing day (not time specfic) in minutes
100
 LATITUDE_SEC NUMBER Latitude of non fishing day (not time specfic) in seconds
100
 LONGITUDE_DEGREES NUMBER Longitude of of non fishing day (not time specfic) in degrees.
100
 LONGITUDE_MINUTES NUMBER Longitude of non fishing day (not time specfic) in minutes
100
 LONGITUDE_SEC NUMBER Longitude of non fishing day (not time specfic)
100
 LONGITUDE_EW VARCHAR2 East West Longitude indicator for a non fishing day locaton.

Attribute Details

NO_FISHING_DAY_SEQ

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

Sequence generated unique identifier of a non-fishing day record
General Data Type: NUMBER

CRUISE_VESSEL_SEQ

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

Sequence generated unique identifier for a cruise vessel. FK value to support no fishing port days.
General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.CRUISE_VESSEL

NONFISH_DATE

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

Date on which no fishing activity occured
General Data Type: DATE

LATITUDE_DEGREES

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

Latitude of non fishing day (not time specfic) in degrees.
General Data Type: NUMBER

LATITUDE_MINUTES

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

Latitude of non fishing day (not time specfic) in minutes
General Data Type: NUMBER

LATITUDE_SEC

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

Latitude of non fishing day (not time specfic) in seconds
General Data Type: NUMBER

LONGITUDE_DEGREES

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

Longitude of of non fishing day (not time specfic) in degrees.
General Data Type: NUMBER

LONGITUDE_MINUTES

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

Longitude of non fishing day (not time specfic) in minutes
General Data Type: NUMBER

LONGITUDE_SEC

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

Longitude of non fishing day (not time specfic)
General Data Type: NUMBER

LONGITUDE_EW

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

East West Longitude indicator for a non fishing day locaton.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7541
GUID: gov.noaa.nmfs.inport:7541
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-28 14:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-04