Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Protected Resources Division (PRD) Metadata Po... > Students Collaborating to Undertake Tracking Ef... >

STURGEON_SCUTES_EVENTS

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:46629  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Describes about sturgeon scutes events.

Description

Describes about sturgeon scutes events.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
STURGEON_SCUTES_EVENTS_ID
NUMBER 		Character sequence used to identify researchers' interaction with an individual sturgeon containing a SCUTES-issued tag
STURGEON_SCUTES_ID
NUMBER 		The ID name for sturgeon that have been tagged with a SCUTES-issued tag.
DATE_EVENT_RECORDED
DATE 		Date at which the scutes event with a researchers' interaction with an individual sturgeon containing a SCUTES-issued tag
RESEARCHER_NAME
VARCHAR2 		The researcher name. These could be the researchers who make the tag detections (TRACKER) OR the researchers who originally tagged the sturgeon (TAGGER).
RESEARCHER_ROLE
VARCHAR2 		Role of the researcher
RECEIVER
VARCHAR2 		This is the number of the tag detector device.
STATION_NAME
VARCHAR2 		The location of the station
LATITUDE
NUMBER 		The location of the sturgeon (in latitude)
LONGITUDE
NUMBER 		The location of the sturgeon (in longitude)
DEPTH
VARCHAR2 		The location of the sturgeon in the river (how depth)
DEPTH_UOM
VARCHAR2 		The location of the sturgeon in the river (how depth)(unit of measure)
LOCATION
VARCHAR2 		The location of the station
LOCATION_UOM
VARCHAR2 		The location of the station(unit of measure)
SOAK_TIME
NUMBER 		The amount of time the sampling net was in the water
SOAK_TIME_UOM
VARCHAR2 		The amount of time the sampling net was in the water(unit of measure)
TOTAL_LENGTH
NUMBER 		Measurement of the straight line along the body axis from the tip of the snout to the tip of the tail
TOTAL_LENGTH_UOM
VARCHAR2 		Measurement of the straight line along the body axis from the tip of the snout to the tip of the tail(unit of measure)(always in CM)
FORK_LENGTH
NUMBER 		Measurement of the straight line along the body axis from the tip of the snout to the posterior edge of the fork of the tail
FORK_LENGTH_UOM
VARCHAR2 		Measurement of the straight line along the body axis from the tip of the snout to the posterior edge of the fork of the tail(unit of measure)
HEIGHT_LENGTH
NUMBER 		Measurement of height and length
HEIGHT_LENGTH_UOM
VARCHAR2 		Unit of measurement for height and length
IOW
NUMBER 		distance (in cm) between the lateral margins of the bony skull at the midpoint of the orbit
IOW_UOM
VARCHAR2 		distance (in cm) between the lateral margins of the bony skull at the midpoint of the orbit(unit of measure)
MW
NUMBER 		distance (in cm) between the left and right inside corners of the mouth (i.e., excluding the lips); this should be measured with the mouth closed
MW_UOM
VARCHAR2 		distance (in cm) between the left and right inside corners of the mouth (i.e., excluding the lips); this should be measured with the mouth closed(unit of measure)
WEIGHT
NUMBER 		The weight of the sturgeon (in kg)
WEIGHT_UOM
VARCHAR2 		The weight of the sturgeon (in kg)(unit of measure)
WEIGHT_STATUS
VARCHAR2 		Weight Status
BLOOD
VARCHAR2 		Yes or No answers indicating whether blood samples were taken from fishes
GENETICS
VARCHAR2 		Yes or No answers indicating whether tissue samples were taken from fishes to conduct genetic analyses
NOTES
VARCHAR2 		Some additional notes about sturgeons
EVENT_ID
NUMBER 		Character sequence used to identify researchers' interaction with an individual sturgeon
EVENT_TYPE
VARCHAR2 		Interaction with an individual sturgeon (e.g., tagging or tracking)
CREATED_BY
VARCHAR2 		Created by which user?
DATE_CREATED
DATE 		The date at which data has been created
MODIFIED_BY
VARCHAR2 		Modified by which user?
DATE_MODIFIED
VARCHAR2 		The date at which data has been modified
ORIGINAL_STURGEON_EVENTS_ID
NUMBER 		Character sequence used to identify researchers' first interaction with an individual sturgeon
RECORD_IS_DELETED
NUMBER 		Data has been omitted
DATE_RECORD_DELETED
DATE 		The date at which data has been omitted
SOURCE
VARCHAR2 		Originating source

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: STURGEON_SCUTES_EVENTS
Abstract:

Describes about sturgeon scutes events.

Entity Information

Entity Type: Data Table
Description:

