Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > FISHERIES ASSESSMENT,TECH & ENG SPT DIV > Biology & Life History Branch > Life History Database Beaufort > Southeast Region Finfish Age Database >

bft_observation_sample

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

Summary

Abstract

Data in this table include the steps from processing the age structure and assigning a physical location of the processed structure to a recording of the age reading. The age readings have three parts - the increment , or annuli, count, a description of the margin of the age structure following the last annulus formed, and a quality code for the sample. These data are recorded by fish ageing experts in the laboratory .

Description

Data in this table include the steps from processing the age structure and assigning a physical location of the processed structure to a recording of the age reading. The age readings have three parts - the increment , or annuli, count, a description of the margin of the age structure following the last annulus formed, and a quality code for the sample. These data are recorded by fish ageing experts in the laboratory .

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
INTERVIEW_ID
Character 		Tip Online interview id or Headboat (BioProfile) Collection Numer or NCDMF Control1 number, or FWRI Fish Collection Number or special collection ID.
TAG_Numeric
Character 		Tip Online tag Numeric or Headboat (sample) id, or NCDMF replicate&line number, or FWRI Auxilery Number. Note: Samples 1-9 have leading 0 in BFT Inventory that do not occur in TIP or BP databases
ITIS
Character 		Fish codes from www.itis.gov used in Tip
DRAWER_NO
Character 		Location of sample slide if no longer in a box. Generally no longer used.
DRAWER_ROW
Character 		Location of sample slide if no longer in a box. Generally no longer used.
SLIDE_BOX_NO
Character 		Box Number the slide is in
SLIDE_NO
Numeric 		slide Number in the box
POSITION
Character 		if more than one sample per slide this is a code for the location of the sample on the slide.
SAMPLE_TYPE_ID
Character 		Tip sample type codes for otoliths, scales, and spines
PAIRED
Character 		Is there a pair of otoliths in the sample envelope?
PROCESSED
Character 		Has the sample been sectioned?
PROCESSED_DATE
Date 		Date sample was processed
Age_Method
Numeric 		Describes Method used in ageing process
Lab
Character 		LAB Lab that aged the sample. Default Beaufort, some state agencies have aged specific species.
AGE_ASSIGNED_BY
Character 		Agency that assigned the age
DATE_AGED
Date 		Date sample was aged
1st_COUNT
Numeric 		Numeric of annuli counted on the sample
1st_MARGIN_TYPE
Character 		Amount of growth from the outer most annulus to the edge of the sample (1 through 4)
1st_READABILITY
Character 		Code to indicate Ease of determining ring count
1st_READER
Character 		Person who aged the sample
1st_CALENDAR_AGE
Numeric 		Age of fish based on ring count, margin type, and month of year.
2nd_COUNT
Numeric 		Number of annuli counted on the sample for a second time. Can be same or different reader. Typically used for comparission with first reading
2nd_MARGIN TYPE
Numeric 		Amount of growth from the outer most annulus to the edge of the sample (1 through 4)
2nd_READABILITY
Character 		Code to indicate Ease of determining 2nd ring count
2nd_Reader
Character 		Person who aged the sample
2nd_CALENDAR_AGE
Numeric 		Age of fish based on 2nd ring count, margin type, and month of year.
SECTION
Character 		Will or has the sample been sectioned?
RADIUS
Numeric 		Distance from the core to the edge of the sample. Column potenially to be eliminated and data moved to radial measures table.
CORE_TO_1ST_ANNULUS
Numeric 		Distance from the core to the first annulus of the sample. Column potenially to be eliminated and data moved to radial measures table.
UNIT
Character 		Distance units used in measurements.
MAGNIFICATION
Character 		Microscope Magnification
Image
Character 		Photo location
COMMENTS
Character 		Notes
CREATED_BY_USER_ID
Character 		Person who created the record in the BFT Inventory
CREATED_DATE
Date 		Date the record was created in the BFT Inventory
MODIFIED_BY_USER_ID
Character 		Person who modified the record in the BFT Inventory
OBSERVATION_ID
Numeric 		id from BFT_Observation table. DOES NOT CORRESPOND TO TIP ONLINE OBSERVATION ID.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: bft_observation_sample
Status: In Work
Abstract:

Data in this table include the steps from processing the age structure and assigning a physical location of the processed structure to a recording of the age reading. The age readings have three parts - the increment , or annuli, count, a description of the margin of the age structure following the last annulus formed, and a quality code for the sample. These data are recorded by fish ageing experts in the laboratory .

