Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: ATL_OBSERVER_CRUISE
Short Name: ATL_OBSERVER_CRUISE
Status: Completed
Abstract:

Records within Atlas, the essentials of an observer contract. Observer contract, deployment, and contractor details are contained within the logistics subsystem.

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:

Records within Atlas the essentials of an observer contract.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
FIRST_NAME VARCHAR2 Observer First Name
100
LAST_NAME VARCHAR2 Observer Last Name
100
CREATE_DATE DATE Timestamp that record was created

Attribute Details

CRUISE

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

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

General Data Type: NUMBER

FIRST_NAME

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

Observer First Name

General Data Type: VARCHAR2

LAST_NAME

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

Observer Last Name

General Data Type: VARCHAR2

CREATE_DATE

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

Timestamp that record was created

General Data Type: DATE

Catalog Details

Catalog Item ID: 9738
GUID: gov.noaa.nmfs.inport:9738
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