Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 12:31+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05