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 |
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 |
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