Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
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_SAMPLE

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

Summary

Abstract

This entity represents the individual samples of a type that may be collected from an observed haul. It does not currently map to any Norpac table, but is header information for species composition.If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample.

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

This entity represents the individual samples of a type that may be collected from an observed haul. It does not currently map to any Norpac table, but is header information for species composition.If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample.

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.
SAMPLE_SEQ
NUMBER 		Sequence generated unique identifier of a sample
PARENT_SAMPLE_SEQ
NUMBER 		Sequence generated unique identifier of a sample
SAMPLE_NUMBER
NUMBER 		Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique.
OFFLOAD_SEQ
NUMBER 		Sequence generated unique identifier for an offload record
HAUL_SEQ
NUMBER 		Sequence generated unique identifier for a haul record
COMBINED_SAMPLE_FLAG
VARCHAR2 		Identifies whether unique samples within a haul have been aggregated together.
PRESORTED_FLAG
VARCHAR2 		The organism did not make into population and was not available for observer species composition sample.
TOTAL_SAMPLE_WEIGHT
NUMBER 		Total weight in kg of this sample.
SAMPLE_HOOKS_POTS
NUMBER 		Number of hooks or pots sampled.

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

This entity represents the individual samples of a type that may be collected from an observed haul. It does not currently map to any Norpac table, but is header information for species composition.If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample.
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 2164, 03-27-2008 10:42

Entity Information

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

This entity represents the individual samples of a type that may be collected from an observed haul. It does not currently map to any Norpac table, but is header information for species composition.If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key RECORD_SET_STATUS_SEQ NUMBER Sequence generated unique identifier of a record set header
100
 Primary Key CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
 Primary Key SAMPLE_SEQ NUMBER Sequence generated unique identifier of a sample
100
 PARENT_SAMPLE_SEQ NUMBER Sequence generated unique identifier of a sample
100
 SAMPLE_NUMBER NUMBER Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique.
100
 OFFLOAD_SEQ NUMBER Sequence generated unique identifier for an offload record
100
 HAUL_SEQ NUMBER Sequence generated unique identifier for a haul record
100
 COMBINED_SAMPLE_FLAG VARCHAR2 Identifies whether unique samples within a haul have been aggregated together.
100
 PRESORTED_FLAG VARCHAR2 The organism did not make into population and was not available for observer species composition sample.
100
 TOTAL_SAMPLE_WEIGHT NUMBER Total weight in kg of this sample.
100
 SAMPLE_HOOKS_POTS NUMBER Number of hooks or pots sampled.

Attribute Details

RECORD_SET_STATUS_SEQ

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

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

CRUISE

CC ID: 28457
Seq. Order: 2
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

SAMPLE_SEQ

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

Sequence generated unique identifier of a sample
General Data Type: NUMBER

PARENT_SAMPLE_SEQ

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

Sequence generated unique identifier of a sample
General Data Type: NUMBER

SAMPLE_NUMBER

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

Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique.
General Data Type: NUMBER

OFFLOAD_SEQ

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

Sequence generated unique identifier for an offload record
General Data Type: NUMBER

HAUL_SEQ

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

Sequence generated unique identifier for a haul record
General Data Type: NUMBER

COMBINED_SAMPLE_FLAG

CC ID: 28456
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Identifies whether unique samples within a haul have been aggregated together.
General Data Type: VARCHAR2

PRESORTED_FLAG

CC ID: 28461
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

The organism did not make into population and was not available for observer species composition sample.
General Data Type: VARCHAR2

TOTAL_SAMPLE_WEIGHT

CC ID: 28466
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Total weight in kg of this sample.
General Data Type: NUMBER

SAMPLE_HOOKS_POTS

CC ID: 28463
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Number of hooks or pots sampled.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7360
GUID: gov.noaa.nmfs.inport:7360
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-27 10:42+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