Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Northeast Salmon Team (NEST) > Atlantic Salmon Telemetry Monitoring >

tblDetection (2005,2006,2008,2009,2010,2011,2012,2013,2015)

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

Summary

Abstract

3 Data table of detections imported from VUE

Description

3 Data table of detections imported from VUE (Format used for 2005,2006,2008,2009,2010 data)

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DetectionID
AutoNumber 		Unique identifier of record used for Primary key in Access
ReceiverSN
Text 		Serial number of gear used for detection
PingerSN
Text 		No Description available (2005, 2006, 2008 data formats only)
PingerIDCode
Long Integer 		The IDCode (code reported by detection gear) for the pinger (2005, 2006, 2008 data formats only)
DetectDateTime
Date/Time 		Date and time of detection (note time is in UTC)
Sensor1
Long Integer 		Data value for Sensor 1 (where applicable)
Sensor1Units
Text 		Units for data value for Sensor 1 (where applicable)
Sensor2
Long Integer 		Data value for Sensor 2 (where applicable)
Sensor2Units
Text 		Units for data value for Sensor 2 (where applicable)
DataValid
Yes/No 		Validatest the authenticity of the detection
Comments
Memo 		Remarks about the detection event
Channel
Text 		Pinger channel (2005, 2006, 2008 data formats only)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: tblDetection (2005,2006,2008,2009,2010,2011,2012,2013,2015)
Short Name: tblDetection (2005,2006,2008,2009,2010,2011,2012,2013,2015)
Status: Completed
Abstract:

3 Data table of detections imported from VUE

Entity Information

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

3 Data table of detections imported from VUE (Format used for 2005,2006,2008,2009,2010 data)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 DetectionID AutoNumber Unique identifier of record used for Primary key in Access
100
 ReceiverSN Text Serial number of gear used for detection
100
 PingerSN Text No Description available (2005, 2006, 2008 data formats only)
100
 PingerIDCode Long Integer The IDCode (code reported by detection gear) for the pinger (2005, 2006, 2008 data formats only)
100
 DetectDateTime Date/Time Date and time of detection (note time is in UTC)
100
 Sensor1 Long Integer Data value for Sensor 1 (where applicable)
100
 Sensor1Units Text Units for data value for Sensor 1 (where applicable)
100
 Sensor2 Long Integer Data value for Sensor 2 (where applicable)
100
 Sensor2Units Text Units for data value for Sensor 2 (where applicable)
100
 DataValid Yes/No Validatest the authenticity of the detection
100
 Comments Memo Remarks about the detection event
100
 Channel Text Pinger channel (2005, 2006, 2008 data formats only)

Attribute Details

DetectionID

CC ID: 343725
Data Storage Type: AutoNumber
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of record used for Primary key in Access
General Data Type: Number

ReceiverSN

CC ID: 343726
Data Storage Type: Text
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Serial number of gear used for detection
General Data Type: Text

PingerSN

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

No Description available (2005, 2006, 2008 data formats only)
General Data Type: Text

PingerIDCode

CC ID: 343728
Data Storage Type: Long Integer
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

The IDCode (code reported by detection gear) for the pinger (2005, 2006, 2008 data formats only)

General Data Type: Number

DetectDateTime

CC ID: 343729
Data Storage Type: Date/Time
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Date and time of detection (note time is in UTC)
General Data Type: Date/Time

Sensor1

CC ID: 343730
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Data value for Sensor 1 (where applicable)
General Data Type: Number

Sensor1Units

CC ID: 343731
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Units for data value for Sensor 1 (where applicable)
General Data Type: Text

Sensor2

CC ID: 343732
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Data value for Sensor 2 (where applicable)
General Data Type: Number

Sensor2Units

CC ID: 343733
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Units for data value for Sensor 2 (where applicable)
General Data Type: Text

DataValid

CC ID: 343734
Data Storage Type: Yes/No
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Validatest the authenticity of the detection
General Data Type: Yes/No

Comments

CC ID: 343735
Data Storage Type: Memo
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Remarks about the detection event
General Data Type: Memo

Channel

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

Pinger channel (2005, 2006, 2008 data formats only)

General Data Type: Text

Catalog Details

Catalog Item ID: 34174
GUID: gov.noaa.nmfs.inport:34174
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-09 14:20+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-11-21
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-11-21
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-11-21