Table: ATL_FISH_INV_SPECIMEN
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9668 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals.
DescriptionThis 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 2390, 06-30-2009 16:11 |
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 represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
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
|
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
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: |
NORPAC.ATL_LENGTH |
SPECIMEN_SEQ
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
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: |
NORPAC.ATL_LOV_SPECIES_MATURIT |
MATURITY_SEQ
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: |
NORPAC.ATL_LOV_SPECIES_MATURIT |
LENGTH_SEQ
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: |
NORPAC.ATL_LENGTH |
SPECIMEN_TYPE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Unique numeric value for a specimen type record. |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.ATL_LOV_SPECIMEN_TYPE |
SPECIMEN_NUMBER
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
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
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
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
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: |
NORPAC.ATL_LENGTH |
Catalog Details
Catalog Item ID: | 9668 |
---|---|
GUID: | gov.noaa.nmfs.inport:9668 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2009-06-30 16:11+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 |