19041
Table: ATL_NON_FISHING_DAY
ATL_NON_FISHING_DAY
Entity
Published / External
18964
AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions
Data Set
Completed
This entitity represents the date and location of every day during a trip where fishing did not occur. For 2009 this concept was expanded to days wth no observer activity at a processing plant. To impliment this change all non PK fields sans date bacame optional.
Loaded by batch 4574, 05-03-2013 17:18
Data Table
Yes
NPRB_1017
This entitity represents the date and location of every day during a trip where fishing did not occur. For 2009 this concept was expanded to days wth no observer activity at a processing plant. To impliment this change all non PK fields sans date bacame optional.
1
CRUISE
NUMBER
22
Yes
Yes
8
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
NPRB_1017.ATL_CRUISE_PLANT
2
NO_FISHING_DAY_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of a non-fishing day record
NUMBER
3
CRUISE_VESSEL_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier for a cruise vessel.
NUMBER
NPRB_1017.ATL_CRUISE_VESSEL
4
NONFISH_DATE
DATE
7
Yes
No
Active
Date on which no fishing activity occured
DATE
5
LATITUDE_DEGREES
NUMBER
22
No
No
38
0
Active
Latitude of non fishing day (not time specfic) in degrees.
NUMBER
6
LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Latitude of non fishing day (not time specfic) in minutes
NUMBER
7
LATITUDE_SEC
NUMBER
22
No
No
2
0
Active
Latitude of non fishing day (not time specfic) in seconds
NUMBER
8
LONGITUDE_DEGREES
NUMBER
22
No
No
3
0
Active
Longitude of of non fishing day (not time specfic) in degrees.
NUMBER
9
LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Longitude of non fishing day (not time specfic) in minutes
NUMBER
10
LONGITUDE_SEC
NUMBER
22
No
No
2
0
Active
Longitude of non fishing day (not time specfic)
NUMBER
11
LONGITUDE_EW
VARCHAR2
1
No
No
Active
East West Longitude indicator for a non fishing day locaton.
VARCHAR2
12
PERMIT
VARCHAR2
6
Yes
Yes
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
NPRB_1017.ATL_CRUISE_PLANT
13
CRUISE_PLANT_SEQ
NUMBER
22
No
No
9
0
Active
NUMBER
NPRB_1017.ATL_CRUISE_PLANT
gov.noaa.nmfs.inport:19041
Doug Turnbull
2013-05-03T17:18:48
SysAdmin InPortAdmin
2022-08-09T17:11:09
2016-05-18
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18