Specifications > MRR

Data Specification

Email Comments

 

This current MRR data model has been expanded above the original tag data model and some fields that are now required were not even available in the earlier data model. The data specification table contains a column for both P4 Display Name and P3 Display Name. If the P3 Display Name is shown as N/A for that field, then it did not exist and could not be submitted in a P3 formatted file. If that field is shown as Required, it is only required for data submitted in the P4 file format. Beginning on January 1, 2019, this MRR data specification will be required for all data submitted to PTAGIS, as the P3 file format will no longer be accepted for loading.

 

Session Fields

Field Name

P4 Display Name

P3 Display Name

Definition

Domain

Mark

Recapture

Recovery

Passive Recapture

Notes

FileName

File

File Name

Name of the file submitted to PTAGIS for loading. It is generated automatically by tagging software based on the first Event Date (P4) or the Tag Date (P3).

 

Each distinct set of data must be in a file with a unique name.

P4: PID-YYYY-DOY-UDF.xml

PID = Project Code

YYYY = 4-digit year of first Event Date in file

DOY = Day of year of first Event Date in file

UDF = 1-3 alphanumeric characters; defaults to incremental numbers but user can specify different values 

 

P3: PIDYYDOY.UDF

PID = Project Code

YY = 2-digit year of Tag Date

DOY=3-digit day of year of Tag Date

UDF = 1-3 character user-defined extension  to ensure the file name is unique

Required

Required

Required

Required

If PID <> Project Code, the file will be loaded with Provisional status. If Year does not match the year of the earliest Event Date in the file, the file will be rejected. If the Day of Year does not match the earliest Event Date in the file, the file will be loaded with Provisional status.

LegacyFileName

Legacy File

N/A

Name of the P3 file that was imported into P4 to create the current session, if applicable. Generated automatically by P4 upon import of a P3 file.

P3 file name format

Required if correcting P3 file with P4 file

Required if correcting P3 file with P4 file

Required if correcting P3 file with P4 file

Required if correcting P3 file with P4 file

Generated automatically when P3 file imported into P4. Cannot be changed.Once a P3 file is corrected by a P4 file, the P3 file cannot be loaded again. Any additional corrections must be by P4 file.

MRRProject

Project Code

Coordinator ID

Identifies the individual or long term research program responsible for the data collection event.

MRR Project Validation Codes

Required

Required

Required

Required

 

Name

Session

Tag Session

Name of the session in P4 or P3.

Free text up to 50 characters

Required

Required

Required

Required

Session name is required to create a session in P4. If XML file is created outside P4, use the File name as the Session name.

SessionMessage

Session Message

Session Message

Brief description or summary of the purpose and/or scope of the MRR project.

Free text 1 - 200 characters

Required

Required

Required

Required

 

SessionNote

Session Note

Session Note

Ad hoc annotations pertaining to the session as a whole.

Free text up to 4000 characters

Optional

Optional

Optional

Optional

 

 

Event Fields

Field Name

P4 Display Name

P3 Display Name

Definition

Domain

Mark

Recapture

Recovery

Passive Recapture

Notes

AcousticTag

Acoustic Tag

N/A

Acoustic tag code, if applicable.

Free text up to 50 characters

Optional

Optional

Optional

Ignored

 

BroodYear

Brood Year

Brood Year

Calendar year when tagged fish was spawned, if known.

4-digit valid year between (Event Year - 3) and Event Year

Optional

Ignored

Ignored

Ignored

 

CaptureMethod

Capture Method

Capture Method

Method used to capture or collect fish.

Capture Method Validation Codes

Required

Required

Required

Required

 

CWTag

Coded-Wire Tag

N/A

Coded Wire Tag code, if applicable.

Free text up to 50 characters

Optional

Optional

Optional

Ignored

 

ConditionalComments

Conditional Comments

Conditional Comment

Flag codes to record fish condition, morphological and environmental factors, and other situational conditions.

