Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

If an observer has more than one cruise in the same contract. Data from the field ought to be loaded for only the active cruise. This table provides the list of cruises for which data is currently static. The table is referenced by the atl_load_norpac.load_atl_tables procedure.

Description

If an observer has more than one cruise in the same contract. Data from the field ought to be loaded for only the active cruise. This table provides the list of cruises for which data is currently static. The table is referenced by the atl_load_norpac.load_atl_tables procedure.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE
NUMBER
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. In this table a listed cruise is held static to automated data loading.
COMMENTS
VARCHAR2
Optional discussion - particularly useful in the case loading data with known errors or when the data for a cruise is frozen for a reason other than multiple cruises in a 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: ATL_DO_NOT_LOAD_CRUISE
Short Name: ATL_DO_NOT_LOAD_CRUISE
Status: Completed
Abstract:

If an observer has more than one cruise in the same contract. Data from the field ought to be loaded for only the active cruise. This table provides the list of cruises for which data is currently static. The table is referenced by the atl_load_norpac.load_atl_tables procedure.

Notes:

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

Entity Information

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

If an observer has more than one cruise in the same contract. Data from the field ought to be loaded for only the active cruise. This table provides the list of cruises for which data is currently static. The table is referenced by the atl_load_norpac.load_atl_tables procedure.

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. In this table a listed cruise is held static to automated data loading.
100
COMMENTS VARCHAR2 Optional discussion - particularly useful in the case loading data with known errors or when the data for a cruise is frozen for a reason other than multiple cruises in a contract.

Attribute Details

CRUISE

CC ID: 38136
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. In this table a listed cruise is held static to automated data loading.

General Data Type: NUMBER

COMMENTS

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

Optional discussion - particularly useful in the case loading data with known errors or when the data for a cruise is frozen for a reason other than multiple cruises in a contract.

General Data Type: VARCHAR2

Catalog Details

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