9657
Table: ATL_CRUISE_VESSEL
ATL_CRUISE_VESSEL
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
The intersection of an observer cruise and a vessel
Loaded by batch 2390, 06-30-2009 16:11
Theme
AFSC
Theme
ATL
Theme
ATLAS
Theme
BYCATCH
Theme
FMA
Theme
NORPAC
Theme
OBSERVER
Spatial
AI
Spatial
ALEUTIAN ISLANDS
Spatial
BERING SEA
Spatial
BS
Spatial
BSAI
Spatial
GOA
Spatial
GULF OF ALASKA
Data Table
Yes
NORPAC
The intersection of an observer cruise and a vessel
1
CRUISE_VESSEL_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a cruise vessel.
NUMBER
2
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
NORPAC.ATL_OBSERVER_CRUISE
3
VESSEL_SEQ
NUMBER
22
Yes
No
9
0
Active
Unique Code identifying a vessel - inherited from the NORPAC data set. Generated by logistics staff.
NUMBER
NORPAC.ATL_LOV_VESSEL
4
STATUS
NUMBER
22
Yes
No
2
0
Active
This attribute is the logical foreign key from the CV_Status table owned by Norpac. It represents the current processing phase that a record is in.
NUMBER
NORPAC.CV_STATUS
5
STATUS_DATE
DATE
7
Yes
No
Active
Timestamp of when processing status was assigned
DATE
6
STATUS_USER
VARCHAR2
30
No
No
Active
User who was logged on when the cruise vessel (cruise plant) status was assigned
VARCHAR2
7
COMMENTS
VARCHAR2
2000
No
No
Active
Optional Comments Field for a cruise_vessel data set. This field is provided for use by the debriefing staff. They are not available to observers in the field for this release.
VARCHAR2
8
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
gov.noaa.nmfs.inport:9657
Doug Turnbull
2009-06-30T16:11:20
SysAdmin InPortAdmin
2022-08-09T17:11:02
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