Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: CRUISES

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

Summary

Abstract

The cruises table is at the intersection of the ATL and Domestic data sets. As the redevelopment of the NORPAC system extends into observer logistics this object may change in name and structure.

Purpose

This is a table that joins the cruise number with the observer and the observer contract ID.

Description

This is a table that joins the cruise number with the observer and the observer contract ID.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE
NUMBER 		A unique five-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
DATE_OF_ENTRY
DATE 		The date in which this entry was made.
SEABIRDS
VARCHAR2 		During debriefing a record is entered in this table if an observer has seabird notes in their logbook. If an observer has seabird notes in their logbook the debriefer makes a photocopy of these notes and gives the photocopy to one particular staff membe
OBSERVER_JOIN
NUMBER 		A unique number that identifies a specific observer.
OBSERVER_CONTRACT_ID
NUMBER 		This is a number associated with an observer's specific 90-day contract.
DEPLOYMENT_DATE
DATE 		This is the date in which the observer was deployed on their first vessel or plant for this contract.

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: CRUISES
Short Name: CRUISES
Status: Completed
Abstract:

The cruises table is at the intersection of the ATL and Domestic data sets. As the redevelopment of the NORPAC system extends into observer logistics this object may change in name and structure.
Purpose:

This is a table that joins the cruise number with the observer and the observer contract ID.
Notes:

Loaded by batch 2390, 06-30-2009 16:11

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None AFSC
None ATL
None ATLAS
None BYCATCH
None FMA
None GROUNDFISH
None NORPAC
None OBSERVER

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None AI
None ALEUTIAN ISLANDS
None BERING SEA
None BS
None BSAI
None GOA
None GULF OF ALASKA

Entity Information

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

This is a table that joins the cruise number with the observer and the observer contract ID.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key CRUISE NUMBER A unique five-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
 DATE_OF_ENTRY DATE The date in which this entry was made.
100
 SEABIRDS VARCHAR2 During debriefing a record is entered in this table if an observer has seabird notes in their logbook. If an observer has seabird notes in their logbook the debriefer makes a photocopy of these notes and gives the photocopy to one particular staff membe
100
 OBSERVER_JOIN NUMBER A unique number that identifies a specific observer.
100
 OBSERVER_CONTRACT_ID NUMBER This is a number associated with an observer's specific 90-day contract.
100
 DEPLOYMENT_DATE DATE This is the date in which the observer was deployed on their first vessel or plant for this contract.

Attribute Details

CRUISE

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

A unique five-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type: NUMBER

DATE_OF_ENTRY

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

The date in which this entry was made.
General Data Type: DATE

SEABIRDS

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

During debriefing a record is entered in this table if an observer has seabird notes in their logbook. If an observer has seabird notes in their logbook the debriefer makes a photocopy of these notes and gives the photocopy to one particular staff membe
General Data Type: VARCHAR2

OBSERVER_JOIN

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

A unique number that identifies a specific observer.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OBSERVERS

OBSERVER_CONTRACT_ID

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

This is a number associated with an observer's specific 90-day contract.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OBSERVER_CONTRACTS

DEPLOYMENT_DATE

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

This is the date in which the observer was deployed on their first vessel or plant for this contract.
General Data Type: DATE

Catalog Details

Catalog Item ID: 9755
GUID: gov.noaa.nmfs.inport:9755
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-30 16:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26