Describes about sturgeon scutes events.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key STURGEON_SCUTES_EVENTS_ID NUMBER Character sequence used to identify researchers' interaction with an individual sturgeon containing a SCUTES-issued tag
100
 STURGEON_SCUTES_ID NUMBER The ID name for sturgeon that have been tagged with a SCUTES-issued tag.
100
 DATE_EVENT_RECORDED DATE Date at which the scutes event with a researchers' interaction with an individual sturgeon containing a SCUTES-issued tag
100
 RESEARCHER_NAME VARCHAR2 The researcher name. These could be the researchers who make the tag detections (TRACKER) OR the researchers who originally tagged the sturgeon (TAGGER).
100
 RESEARCHER_ROLE VARCHAR2 Role of the researcher
100
 RECEIVER VARCHAR2 This is the number of the tag detector device.
100
 STATION_NAME VARCHAR2 The location of the station
100
 LATITUDE NUMBER The location of the sturgeon (in latitude)
100
 LONGITUDE NUMBER The location of the sturgeon (in longitude)
100
 DEPTH VARCHAR2 The location of the sturgeon in the river (how depth)
100
 DEPTH_UOM VARCHAR2 The location of the sturgeon in the river (how depth)(unit of measure)
100
 LOCATION VARCHAR2 The location of the station
100
 LOCATION_UOM VARCHAR2 The location of the station(unit of measure)
100
 SOAK_TIME NUMBER The amount of time the sampling net was in the water
100
 SOAK_TIME_UOM VARCHAR2 The amount of time the sampling net was in the water(unit of measure)
100
 TOTAL_LENGTH NUMBER Measurement of the straight line along the body axis from the tip of the snout to the tip of the tail
100
 TOTAL_LENGTH_UOM VARCHAR2 Measurement of the straight line along the body axis from the tip of the snout to the tip of the tail(unit of measure)(always in CM)
100
 FORK_LENGTH NUMBER Measurement of the straight line along the body axis from the tip of the snout to the posterior edge of the fork of the tail
100
 FORK_LENGTH_UOM VARCHAR2 Measurement of the straight line along the body axis from the tip of the snout to the posterior edge of the fork of the tail(unit of measure)
100
 HEIGHT_LENGTH NUMBER Measurement of height and length
100
 HEIGHT_LENGTH_UOM VARCHAR2 Unit of measurement for height and length
100
 IOW NUMBER distance (in cm) between the lateral margins of the bony skull at the midpoint of the orbit
100
 IOW_UOM VARCHAR2 distance (in cm) between the lateral margins of the bony skull at the midpoint of the orbit(unit of measure)
100
 MW NUMBER distance (in cm) between the left and right inside corners of the mouth (i.e., excluding the lips); this should be measured with the mouth closed
100
 MW_UOM VARCHAR2 distance (in cm) between the left and right inside corners of the mouth (i.e., excluding the lips); this should be measured with the mouth closed(unit of measure)
100
 WEIGHT NUMBER The weight of the sturgeon (in kg)
100
 WEIGHT_UOM VARCHAR2 The weight of the sturgeon (in kg)(unit of measure)
100
 WEIGHT_STATUS VARCHAR2 Weight Status
100
 BLOOD VARCHAR2 Yes or No answers indicating whether blood samples were taken from fishes
100
 GENETICS VARCHAR2 Yes or No answers indicating whether tissue samples were taken from fishes to conduct genetic analyses
100
 NOTES VARCHAR2 Some additional notes about sturgeons
100
 EVENT_ID NUMBER Character sequence used to identify researchers' interaction with an individual sturgeon
100
 EVENT_TYPE VARCHAR2 Interaction with an individual sturgeon (e.g., tagging or tracking)
100
 CREATED_BY VARCHAR2 Created by which user?
100
 DATE_CREATED DATE The date at which data has been created
100
 MODIFIED_BY VARCHAR2 Modified by which user?
100
 DATE_MODIFIED VARCHAR2 The date at which data has been modified
100
 ORIGINAL_STURGEON_EVENTS_ID NUMBER Character sequence used to identify researchers' first interaction with an individual sturgeon
100
 RECORD_IS_DELETED NUMBER Data has been omitted
100
 DATE_RECORD_DELETED DATE The date at which data has been omitted
100
 SOURCE VARCHAR2 Originating source

Attribute Details

STURGEON_SCUTES_EVENTS_ID

CC ID: 574166
Seq. Order: 1
Data Storage Type: NUMBER
Required: Yes
Primary Key: Yes
Status: Active
Description:

Character sequence used to identify researchers' interaction with an individual sturgeon containing a SCUTES-issued tag

STURGEON_SCUTES_ID

CC ID: 574167
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

