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/Observer Logistics System (OLS) >

Table: OLS_OBSERVER_CRUISE

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

Summary

Abstract

This entity represents the intersection of the catch account and logistics subsystems. While an observer contract usually contains a singe cruise, some unique instances prevent this from being a subtype of OLS_Observer_Contract.

Description

This entity represents the intersection of the catch account and logistics subsystems. While an observer contract usually contains a singe cruise, some unique instances prevent this from being a subtype of OLS_Observer_Contract.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE
NUMBER 		Sequence generated cruise number.
CONTRACT_NUMBER
NUMBER 		Unique identifier of a contract between an observer provider and an observer.
DEPLOYMENT_DATE
DATE 		Date of initial deployment of the Observer to the field.
DATE_OF_ENTRY
DATE 		Time stamp of record creation

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

This entity represents the intersection of the catch account and logistics subsystems. While an observer contract usually contains a singe cruise, some unique instances prevent this from being a subtype of OLS_Observer_Contract.
Notes:

Loaded by batch 3083, 04-19-2012 13:25

Entity Information

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

This entity represents the intersection of the catch account and logistics subsystems. While an observer contract usually contains a singe cruise, some unique instances prevent this from being a subtype of OLS_Observer_Contract.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key CRUISE NUMBER Sequence generated cruise number.
100
 CONTRACT_NUMBER NUMBER Unique identifier of a contract between an observer provider and an observer.
100
 DEPLOYMENT_DATE DATE Date of initial deployment of the Observer to the field.
100
 DATE_OF_ENTRY DATE Time stamp of record creation

Attribute Details

CRUISE

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

Sequence generated cruise number.
General Data Type: NUMBER

CONTRACT_NUMBER

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

Unique identifier of a contract between an observer provider and an observer.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_OBSERVER_CONTRACT

DEPLOYMENT_DATE

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

Date of initial deployment of the Observer to the field.
General Data Type: DATE

DATE_OF_ENTRY

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

Time stamp of record creation
General Data Type: DATE

Catalog Details

Catalog Item ID: 12313
GUID: gov.noaa.nmfs.inport:12313
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-04-19 13:25+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