Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals.

Description

This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of 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.
SPECIMEN_SEQ
NUMBER
Sequence generated unique identifier of a specimen record.
SPECIES_CODE
NUMBER
Unique identifier for a species imported from Norpac, and the FK value from species_maturity.
MATURITY_SEQ
NUMBER
Sequence generated unique identifier of a maturity record.
LENGTH_SEQ
NUMBER
Sequence generated unique identifier for a length record
SPECIMEN_TYPE
NUMBER
Unique numeric value for a specimen type record.
SPECIMEN_NUMBER
VARCHAR2
A specimen number is unique within a length, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial.
WEIGHT
NUMBER
Weight in kg of the specimen.
AGE
NUMBER
Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation.
SPECIAL_PROJECT_CODE
VARCHAR2
Identifier of a special project record. Project to be a three character acronym unique to the project for a cruise. Populated by Debriefing Staff without System Validation.
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: ATL_FISH_INV_SPECIMEN
Short Name: ATL_FISH_INV_SPECIMEN
Status: Completed
Abstract:

This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals.

Notes:

Loaded by batch 4574, 05-03-2013 17:18

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NPRB_1017
Description:

This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of 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 SPECIMEN_SEQ NUMBER Sequence generated unique identifier of a specimen record.
100
SPECIES_CODE NUMBER Unique identifier for a species imported from Norpac, and the FK value from species_maturity.
100
MATURITY_SEQ NUMBER Sequence generated unique identifier of a maturity record.
100
LENGTH_SEQ NUMBER Sequence generated unique identifier for a length record
100
SPECIMEN_TYPE NUMBER Unique numeric value for a specimen type record.
100
SPECIMEN_NUMBER VARCHAR2 A specimen number is unique within a length, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial.
100
WEIGHT NUMBER Weight in kg of the specimen.
100
AGE NUMBER Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation.
100
SPECIAL_PROJECT_CODE VARCHAR2 Identifier of a special project record. Project to be a three character acronym unique to the project for a cruise. Populated by Debriefing Staff without System Validation.
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

CRUISE

CC ID: 111859
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:

NPRB_1017.ATL_LENGTH

SPECIMEN_SEQ

CC ID: 111866
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 of a specimen record.

General Data Type: NUMBER

SPECIES_CODE

CC ID: 111862
Seq. Order: 3
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, and the FK value from species_maturity.

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_LOV_SPECIES_MATU

MATURITY_SEQ

CC ID: 111863
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 of a maturity record.

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_LOV_SPECIES_MATU

LENGTH_SEQ

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

Sequence generated unique identifier for a length record

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_LENGTH

SPECIMEN_TYPE

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

Unique numeric value for a specimen type record.

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_LOV_SPECIMEN_TYP

SPECIMEN_NUMBER

CC ID: 111867
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

A specimen number is unique within a length, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial.

General Data Type: VARCHAR2

WEIGHT

CC ID: 111868
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 3
Status: Active
Description:

Weight in kg of the specimen.

General Data Type: NUMBER

AGE

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

Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation.

General Data Type: NUMBER

SPECIAL_PROJECT_CODE

CC ID: 111865
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Identifier of a special project record. Project to be a three character acronym unique to the project for a cruise. Populated by Debriefing Staff without System Validation.

General Data Type: VARCHAR2

PERMIT

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

NPRB_1017.ATL_LENGTH

Catalog Details

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