Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Special Projects > Alternative catch monitoring of Alaskan groundf... > AFSC/FMA/NPRB Alternative Catch Monitoring Tabl... >

Table: ATL_FISH_INV_SPECIMEN

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:18982 | Updated: August 9, 2022 | Published / External

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

	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

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

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