Search Help Show/Hide Menu
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