Data Specification

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