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. |
Attribute Details
INTERVIEW_ID
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
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
Data Storage Type: | Character |
---|---|
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Fish codes from www.itis.gov used in Tip |
DRAWER_NO
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
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
Data Storage Type: | Character |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Box Number the slide is in |
SLIDE_NO
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
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
Data Storage Type: | Character |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tip sample type codes for otoliths, scales, and spines |
PAIRED
Data Storage Type: | Character |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Is there a pair of otoliths in the sample envelope? |
PROCESSED
Data Storage Type: | Character |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Has the sample been sectioned? |
PROCESSED_DATE
Data Storage Type: | Date |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date sample was processed |
Age_Method
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
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
Data Storage Type: | Character |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency that assigned the age |
DATE_AGED
Data Storage Type: | Date |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date sample was aged |
1st_COUNT
Data Storage Type: | Numeric |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Numeric of annuli counted on the sample |
1st_MARGIN_TYPE
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
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
Data Storage Type: | Character |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Person who aged the sample |
1st_CALENDAR_AGE
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
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
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
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
Data Storage Type: | Character |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Person who aged the sample |
2nd_CALENDAR_AGE
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
Data Storage Type: | Character |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Will or has the sample been sectioned? |
RADIUS
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
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
Data Storage Type: | Character |
---|---|
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Distance units used in measurements. |
MAGNIFICATION
Data Storage Type: | Character |
---|---|
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Microscope Magnification |
Image
Data Storage Type: | Character |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Photo location |
COMMENTS
Data Storage Type: | Character |
---|---|
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Notes |
CREATED_BY_USER_ID
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
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
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
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 |