Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Atlas Remote Client > AFSC/FMA/ATLAS Remote Client >

Table: LENGTH

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:7512  |  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
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 		In the case of a length record which is not a child of species composition. This is the species identifier attribute.
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

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

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

Loaded by batch 2204, 03-28-2008 14:09

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TURNBULLD
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 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 In the case of a length record which is not a child of species composition. This is the species identifier attribute.
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

Attribute Details

LENGTH_SEQ

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

CONDITION_CODE

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

TURNBULLD.LOV_CONDITION

ANIMAL_TYPE_CODE

CC ID: 29636
Seq. Order: 3
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:

TURNBULLD.LOV_CONDITION

SAMPLE_SYSTEM_CODE

CC ID: 29644
Seq. Order: 4
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:

TURNBULLD.LOV_SAMPLE_SYSTEM_CO

SPECIES_CODE

CC ID: 29646
Seq. Order: 5
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:

TURNBULLD.LOV_SPECIES_CODE

SPECIES_COMPOSITION_SEQ

CC ID: 29647
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 of a species composition record
General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.SPECIES_COMPOSITION

HAUL_SEQ

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

TURNBULLD.HAUL

OFFLOAD_SEQ

CC ID: 29643
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 for an offload record
General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.OFFLOAD

SEX_CODE

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

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

EGGS_IND

CC ID: 29638
Seq. Order: 12
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: 29648
Seq. Order: 13
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

Catalog Details

Catalog Item ID: 7512
GUID: gov.noaa.nmfs.inport:7512
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-28 14:09+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-04