Entity Information

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

Data in this table include the steps from processing the age structure and assigning a physical location of the processed structure to a recording of the age reading. The age readings have three parts - the increment , or annuli, count, a description of the margin of the age structure following the last annulus formed, and a quality code for the sample. These data are recorded by fish ageing experts in the laboratory .

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 INTERVIEW_ID Character Tip Online interview id or Headboat (BioProfile) Collection Numer or NCDMF Control1 number, or FWRI Fish Collection Number or special collection ID.
100
 TAG_Numeric Character Tip Online tag Numeric or Headboat (sample) id, or NCDMF replicate&line number, or FWRI Auxilery Number. Note: Samples 1-9 have leading 0 in BFT Inventory that do not occur in TIP or BP databases
100
 ITIS Character Fish codes from www.itis.gov used in Tip
100
 DRAWER_NO Character Location of sample slide if no longer in a box. Generally no longer used.
100
 DRAWER_ROW Character Location of sample slide if no longer in a box. Generally no longer used.
100
 SLIDE_BOX_NO Character Box Number the slide is in
100
 SLIDE_NO Numeric slide Number in the box
100
 POSITION Character if more than one sample per slide this is a code for the location of the sample on the slide.
100
 SAMPLE_TYPE_ID Character Tip sample type codes for otoliths, scales, and spines
100
 PAIRED Character Is there a pair of otoliths in the sample envelope?
100
 PROCESSED Character Has the sample been sectioned?
100
 PROCESSED_DATE Date Date sample was processed
100
 Age_Method Numeric Describes Method used in ageing process
100
 Lab Character LAB Lab that aged the sample. Default Beaufort, some state agencies have aged specific species.
100
 AGE_ASSIGNED_BY Character Agency that assigned the age
100
 DATE_AGED Date Date sample was aged
100
 1st_COUNT Numeric Numeric of annuli counted on the sample
100
 1st_MARGIN_TYPE Character Amount of growth from the outer most annulus to the edge of the sample (1 through 4)
100
 1st_READABILITY Character Code to indicate Ease of determining ring count
100
 1st_READER Character Person who aged the sample
100
 1st_CALENDAR_AGE Numeric Age of fish based on ring count, margin type, and month of year.
100
 2nd_COUNT Numeric Number of annuli counted on the sample for a second time. Can be same or different reader. Typically used for comparission with first reading
100
 2nd_MARGIN TYPE Numeric Amount of growth from the outer most annulus to the edge of the sample (1 through 4)
100
 2nd_READABILITY Character Code to indicate Ease of determining 2nd ring count
100
 2nd_Reader Character Person who aged the sample
100
 2nd_CALENDAR_AGE Numeric Age of fish based on 2nd ring count, margin type, and month of year.
100
 SECTION Character Will or has the sample been sectioned?
100
 RADIUS Numeric Distance from the core to the edge of the sample. Column potenially to be eliminated and data moved to radial measures table.
100
 CORE_TO_1ST_ANNULUS Numeric Distance from the core to the first annulus of the sample. Column potenially to be eliminated and data moved to radial measures table.
100
 UNIT Character Distance units used in measurements.
100
 MAGNIFICATION Character Microscope Magnification
100
 Image Character Photo location
100
 COMMENTS Character Notes
100
 CREATED_BY_USER_ID Character Person who created the record in the BFT Inventory
100
 CREATED_DATE Date Date the record was created in the BFT Inventory
100
 MODIFIED_BY_USER_ID Character Person who modified the record in the BFT Inventory
100
 OBSERVATION_ID Numeric id from BFT_Observation table. DOES NOT CORRESPOND TO TIP ONLINE OBSERVATION ID.

Attribute Details

INTERVIEW_ID

CC ID: 345631
Data Storage Type: Character
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

Tip Online interview id or Headboat (BioProfile) Collection Numer or NCDMF Control1 number, or FWRI Fish Collection Number or special collection ID.

TAG_Numeric

CC ID: 345632
Data Storage Type: Character
Max Length: 11
Required: Yes
Primary Key: No
Status: Active
Description:

Tip Online tag Numeric or Headboat (sample) id, or NCDMF replicate&line number, or FWRI Auxilery Number. Note: Samples 1-9 have leading 0 in BFT Inventory that do not occur in TIP or BP databases

ITIS

CC ID: 345633
Data Storage Type: Character
Required: Yes
Primary Key: No
Status: Active
Description:

Fish codes from www.itis.gov used in Tip