Flag Validation Codes, space separated, max character limit is 50, which allows 15-20 codes depending on use of single-character codes

Optional

Optional

Optional

Optional

 

DetailNote

Detail Note

Detail Note

Ad hoc annotations pertaining to the current record.

Free text up to 200 characters

Optional

Optional

Optional

Optional

 

EventDate

Event Date

Tag Date

Local date and time the data collection event occurred.

Date Time Offset between 1/1/1986 and Current Date

Required

Required

Required

Required

 

EventSite

Event Site

Tag Site

Site identifier where the data collection event occurred.

MRR Site Codes

Required

Required

Required

Required

 

EventType

Event Type

N/A

The data collection event type represented by the record.

Mark

Recapture

Recovery

Passive Recapture

Tally

Required

Required

Required

Required

 

GeneticID

Genetic ID

N/A

Unique identifier for genetic material taken from this fish.

Free text up to 50 characters

Optional

Optional

Optional

Ignored

 

Hatchery

Hatchery

Hatchery Site

Hatchery where fish was reared.

Hatchery Validation Codes

Optional

Ignored

Ignored

Ignored

 

HoldingTemperature

Hold Temp

Post Tagging Temp

Temperature (Cº) of water in the post-tagging holding facilities.

-2.0 - 25.0 degrees Celsius.

25.0 is used to indicate temperature was not collected

Optional

Optional

Ignored

Optional

 

Length

Length

Length

Fork length of fish in millimeters.

> 0

Optional

Optional

Optional

Optional

Made optional for Passive Recaptures with version 1.24,

LifeStage

Life Stage

N/A

The general life stage of the fish at the time of the event. Use Conditional Comments to indicate more specific stages.

Adult

Juvenile

Unknown

Required

Required

Required

Required

 

LocationSource

Lat/Long Source

N/A

Source for latitude and longitude coordinates:

GPS - collected with GPS

DIG - derived using digital map source

UNK - unknown

Required if Latitude/ Longitude completed

Required if Latitude/ Longitude completed

Required if Latitude/ Longitude completed

Required if Latitude/ Longitude completed

 

LocationLatitude

Latitude

N/A

If EventType is Mark or Recapture, this is the latitude of the release location. If Event Type is Recovery or PassiveRecapture, this is the latitude of the recovery or detection location.

Decimal degrees between 40 and 50

Required if Longitude completed

Required if Longitude completed

Required if Longitude completed

Required if Longitude completed

 

LocationLongitude

Longitude

N/A

If Event Type is Mark or Recapture, this is the longitude of the release location. If EventType is Recovery or PassiveRecapture, this is the longitude of the recovery or detection location.

Decimal degrees between -125 and -110

Required if Latitude completed

Required if Latitude completed

Required if Latitude completed

Required if Latitude completed

 

MarkMethod

Mark Method

Tagging Method

Method by which PIT tag was inserted into the fish.

Tag Method Validation Codes

Required

Ignored

Ignored

Ignored

 

MarkTemperature

Mark Temp

Tagging Temp

Temperature (Cº) of tagging bath during marking operation.

-2.0 - 25.0 degrees Celsius.

25.0 is used to indicate temperature was not collected

Required

Required

Ignored

Ignored

 

MigrationYear

Migration Year

Migratory Year

Earliest possible calendar year when juvenile anadromous fish will out-migrate. If tagging adult fish, this is the current calendar year.

4-digit valid year Event year or Event Year + 1

Required

Required

Ignored

Required

 

Organization

Organization

Organization

Agency or entity responsible for the data collection event.

Organization Validation Codes

Required

Required

Required

Required

 

OtherTag

Other Tag

N/A

Unique identifier of any other tag with which this fish is also marked.

Free text up to 50 characters

Optional

Optional

Optional

Ignored

 

PITTag

PIT Tag

Tag Code

Unique 10 or 14-character code of the embedded PIT tag in hexadecimal format or dot-out (10 periods).

First 7 characters must match Tag Mask Validation Codes. Dot-outs are ignored when the file is loaded into the database.

