Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: ENERGETICS
Short Name: ENERGETICS
Status: Completed
Abstract:

Wet- and dry-weight data for various tissue subsamples obtained from a specimen

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Wet- and dry-weight data for various tissue subsamples obtained from a specimen

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
FISH_ID_CODE VARCHAR2 Unique code for each sampled fish.
100
SAMPLE_DRY_WEIGHT NUMBER Tissue subsample dry-weight (g) obtained after drying in a 60 degree Celsius oven for a minimum of 48 hrs.
100
PROXIMATE_COMP_SAMPLE_SENT_OUT CHAR Binary (Y/N) flag indicating if a tissue subsample was sent out for further processing for proximate composition estimation
100
Primary Key PAN_NUMBER VARCHAR2 Individual identifier for each pan. Pans are weighed before use in sets of 100. Each set has a series code (letter or numeric) with a dash followed by a number (1-100).
100
TISSUE_TYPE VARCHAR2 Tissue type in the subsample taken from a specimen
100
SAMPLE_WET_WEIGHT NUMBER Tissue subsample wet-weight (g)
100
COMMENTS VARCHAR2 Comment field for the tissue subsample

Attribute Details

FISH_ID_CODE

CC ID: 362159
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Unique code for each sampled fish.

General Data Type: VARCHAR2
Foreign Key Relations:

FISH_ORGANISM.FISH_ID_CODE

SAMPLE_DRY_WEIGHT

CC ID: 362160
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 3
Status: Active
Description:

Tissue subsample dry-weight (g) obtained after drying in a 60 degree Celsius oven for a minimum of 48 hrs.

General Data Type: NUMBER

PROXIMATE_COMP_SAMPLE_SENT_OUT

CC ID: 362161
Seq. Order: 3
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Binary (Y/N) flag indicating if a tissue subsample was sent out for further processing for proximate composition estimation

General Data Type: CHAR

PAN_NUMBER

CC ID: 362162
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 8
Required: Yes
Primary Key: Yes
Status: Active
Description:

Individual identifier for each pan. Pans are weighed before use in sets of 100. Each set has a series code (letter or numeric) with a dash followed by a number (1-100).

General Data Type: VARCHAR2
Foreign Key Relations:

PAN.PAN_NUMBER

TISSUE_TYPE

CC ID: 362163
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Tissue type in the subsample taken from a specimen

General Data Type: VARCHAR2

SAMPLE_WET_WEIGHT

CC ID: 362164
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 3
Status: Active
Description:

Tissue subsample wet-weight (g)

General Data Type: NUMBER

COMMENTS

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

Comment field for the tissue subsample

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 35889
GUID: gov.noaa.nmfs.inport:35889
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-07 13:27+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-12
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-12