Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Northeast Salmon Team (NEST) > Atlantic Salmon Telemetry Monitoring >

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

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34173 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

4 Data table of receiver deployment, tending, and recovery information

Description

4 Data table of receiver deployment, tending, and recovery information (Format used for 2005,2006,2008,2009,2010 data)

Entity Type
Data Table

Data Attribute / Type	Description
DeploymentID AutoNumber	Unique identifier of record used for Primary key in Access
SiteCode Text	Coded site label From MaineSalmon (relational link to tblLocations)
DeploymentType Text	Type of deployment activity (e.g. Deploy, Tend, Retrieve, Bench test, Battery change, Initialization, other)
StartOrEnd Text	Whether the unit is going in or coming out. Enables complete records each time data is entered.
DeployDateTime Date/Time	Date and Time of deployment activity (Note time is in UTC!!!)
RecieverSN Text	Manufacturer's serial number of the unit deployed (relational link to tblRecieverSpecs)
DepUTMEast Long Integer	Actual Easting coordinate recorded at deployment in UTM meters NAD 1983
DepUTMNorth Long Integer	Actual Northing coordinate recorded at deployment in UTM meters NAD 1983
DepDepth Long Integer	Actual depth of unit at deployment (in feet)
LocationChange Yes/No	Was location different than previous (deployment or tend)?
Crew Text	Initial of who was involved with unit activity
Comments Memo	Remarks about the deployment activity

Data Attribute / Type

Description

DeploymentID
AutoNumber

Unique identifier of record used for Primary key in Access

SiteCode
Text

Coded site label From MaineSalmon (relational link to tblLocations)

DeploymentType
Text

Type of deployment activity (e.g. Deploy, Tend, Retrieve, Bench test, Battery change, Initialization, other)

StartOrEnd
Text

Whether the unit is going in or coming out. Enables complete records each time data is entered.

DeployDateTime
Date/Time

Date and Time of deployment activity (Note time is in UTC!!!)

RecieverSN
Text

Manufacturer's serial number of the unit deployed (relational link to tblRecieverSpecs)

DepUTMEast
Long Integer

Actual Easting coordinate recorded at deployment in UTM meters NAD 1983

DepUTMNorth
Long Integer

Actual Northing coordinate recorded at deployment in UTM meters NAD 1983

DepDepth
Long Integer

Actual depth of unit at deployment (in feet)

LocationChange
Yes/No

Was location different than previous (deployment or tend)?

Crew
Text

Initial of who was involved with unit activity

Comments
Memo

Remarks about the deployment activity

No Child Items for this record.

No contact information is available for this record.

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

Title:	tblDeployment (2005,2006,2008,2009,2010,2011,2012,2013,2015)
Short Name:	tblDeployment (2005,2006,2008,2009,2010,2011,2012,2013,2015)
Status:	Completed
Abstract:	4 Data table of receiver deployment, tending, and recovery information

Entity Type:	Data Table
Active Version?:	Yes
Description:	4 Data table of receiver deployment, tending, and recovery information (Format used for 2005,2006,2008,2009,2010 data)

Attribute Summary

	Name	Type	Description
100	DeploymentID	AutoNumber	Unique identifier of record used for Primary key in Access
100	SiteCode	Text	Coded site label From MaineSalmon (relational link to tblLocations)
100	DeploymentType	Text	Type of deployment activity (e.g. Deploy, Tend, Retrieve, Bench test, Battery change, Initialization, other)
100	StartOrEnd	Text	Whether the unit is going in or coming out. Enables complete records each time data is entered.
100	DeployDateTime	Date/Time	Date and Time of deployment activity (Note time is in UTC!!!)
100	RecieverSN	Text	Manufacturer's serial number of the unit deployed (relational link to tblRecieverSpecs)
100	DepUTMEast	Long Integer	Actual Easting coordinate recorded at deployment in UTM meters NAD 1983
100	DepUTMNorth	Long Integer	Actual Northing coordinate recorded at deployment in UTM meters NAD 1983
100	DepDepth	Long Integer	Actual depth of unit at deployment (in feet)
100	LocationChange	Yes/No	Was location different than previous (deployment or tend)?
100	Crew	Text	Initial of who was involved with unit activity
100	Comments	Memo	Remarks about the deployment activity

Name

Type

Description

100

DeploymentID

AutoNumber

Unique identifier of record used for Primary key in Access

100

SiteCode

Text

Coded site label From MaineSalmon (relational link to tblLocations)

100

DeploymentType

Text

Type of deployment activity (e.g. Deploy, Tend, Retrieve, Bench test, Battery change, Initialization, other)

100

StartOrEnd

Text

Whether the unit is going in or coming out. Enables complete records each time data is entered.

100

DeployDateTime

Date/Time

Date and Time of deployment activity (Note time is in UTC!!!)

100

RecieverSN

Text

Manufacturer's serial number of the unit deployed (relational link to tblRecieverSpecs)

100

DepUTMEast

Long Integer

Actual Easting coordinate recorded at deployment in UTM meters NAD 1983

100

DepUTMNorth

Long Integer

Actual Northing coordinate recorded at deployment in UTM meters NAD 1983

100

DepDepth

Long Integer

Actual depth of unit at deployment (in feet)

100

LocationChange

Yes/No

Was location different than previous (deployment or tend)?

100

Crew

Text

Initial of who was involved with unit activity

100

Comments

Memo

Remarks about the deployment activity

Attribute Details

DeploymentID

CC ID: 343713

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

SiteCode

CC ID: 343714

Data Storage Type:	Text
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Coded site label From MaineSalmon (relational link to tblLocations)
General Data Type:	Text

DeploymentType

CC ID: 343715

Data Storage Type:	Text
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of deployment activity (e.g. Deploy, Tend, Retrieve, Bench test, Battery change, Initialization, other)
General Data Type:	Text

StartOrEnd

CC ID: 343716

Data Storage Type:	Text
Max Length:	50
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Whether the unit is going in or coming out. Enables complete records each time data is entered.
General Data Type:	Text

DeployDateTime

CC ID: 343717

Data Storage Type:	Date/Time
Max Length:	22
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date and Time of deployment activity (Note time is in UTC!!!)
General Data Type:	Date/Time

RecieverSN

CC ID: 343718

Data Storage Type:	Text
Max Length:	50
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Manufacturer's serial number of the unit deployed (relational link to tblRecieverSpecs)
General Data Type:	Text

DepUTMEast

CC ID: 343719

Data Storage Type:	Long Integer
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Actual Easting coordinate recorded at deployment in UTM meters NAD 1983
General Data Type:	Number

DepUTMNorth

CC ID: 343720

Data Storage Type:	Long Integer
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Actual Northing coordinate recorded at deployment in UTM meters NAD 1983
General Data Type:	Number

DepDepth

CC ID: 343721

Data Storage Type:	Long Integer
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Actual depth of unit at deployment (in feet)
General Data Type:	Number

LocationChange

CC ID: 343722

Data Storage Type:	Yes/No
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Was location different than previous (deployment or tend)?
General Data Type:	Yes/No

Crew

CC ID: 343723

Data Storage Type:	Text
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Initial of who was involved with unit activity
General Data Type:	Text

Comments

CC ID: 343724

Data Storage Type:	Memo
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Remarks about the deployment activity
General Data Type:	Memo

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

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DeploymentID

SiteCode

DeploymentType

StartOrEnd

DeployDateTime

RecieverSN

DepUTMEast

DepUTMNorth

DepDepth

LocationChange

Crew

Comments

Catalog Details