Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Electronic Reporting System (NERS) >

Table: SF_BIOSAMP_BIOSAMPLE_AGE

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