tblSpecimen
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:29764 | Updated: August 9, 2022 | Published / External
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
|
|
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 |