Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Foreign Fishing Observer Data Dictionary > AFSC/FMA/North Pacific Observer Foreign Fishing >

Table: FOREIGN_OBSERVER

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

Summary

Abstract

This table provides the observer name and contractor code associated with each cruise and vessel.

Description

This table provides the observer name and contractor code associated with each cruise and vessel.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE
NUMBER 		A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
VESSEL
VARCHAR2 		A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
CONTRACTOR
VARCHAR2 		Abbreviation of the name of the organization that provided the observer. The NORPAC.FOREIGN_CONTRACTOR table contains a description of each abbreviation.
LAST_NAME
VARCHAR2 		Last name of the observer who collected the sample data.
FIRST_NAME
VARCHAR2 		First name of the observer who collected the sample data.
MIDDLE_NAME
VARCHAR2 		Middle name of the observer who collected the sample data.
DOMESTIC_OBSERVER_LINK
NUMBER 		For internal use only (is currently null).

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

This table provides the observer name and contractor code associated with each cruise and vessel.
Notes:

Loaded by batch 2364, 06-29-2009 18:15

Entity Information

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

This table provides the observer name and contractor code associated with each cruise and vessel.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key CRUISE NUMBER A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
100
 Primary Key VESSEL VARCHAR2 A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
100
 CONTRACTOR VARCHAR2 Abbreviation of the name of the organization that provided the observer. The NORPAC.FOREIGN_CONTRACTOR table contains a description of each abbreviation.
100
 Primary Key LAST_NAME VARCHAR2 Last name of the observer who collected the sample data.
100
 Primary Key FIRST_NAME VARCHAR2 First name of the observer who collected the sample data.
100
 MIDDLE_NAME VARCHAR2 Middle name of the observer who collected the sample data.
100
 DOMESTIC_OBSERVER_LINK NUMBER For internal use only (is currently null).

Attribute Details

CRUISE

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

A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_FISHING_OPERATI

VESSEL

CC ID: 37348
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
General Data Type: VARCHAR2
Foreign Key Relations:

Refers to more than one entity

CONTRACTOR

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

Abbreviation of the name of the organization that provided the observer. The NORPAC.FOREIGN_CONTRACTOR table contains a description of each abbreviation.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.FOREIGN_CONTRACTOR

LAST_NAME

CC ID: 37346
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: Yes
Status: Active
Description:

Last name of the observer who collected the sample data.
General Data Type: VARCHAR2

FIRST_NAME

CC ID: 37345
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: Yes
Status: Active
Description:

First name of the observer who collected the sample data.
General Data Type: VARCHAR2

MIDDLE_NAME

CC ID: 37347
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Middle name of the observer who collected the sample data.
General Data Type: VARCHAR2

DOMESTIC_OBSERVER_LINK

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

For internal use only (is currently null).
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 9579
GUID: gov.noaa.nmfs.inport:9579
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-29 18:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18