DRAWER_NO

CC ID: 345634
Data Storage Type: Character
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Location of sample slide if no longer in a box. Generally no longer used.

DRAWER_ROW

CC ID: 345635
Data Storage Type: Character
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Location of sample slide if no longer in a box. Generally no longer used.

SLIDE_BOX_NO

CC ID: 345636
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Box Number the slide is in

SLIDE_NO

CC ID: 345637
Data Storage Type: Numeric
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

slide Number in the box
Validation Rules:

a Numeric between 1-100

POSITION

CC ID: 345638
Data Storage Type: Character
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

if more than one sample per slide this is a code for the location of the sample on the slide.

Allowed Values: L =left, M=middle, R=right

SAMPLE_TYPE_ID

CC ID: 345639
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Tip sample type codes for otoliths, scales, and spines

PAIRED

CC ID: 345640
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Is there a pair of otoliths in the sample envelope?

PROCESSED

CC ID: 345641
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Has the sample been sectioned?

PROCESSED_DATE

CC ID: 345642
Data Storage Type: Date
Required: No
Primary Key: No
Status: Active
Description:

Date sample was processed

Age_Method

CC ID: 345643
Data Storage Type: Numeric
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Describes Method used in ageing process
Allowed Values: 1= Ring count 2 = Radial measure

Lab

CC ID: 345644
Data Storage Type: Character
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

LAB Lab that aged the sample. Default Beaufort, some state agencies have aged specific species.

AGE_ASSIGNED_BY

CC ID: 345645
Data Storage Type: Character
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Agency that assigned the age

DATE_AGED

CC ID: 345646
Data Storage Type: Date
Required: No
Primary Key: No
Status: Active
Description:

Date sample was aged

1st_COUNT

CC ID: 345647
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Numeric of annuli counted on the sample

1st_MARGIN_TYPE

CC ID: 345648
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Amount of growth from the outer most annulus to the edge of the sample (1 through 4)

1st_READABILITY

CC ID: 345649
Data Storage Type: Character
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate Ease of determining ring count

Allowed Values: A,B,C,D,E

1st_READER

CC ID: 345650
Data Storage Type: Character
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Person who aged the sample

1st_CALENDAR_AGE

CC ID: 345651
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Age of fish based on ring count, margin type, and month of year.

2nd_COUNT

CC ID: 345652
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Number of annuli counted on the sample for a second time. Can be same or different reader. Typically used for comparission with first reading

2nd_MARGIN TYPE

CC ID: 345653
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Amount of growth from the outer most annulus to the edge of the sample (1 through 4)

2nd_READABILITY

CC ID: 345654
Data Storage Type: Character
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate Ease of determining 2nd ring count

Allowed Values: A,B,C,D,E

2nd_Reader

CC ID: 345655
Data Storage Type: Character
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Person who aged the sample

2nd_CALENDAR_AGE

CC ID: 345656
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Age of fish based on 2nd ring count, margin type, and month of year.

SECTION

CC ID: 345657
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Will or has the sample been sectioned?

RADIUS

CC ID: 345658
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Distance from the core to the edge of the sample. Column potenially to be eliminated and data moved to radial measures table.

CORE_TO_1ST_ANNULUS

CC ID: 345659
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Distance from the core to the first annulus of the sample. Column potenially to be eliminated and data moved to radial measures table.

UNIT

CC ID: 345660
Data Storage Type: Character
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Distance units used in measurements.

MAGNIFICATION

CC ID: 345661
Data Storage Type: Character
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Microscope Magnification

Image

CC ID: 345662
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Photo location

COMMENTS

CC ID: 345663
Data Storage Type: Character
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Notes

CREATED_BY_USER_ID

CC ID: 345664
Data Storage Type: Character
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Person who created the record in the BFT Inventory

CREATED_DATE

CC ID: 345665
Data Storage Type: Date
Required: No
Primary Key: No
Status: Active
Description:

Date the record was created in the BFT Inventory

MODIFIED_BY_USER_ID

CC ID: 345666
Data Storage Type: Character
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Person who modified the record in the BFT Inventory

OBSERVATION_ID

CC ID: 345675
Data Storage Type: Numeric
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

id from BFT_Observation table. DOES NOT CORRESPOND TO TIP ONLINE OBSERVATION ID.

Catalog Details

Catalog Item ID: 34433
GUID: gov.noaa.nmfs.inport:34433
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2016-08-24 19:40+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-06-03
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-06-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-06-03