Metadata Rubric

100%

6 / 6

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

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

	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.

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