Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Biosample age data

Description

Biosample age data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AGE_SAMPLE_ID
VARCHAR2
Unique age sample identifier
TRIP_ID
NUMBER
Unique trip identifier generated in FLDRS software
FISH_ID
NUMBER
Unigue fish identifier per trip
READER
VARCHAR2
Staff member who determined age
AGE
NUMBER
Determined age in years
ENTERED_BY
VARCHAR2
Staff member who made the database entry
DATE_ENTERED
DATE
Date data was entered

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: Table: SF_BIOSAMP_BIOSAMPLE_AGE
Short Name: SF_BIOSAMP_BIOSAMPLE_AGE
Status: Completed
Abstract:

Biosample age data

Notes:

Loaded by batch 9249, 09-01-2016 13:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NERS
Description:

Biosample age data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key AGE_SAMPLE_ID VARCHAR2 Unique age sample identifier
100
Primary Key TRIP_ID NUMBER Unique trip identifier generated in FLDRS software
100
FISH_ID NUMBER Unigue fish identifier per trip
100
READER VARCHAR2 Staff member who determined age
100
AGE NUMBER Determined age in years
100
ENTERED_BY VARCHAR2 Staff member who made the database entry
100
DATE_ENTERED DATE Date data was entered

Attribute Details

AGE_SAMPLE_ID

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

Unique age sample identifier

General Data Type: VARCHAR2

TRIP_ID

CC ID: 347907
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 14
Scale: 0
Status: Active
Description:

Unique trip identifier generated in FLDRS software

General Data Type: NUMBER
Foreign Key Relations:

NERS.SF_BIOSAMP_BIOSAMPLE

FISH_ID

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

Unigue fish identifier per trip

General Data Type: NUMBER
Foreign Key Relations:

NERS.SF_BIOSAMP_BIOSAMPLE

READER

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

Staff member who determined age

General Data Type: VARCHAR2

AGE

CC ID: 347911
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Determined age in years

General Data Type: NUMBER

ENTERED_BY

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

Staff member who made the database entry

General Data Type: VARCHAR2

DATE_ENTERED

CC ID: 347913
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date data was entered

General Data Type: DATE

Catalog Details

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