Table: LENGTH
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7512 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity is mapped to the Norpac length tables. It contains header information about sampled animals.
DescriptionThis 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |