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_LENGTH

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

Summary

Abstract

This entity is mapped to the Norpac length tables. It contains header information about sampled animals.

Description

This entity is mapped to the Norpac length tables. It contains header information about sampled animals.

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.
LENGTH_SEQ
NUMBER 		Sequence generated unique identifier for a length record
CONDITION_CODE
NUMBER 		Numeric code identifying the injury
ANIMAL_TYPE_CODE
VARCHAR2 		Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type.
SAMPLE_SYSTEM_CODE
NUMBER 		Unique numeric identifier of a sample coding system.
SPECIES_CODE
NUMBER 		Unique identifier for a species imported from Norpac
SPECIES_COMPOSITION_SEQ
NUMBER 		Sequence Generated unique identifier of a species composition record
HAUL_SEQ
NUMBER 		Sequence generated unique identifier for a haul record
OFFLOAD_SEQ
NUMBER 		Sequence generated unique identifier for an offload record
SEX_CODE
VARCHAR2 		The sex of this animal
LENGTH_SIZE
NUMBER 		The length of this animal
FREQUENCY
NUMBER 		The total number of animals within this size group
EGGS_IND
VARCHAR2 		Identifies the presence or absence of egg for crabs.
VIABILITY
VARCHAR2 		Identifies the viability status for halibut
PERMIT
VARCHAR2 		Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

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

This entity is mapped to the Norpac length tables. It contains header information about sampled animals.
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:

This entity is mapped to the Norpac length tables. It contains header information about sampled animals.

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 LENGTH_SEQ NUMBER Sequence generated unique identifier for a length record
100
 CONDITION_CODE NUMBER Numeric code identifying the injury
100
 ANIMAL_TYPE_CODE VARCHAR2 Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type.
100
 SAMPLE_SYSTEM_CODE NUMBER Unique numeric identifier of a sample coding system.
100
 SPECIES_CODE NUMBER Unique identifier for a species imported from Norpac
100
 SPECIES_COMPOSITION_SEQ NUMBER Sequence Generated unique identifier of a species composition record
100
 HAUL_SEQ NUMBER Sequence generated unique identifier for a haul record
100
 OFFLOAD_SEQ NUMBER Sequence generated unique identifier for an offload record
100
 SEX_CODE VARCHAR2 The sex of this animal
100
 LENGTH_SIZE NUMBER The length of this animal
100
 FREQUENCY NUMBER The total number of animals within this size group
100
 EGGS_IND VARCHAR2 Identifies the presence or absence of egg for crabs.
100
 VIABILITY VARCHAR2 Identifies the viability status for halibut
100
 Primary Key PERMIT VARCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

Attribute Details

RECORD_SET_STATUS_SEQ

CC ID: 37740
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: 37732
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

LENGTH_SEQ

CC ID: 37736
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 for a length record
General Data Type: NUMBER

CONDITION_CODE

CC ID: 37731
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Numeric code identifying the injury
General Data Type: NUMBER

ANIMAL_TYPE_CODE

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

Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type.
General Data Type: VARCHAR2

SAMPLE_SYSTEM_CODE

CC ID: 37741
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique numeric identifier of a sample coding system.
General Data Type: NUMBER

SPECIES_CODE

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

Unique identifier for a species imported from Norpac
General Data Type: NUMBER

SPECIES_COMPOSITION_SEQ

CC ID: 37744
Seq. Order: 8
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 species composition record
General Data Type: NUMBER

HAUL_SEQ

CC ID: 37735
Seq. Order: 9
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

OFFLOAD_SEQ

CC ID: 37738
Seq. Order: 10
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

SEX_CODE

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

The sex of this animal
General Data Type: VARCHAR2

LENGTH_SIZE

CC ID: 37737
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The length of this animal
General Data Type: NUMBER

FREQUENCY

CC ID: 37734
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The total number of animals within this size group
General Data Type: NUMBER

EGGS_IND

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

Identifies the presence or absence of egg for crabs.
General Data Type: VARCHAR2

VIABILITY

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

Identifies the viability status for halibut
General Data Type: VARCHAR2

PERMIT

CC ID: 37739
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type: VARCHAR2

Catalog Details

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