MRR Field Definitions and Requirements

This table lists the fields available in P5 along with their definitions and expected domain values. Different Event Types may require different fields be completed before the data can be submitted to PTAGIS. If a field is listed as Required than it must have a value. An Optional field can have a value, but does not need one. Both required and optional fields will be validated against the domain listed in this table. If a field is listed as Ignored, it may still contain a value, but it will not be validated against the domain and it will not be loaded into PTAGIS if the record is submitted. All ignored fields will have a null value in PTAGIS for that event type.

Session Fields

Field Name	P5 Display Name	Definition	Domain	Mark	Recapture	Recovery	Passive Recapture	Notes
FileName	File	Name of the file submitted to PTAGIS for loading. It is generated automatically by tagging software based on the first Event Date (P5). Each distinct set of data must be in a file with a unique name.	P5: PID-YYYY-DOY-UDF.json 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	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	Name of the P3 or P4 file that was imported into P5 to create the current session, if applicable. Generated automatically by P5 upon import of a P3 or P4 file.	P3 or P4 file name format	Required if correcting P3 file with P5 file	Required if correcting P3 file with P5 file	Required if correcting P3 file with P5 file	Required if correcting P3 file with P5 file	Generated automatically when P3/P4 file imported into P5. Cannot be changed.Once a legacy file is corrected by a P5 file, that legacy file cannot be loaded again. Any additional corrections must be by P5 file.
MRRProject	Project Code	Identifies the individual or long term research program responsible for the data collection event.	MRR Project Validation Codes	Required	Required	Required	Required
Name	Session	Name of the session in P5.	Free text up to 50 characters	Required	Required	Required	Required	Session name is required to create a session in P5. If JSON file is created outside P5, use the File name as the Session name.
SessionMessage	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	Ad hoc annotations pertaining to the session as a whole.	Free text up to 4000 characters	Optional	Optional	Optional	Optional

Event Fields

Field Name	P5 Display Name	Definition	Domain	Mark	Recapture	Recovery	Passive Recapture	Notes
AcousticTag	Acoustic Tag	Acoustic tag code, if applicable.	Free text up to 50 characters	Optional	Optional	Optional	Ignored
BroodYear	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	Method used to capture or collect fish.	Capture Method Validation Codes	Required	Required	Required	Required
CWTag	Coded-Wire Tag	Coded Wire Tag code, if applicable.	Free text up to 50 characters	Optional	Optional	Optional	Ignored
ConditionalComments	Conditional Comments	Condition codes to record fish condition, morphological and environmental factors, and other situational conditions.	Conditional Comment 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	Ad hoc annotations pertaining to the current record.	Free text up to 200 characters	Optional	Optional	Optional	Optional
EventDate	Event 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	Site identifier where the data collection event occurred.	MRR Site Codes	Required	Required	Required	Required
EventType	Event Type	The data collection event type represented by the record.	Mark Recapture Recovery Passive Recapture Tally	Required	Required	Required	Required
GeneticID	Genetic ID	Unique identifier for genetic material taken from this fish.	Free text up to 50 characters	Optional	Optional	Optional	Ignored
Hatchery	Hatchery	Hatchery where fish was reared.	Hatchery Validation Codes	Optional	Ignored	Ignored	Ignored
HoldingTemperature	Hold 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	Fork length of fish in millimeters.	> 0	Optional	Optional	Optional	Optional	Made optional for Passive Recaptures with version 1.24,
LifeStage	Life Stage	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	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	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	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	Method by which PIT tag was inserted into the fish.	Mark Method Validation Codes	Required	Ignored	Ignored	Ignored
MarkTemperature	Mark 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	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	Agency or entity responsible for the data collection event.	Organization Validation Codes	Required	Required	Required	Required
OtherTag	Other Tag	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	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	Abbreviated description of the sampling location.	Free text up to 30 characters	Optional	Optional	Optional	Optional
RadioTag	Radio Tag	Radio tag code, if present.	Free text up to 50 characters	Optional	Optional	Optional	Optional
SequenceNumber	Record #	Number of the record in the session, generated automatically by tagging software.	Integer > 0, unique within session	Required	Required	Required	Required
ReleaseDate	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	Site identifier for release location of marked or recaptured fish.	MRR Site Codes	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	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	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	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	Unique identifier for scale sample taken from this fish.	Free text up to 50 characters	Optional	Optional	Optional	Ignored
SecondPITTag	Second PIT Tag	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	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	Three-character code that identifies the species, run, and rear type of fish.	SRR Validation Codes	Required	Required	Required	Required
Stock	Stock	Brief descriptor of the brood stock of the fish.	Free text up to 15 characters	Optional	Optional	Optional	Optional
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	Free text field for ad hoc comments unique to this fish.	Free text up to 100 characters	Optional	Optional	Optional	Optional
Weight	Weight	Weight to the nearest tenth of a gram.	> 0	Optional	Optional	Optional	Ignored

MRR Field Definitions and Requirements

Notes