Slide Menu
Search Help Show/Hide Menu

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