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

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:7383  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
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
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
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
CONDITION_CODE
NUMBER 		Numeric code identifying the injury
SAMPLE_SYSTEM_CODE
NUMBER 		Unique numeric identifier of a sample coding system.
ANIMAL_TYPE_CODE
VARCHAR2 		Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type.
SPECIES_CODE
NUMBER 		In the case of a length record which is not a child of species composition. This is the species identifier attribute.
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 valid values are Excellent, Poor, Dead, Unknown.

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

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

Loaded by batch 2164, 03-27-2008 10:42

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:

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 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
 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
 CONDITION_CODE NUMBER Numeric code identifying the injury
100
 SAMPLE_SYSTEM_CODE NUMBER Unique numeric identifier of a sample coding system.
100
 ANIMAL_TYPE_CODE VARCHAR2 Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type.
100
 SPECIES_CODE NUMBER In the case of a length record which is not a child of species composition. This is the species identifier attribute.
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 valid values are Excellent, Poor, Dead, Unknown.

Attribute Details

CRUISE

CC ID: 28775
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
Foreign Key Relations:

Refers to more than one entity

LENGTH_SEQ

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

SPECIES_COMPOSITION_SEQ

CC ID: 28785
Seq. Order: 3
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
Foreign Key Relations:

NORPAC.ATL_SPECIES_COMPOSITION

HAUL_SEQ

CC ID: 28778
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 for a haul record
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_HAUL

OFFLOAD_SEQ

CC ID: 28781
Seq. Order: 5
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
Foreign Key Relations:

NORPAC.ATL_OFFLOAD

CONDITION_CODE

CC ID: 28773
Seq. Order: 6
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
Foreign Key Relations:

NORPAC.ATL_LOV_CONDITION

SAMPLE_SYSTEM_CODE

CC ID: 28782
Seq. Order: 7
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
Foreign Key Relations:

NORPAC.ATL_LOV_SAMPLE_SYSTEM_C

ANIMAL_TYPE_CODE

CC ID: 28772
Seq. Order: 8
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
Foreign Key Relations:

NORPAC.ATL_LOV_CONDITION

SPECIES_CODE

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

In the case of a length record which is not a child of species composition. This is the species identifier attribute.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_SPECIES_CODE

SEX_CODE

CC ID: 28783
Seq. Order: 10
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: 28780
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

The length of this animal
General Data Type: NUMBER

FREQUENCY

CC ID: 28777
Seq. Order: 12
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: 28776
Seq. Order: 13
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: 28786
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Identifies the viability status for halibut valid values are Excellent, Poor, Dead, Unknown.
General Data Type: VARCHAR2

Catalog Details

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