The ID name for sturgeon that have been tagged with a SCUTES-issued tag.

DATE_EVENT_RECORDED

CC ID: 574135
Seq. Order: 3
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date at which the scutes event with a researchers' interaction with an individual sturgeon containing a SCUTES-issued tag

RESEARCHER_NAME

CC ID: 574160
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

The researcher name. These could be the researchers who make the tag detections (TRACKER) OR the researchers who originally tagged the sturgeon (TAGGER).

RESEARCHER_ROLE

CC ID: 574161
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Role of the researcher

RECEIVER

CC ID: 574158
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

This is the number of the tag detector device.

STATION_NAME

CC ID: 574165
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

The location of the station

LATITUDE

CC ID: 574149
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The location of the sturgeon (in latitude)

LONGITUDE

CC ID: 574152
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The location of the sturgeon (in longitude)

DEPTH

CC ID: 574138
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The location of the sturgeon in the river (how depth)

DEPTH_UOM

CC ID: 574139
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The location of the sturgeon in the river (how depth)(unit of measure)

LOCATION

CC ID: 574150
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

The location of the station

LOCATION_UOM

CC ID: 574151
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The location of the station(unit of measure)

SOAK_TIME

CC ID: 574162
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The amount of time the sampling net was in the water

SOAK_TIME_UOM

CC ID: 574163
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The amount of time the sampling net was in the water(unit of measure)

TOTAL_LENGTH

CC ID: 574168
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Measurement of the straight line along the body axis from the tip of the snout to the tip of the tail

TOTAL_LENGTH_UOM

CC ID: 574169
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Measurement of the straight line along the body axis from the tip of the snout to the tip of the tail(unit of measure)(always in CM)

FORK_LENGTH

CC ID: 574142
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Measurement of the straight line along the body axis from the tip of the snout to the posterior

edge of the fork of the tail

FORK_LENGTH_UOM

CC ID: 574143
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Measurement of the straight line along the body axis from the tip of the snout to the posterior

edge of the fork of the tail(unit of measure)

HEIGHT_LENGTH

CC ID: 574145
Seq. Order: 20
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Measurement of height and length

HEIGHT_LENGTH_UOM

CC ID: 574146
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Unit of measurement for height and length

IOW

CC ID: 574147
Seq. Order: 22
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

distance (in cm) between the lateral margins of the bony skull at the midpoint of the orbit

IOW_UOM

CC ID: 574148
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

distance (in cm) between the lateral margins of the bony skull at the midpoint of the orbit(unit of measure)

MW

CC ID: 574154
Seq. Order: 24
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

distance (in cm) between the left and right inside corners of the mouth (i.e., excluding the lips); this should be measured with the mouth closed

MW_UOM

CC ID: 574155
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

distance (in cm) between the left and right inside corners of the mouth (i.e., excluding the lips); this should be measured with the mouth closed(unit of measure)

WEIGHT

CC ID: 574170
Seq. Order: 26
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The weight of the sturgeon (in kg)

WEIGHT_UOM

CC ID: 574172
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The weight of the sturgeon (in kg)(unit of measure)

WEIGHT_STATUS

CC ID: 574171
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Weight Status

BLOOD

CC ID: 574132
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Yes or No answers indicating whether blood samples were taken from fishes

GENETICS

CC ID: 574144
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Yes or No answers indicating whether tissue samples were taken from fishes to conduct genetic analyses

NOTES

CC ID: 574156
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Some additional notes about sturgeons

EVENT_ID

CC ID: 574140
Seq. Order: 32
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Character sequence used to identify researchers' interaction with an individual sturgeon

EVENT_TYPE

CC ID: 574141
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Interaction with an individual sturgeon (e.g., tagging or tracking)

CREATED_BY

CC ID: 574133
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Created by which user?

DATE_CREATED

CC ID: 574134
Seq. Order: 35
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The date at which data has been created

MODIFIED_BY

CC ID: 574153
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Modified by which user?

DATE_MODIFIED

CC ID: 574136
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The date at which data has been modified

ORIGINAL_STURGEON_EVENTS_ID

CC ID: 574157
Seq. Order: 38
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Character sequence used to identify researchers' first interaction with an individual sturgeon

RECORD_IS_DELETED

CC ID: 574159
Seq. Order: 39
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Data has been omitted

DATE_RECORD_DELETED

CC ID: 574137
Seq. Order: 40
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The date at which data has been omitted

SOURCE

CC ID: 574164
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Originating source

Catalog Details

Catalog Item ID: 46629
GUID: gov.noaa.nmfs.inport:46629
Metadata Record Created By: Sandeep Thumma
Metadata Record Created: 2017-07-26 10:50+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-09-26
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-09-26