Fishgroup table 'tblfgsatrecovery'

field	comment
whole table	This table contains recovery metadata from all satellite and acoustic tagged fishgroup animals. Typically joins will be made to the fgsdkey or toppid fields. Important fields are actpopdate, rdate, lab_recdate, tagrecovered, fish_recaptured, rdateestimated, and recpositionestimated. There are probably some unnecessary fields. In particular there seem to be too many comment fields. All of the yes/no fields use 1 and 0 as their values and should be changed from type text to integer. All date fields should be converted from type text to date or timestamp.
actew	Recovery hemisphere where e is east and w is west.
actns	Popup hemisphere where s is south and n is north.
actpopdate	The popup date of the tag.
actpoplat	The decimal degree popup latitude.
actpoplon	The decimal degree popup longitude.
addrecvtags	Any recovered tags that do not fit in other tag fields.
auto_depth_released	Did the tag release at a programmed max depth? True is 1, and false is 0.
ew	Recovery hemisphere where e is east and w is west.
fgsdkey	This field should be called eventid. It joins to fgsdkey in tblfgsatdeployments, fgdkey in tblfgprocessingstatus as well as any other place eventid works for satellite or acoustic tags.
fish_recaptured	Was the fish recaptured as part of the recovery?
gender	The sex of the recovered animal. Why is the name different than the archival recovery version?
lab_recdate	What date did we learn about the recovery? Could also be ingestion date or record creation date.
ns	Recovery hemisphere where s is south and n is north.
paid	Was the reward paid? Yes is 1 and no is 0.
paid_amount	The dollar amount of the reward.
paid_comment	Comments related to the reward payment.
pin_broken	Did the leader retaining pin on the popup tag break?
popdate_geoloc	This is the correct popoff date identified with tag data. Necessary when a tag floats at the surface failing to recognize popup.
poplat_geoloc	The decimal degree latitude of geolocation from popdate_geoloc.
poplon_geoloc	The decimal degree longitude of geolocation from popdate_geoloc.
poppositiontype	Initially used to differentiate geolocation/modified popups from standard ones. Now also used to label tags that transmitted a date but 3 or less positions (possibly none). These are not real popups but have enough meaning for Barb that she wants them accounted for. These failed popups will be labeled as ghosts.
popup_lc	The Argos location quality of the popup location.
popup_sst	The SST at time of popup within 3 days or less.
prematurerelease	Did the tag popup more than 7 days prior to the programmed popup date?
rcomments	Not used much. Unsure about this field. Candidate for deprecation.
rconaddress	Address of the recovery contact person.
rcon_email	The email address of the recovery contact person.
rcon_phone	Telephone number of the recovery contact person.
rcontact	Who informed us of the recovery?
rcontcomments	Any additional information about the recovery contact.
rct1type	First conventional tag type.
rct2type	Second conventional tag type.
rdate	The date the animal is recaptured or tag is recovered.
rdateestimated	Is the recovery date an estimate?
reclocation	Generic geographic location of recovery. Not very useful. Possible candidate for deprecation.
recpositionestimated	Is the recovery position estimated?
recvcomment	General comments.
recvctag1	First recovered conventional tag.
recvctag2	Second recovered conventional tag.
recvlat	Recovery latitude. Should be an integer.
recvlon	Recovery longitude. Should be an integer.
recvsourcename	Name of the fishing vessel.
recvsourcetype	Will generally be what type of fishing vessel caught the fish but can also be beachcomber, trap etc.
release_depth	Depth in meters at tag release.
rewardaddress	The address of the person who recovered the tag and received the reward.
reward_email	The email address of the person who recovered the tag and received the reward.
rewardperson	The name of the person who recovered the tag and receives the reward.
reward_phone	The phone number of the person who recovered the tag and received the reward.
rgirth	The girth of the fish in centimeters. Why is the name different than the archival recovery version?
rinjuries	Any injuries noted on the fish at the time of recapture.
rlatdd	The decimal degree recovery latitude.
rlength	The length of the fish in centimeters. Why is the name different than the archival recovery version?
rlentype	The type of length measurement, e.g., CFL, SFL or TL.
rlondd	The decimal degree recovery longitude.
rmass	The mass of the fish in kilograms. Why is the name different than the archival recovery version?
rmasstype	What condition was the fish, e.g., whole, round, dressed.
rsource	Not used much. Unsure about this field. Candidate for deprecation.
rtagcomments	Not used much. Unsure about this field. Candidate for deprecation.
rtagnumber	The manufacturer serial number of the recovered tag. Not really necessary since it is duplicated in the deployment table.
tagrecovered	Was the tag returned to the Block lab or another location where the data could be downloaded?
toppid	Same as toppid in deployment table.
unknowndeploy	There are some old ABFT recoveries where we never received the tag or tag number. We guessed at the possible deployment tags and gave them a value of 1 for this field.