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,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
Serial number of pinger (2005, 2006 data formats only)
PingerIDCode
Long Integer
The IDCode (code reported by detection gear) for the pinger
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
Comments1
Memo
Remarks about the detection event (2005, 2006 data formats only)
Channel
Text
Pinger channel (2005, 2006 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: tblErroneous (2005,2006,2009,2010,2011,2012,2013)
Short Name: tblErroneous (2005,2006,2009,2010,2011,2012,2013)
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,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 Serial number of pinger (2005, 2006 data formats only)
100
PingerIDCode Long Integer The IDCode (code reported by detection gear) for the pinger
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
Comments1 Memo Remarks about the detection event (2005, 2006 data formats only)
100
Channel Text Pinger channel (2005, 2006 data formats only)

Attribute Details

DetectionID

CC ID: 343737
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: 343738
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: 343739
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Serial number of pinger (2005, 2006 data formats only)

General Data Type: Text

PingerIDCode

CC ID: 343740
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

General Data Type: Number

DetectDateTime

CC ID: 343741
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: 343742
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: 343743
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: 343744
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: 343745
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: 343746
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: 343747
Data Storage Type: Memo
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Remarks about the detection event

General Data Type: Memo

Comments1

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

Remarks about the detection event (2005, 2006 data formats only)

General Data Type: Memo

Channel

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

Pinger channel (2005, 2006 data formats only)

General Data Type: Text

Catalog Details

Catalog Item ID: 34175
GUID: gov.noaa.nmfs.inport:34175
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