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: ATLW_OBSERVER_CRUISE

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

Summary

Abstract

Records the essentials of an observer contract.

Purpose

Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data.

Description

Records within Atlas the essentials of an observer contract.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
RECORD_SET_STATUS_SEQ
NUMBER 		Sequence generated unique identifier of a record set header
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
FIRST_NAME
VARCHAR2 		Observer First Name
LAST_NAME
VARCHAR2 		Observer Last Name
CREATE_DATE
DATE 		Timestamp that record was created
PASSWORD
RAW 		Password entered by the lead observer for use by all observers on a cruise.

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

Records the essentials of an observer contract.
Purpose:

Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data.
Notes:

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

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
 RECORD_SET_STATUS_SEQ NUMBER Sequence generated unique identifier of a record set header
100
 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
100
 PASSWORD RAW Password entered by the lead observer for use by all observers on a cruise.

Attribute Details

RECORD_SET_STATUS_SEQ

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

Sequence generated unique identifier of a record set header
General Data Type: NUMBER

CRUISE

CC ID: 37804
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
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: 37805
Seq. Order: 3
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: 37806
Seq. Order: 4
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: 37803
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Timestamp that record was created
General Data Type: DATE

PASSWORD

CC ID: 37807
Seq. Order: 6
Data Storage Type: RAW
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Password entered by the lead observer for use by all observers on a cruise.
General Data Type: RAW

Catalog Details

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