9737
Table: ATL_NON_FISHING_DAY_H
ATL_NON_FISHING_DAY_H
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
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.
Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events.
Loaded by batch 2390, 06-30-2009 16:11
Data Table
Yes
NORPAC
This entity represents the date and location of every day during a trip where fishing did not occur. For 2009, this concept was expanded to days with no observer activity at a processing plant. To implement this change all non PK fields sans date became optional.
1
SEQ_NUMBER
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.
NUMBER
2
CHANGED_BY
VARCHAR2
30
No
No
Active
Oracle user who made a change to the transaction table record.
VARCHAR2
3
DATE_CHANGED
DATE
7
No
No
Active
Timestamp of change to transaction record.
DATE
4
CRUISE
NUMBER
22
No
No
22
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
5
NO_FISHING_DAY_SEQ
NUMBER
22
No
No
22
0
Active
Sequence generated unique identifier of a non-fishing day record
NUMBER
6
CRUISE_VESSEL_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier for a cruise vessel.
NUMBER
7
NONFISH_DATE
DATE
7
No
No
Active
Date on which no fishing activity occurred
DATE
8
LATITUDE_DEGREES
NUMBER
22
No
No
22
0
Active
Latitude of non fishing day (not time specific) in degrees.
NUMBER
9
LATITUDE_MINUTES
NUMBER
22
No
No
22
0
Active
Latitude of non fishing day (not time specific) in minutes.
NUMBER
10
LATITUDE_SEC
NUMBER
22
No
No
22
0
Active
Latitude of non fishing day (not time specific) in seconds.
NUMBER
11
LONGITUDE_DEGREES
NUMBER
22
No
No
22
0
Active
Longitude of non fishing day (not time specific) in degrees.
NUMBER
12
LONGITUDE_MINUTES
NUMBER
22
No
No
22
0
Active
Longitude of non fishing day (not time specific) in minutes.
NUMBER
13
LONGITUDE_SEC
NUMBER
22
No
No
22
0
Active
Longitude of non fishing day (not time specific) in seconds.
NUMBER
14
LONGITUDE_EW
VARCHAR2
1
No
No
Active
East West longitude indicator for a non fishing day location.
VARCHAR2
15
CRUISE_PLANT_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier for a processor.
NUMBER
16
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
gov.noaa.nmfs.inport:9737
Doug Turnbull
2009-06-30T16:11:42
SysAdmin InPortAdmin
2022-08-09T17:11:03
2018-09-26
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
2018-09-26
1 Year
2019-09-26