Required

Required

Required

Required

Records with Tally event type can only have dot-out as PIT tag code

Raceway

Raceway/Transect/Tank

Raceway/Transect

Abbreviated description of the sampling location.

Free text up to 30 characters

Optional

Optional

Optional

Optional

 

RadioTag

Radio Tag

N/A

Radio tag code, if present.

Free text up to 50 characters

Optional

Optional

Optional

Optional

 

SequenceNumber

Record #

Sequence Number

Number of the record in the session, generated automatically by tagging software.

Integer > 0, unique within session

Required

Required

Required

Required

 

ReleaseDate

Release Date

Release Date

Local date and time of release of marked or recaptured fish.

Date Time Offset >= Event Date time, but not in the future

Required if Release Fields completed

Required if Release Fields completed

Ignored

Required if Release Fields completed

Release fields may be left blank if fish have not been released, but must be completed once release occurs.

ReleaseSite

Release Site

Release Site

Site identifier for release location of marked or recaptured fish.

MRR Site Codes not mark site only

Required if Release Fields completed

Required if Release Fields completed

Optional

Required if Release Fields completed

Release fields may be left blank if fish have not been released, but must be completed once release occurs.

 

For Recovery events, specify Release Site only if an RKM Ext. value needs to be specified.

ReleaseTemperature

Release Temp

Release Water Temp

Temperature (Cº) of water the tagged fish were released into.

-2.0 - 25.0 degrees Celsius.

25.0 is used to indicate temperature was not collected

Required if Release Fields completed

Required if Release Fields completed

Ignored

Required if Release Fields completed

Release fields may be left blank if fish have not been released, but must be completed once release occurs.

LocationRKMOffset

RKM Ext

Release River Km

The distance in kilometers from the mouth of the stream location to the release or recovery location.

Integer,1-4 digits, left-padded with zeros

Optional only if Release Site is selected and it is a stream location.

Optional only if Release Site is selected and it is a stream location.

Optional only if Release Site is selected and it is a stream location.

Optional only if Release Site is selected and it is a stream location.

Must select Release Site that represents a stream location in order to enter an RKM Ext. value.

LocationRKM

RKM Mask

Release River Km

The RKM address from the mouth of the Columbia River to the mouth of the stream location.

RKM Mask of MRR Site Code in Release Site

Display/Lookup field only

Display/Lookup field only

Display/Lookup field only

Display/Lookup field only

Display only, cannot be changed.

ScaleID

Scale ID

N/A

Unique identifier for scale sample taken from this fish.

Free text up to 50 characters

Optional

Optional

Optional

Ignored

 

SecondPITTag

Second PIT Tag

N/A

Second PIT tag code if fish is double-tagged.

Valid 10 or 14 character tag code in hexadecimal format

Optional

Optional

Optional

Optional

 

SpawnYear

Spawn Year

N/A

Use only when marking adult fish. Calendar year when fish is expected to spawn.

4-digit valid year between Event Year and Event Year +1

Optional

Optional

Optional

Optional

 

SpeciesRunRearType

SRR Code

Species Run and Rear

Three-character code that identifies the species, run, and rear type of fish.

Verbose Species Validation Codes

Required

Required

Required

Required

 

Stock

Stock

Stock

Brief descriptor of the brood stock of the fish.

Free text up to 15 characters

Optional

Optional

Optional

Optional

 

Tagger

Tagger

Tagger

Person responsible for marking operation.

LASTNAME I in all capital letters (e.g. SMITH J) with maximum of 30 characters

Required

Required

Ignored

Ignored

 

TextComments

Text Comments

Text Comment

Free text field for ad hoc comments unique to this fish.

Free text up to 100 characters

Optional

Optional

Optional

Optional

 

Weight

Weight

Weight

Weight to the nearest tenth of a gram.

> 0

Optional

Optional

Optional

Ignored

 

 


Version: 1.07

Published: 9/6/2023