Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Resource Ecology and Fisheries Management Divis... > Fish Abundance Surveys > AFSC/REFM: Inshore research surveys in the east... >

tblSpecimen

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:29764  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

NA

Description

NA

Entity Information

Data Attribute / Type Description
SpecimenID
NUMBER 		Primary key; autonumber
SpecCode
Unknown 		Corresponds to the primary key in lovSpecType
SpecNo
NUMBER 		Specimen number that corresponds to fish from which multiple samples may have been collected (e.g. stomachs, otoliths etc.)
LengthID
NUMBER 		LengthID correponds to the primary key in the tblLength
IndWeight
NUMBER 		Individual specimen weight in grams
Sex
Unknown 		Male, female or unknown
SpecCom
Unknown 		Specimen comments

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: tblSpecimen
Short Name: tblSpecimen
Status: Completed
Abstract:

NA
Notes:

Loaded by FGDC Metadata Uploader, batch 7848, 12-14-2015 14:31

Entity Information

Description:

NA

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SpecimenID NUMBER Primary key; autonumber
100
 SpecCode Unknown Corresponds to the primary key in lovSpecType
100
 SpecNo NUMBER Specimen number that corresponds to fish from which multiple samples may have been collected (e.g. stomachs, otoliths etc.)
100
 LengthID NUMBER LengthID correponds to the primary key in the tblLength
100
 IndWeight NUMBER Individual specimen weight in grams
100
 Sex Unknown Male, female or unknown
100
 SpecCom Unknown Specimen comments

Attribute Details

SpecimenID

CC ID: 263560
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Primary key; autonumber
Allowed Values: 1 - 130

SpecCode

CC ID: 263561
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Corresponds to the primary key in lovSpecType
Allowed Values: unknown

SpecNo

CC ID: 263562
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Specimen number that corresponds to fish from which multiple samples may have been collected (e.g. stomachs, otoliths etc.)
Allowed Values: 1 - 10

LengthID

CC ID: 263563
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

LengthID correponds to the primary key in the tblLength
Allowed Values: 1079 - 2242

IndWeight

CC ID: 263564
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Individual specimen weight in grams
Allowed Values: 0 - 12000

Sex

CC ID: 263565
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Male, female or unknown
Allowed Values: unknown

SpecCom

CC ID: 263566
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Specimen comments
Allowed Values: unknown

Catalog Details

Catalog Item ID: 29764
GUID: gov.noaa.nmfs.inport:29764
Metadata Record Created By: Angie Greig
Metadata Record Created: 2015-12-14 14:31+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-05
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-05