Fishgroup table 'tblfgarchivalrecovery'

field	comment
whole table	This table contains recovery metadata from all archival tagged fishgroup animals. Typically joins will be made to the fgarkey or toppid fields. Important fields are recdate, harvdate, lab_recdate, tagreturned, rdateestimated, and recpositionestimated. There are probably some unnecessary 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.
addrecvtags	Any recovered tags that do not fit in other tag fields.
depstl	The deployment straight length of the fish. No reason for this field in this table. Should be deprecated.
ew	Recovery hemisphere where e is east and w is west.
fgarkey	This field should be called eventid. It joins to fgadkey in tblfgarchivaldeployment, fgdkey in tblfgprocessingstatus as well as any other place eventid works for archival tags.
harvdate	The date the tag is removed from the animal.
lab_recdate	What date did we learn about the recovery? Could also be ingestion date or record creation date.
masscondition	Seems to be a duplicate of masstype. One of them should be deprecated.
masstype	What condition was the fish, e.g., whole, round, dressed.
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.
pendate	The date the animal is put in a pen.
penname	The name of the pen where the fish was held.
rconaddress	Address of the recovery contact person.
rcon_phone	Telephone number of the recovery contact person.
rcontact	Who informed us of the recovery?
rct1type	First conventional tag type.
rct2type	Second conventional tag type.
rdateestimated	Is the recovery date an estimate?
recdate	The date the animal is recaptured or tag is recovered.
reclocation	Generic geographic location of recovery. Not very useful. Possible candidate for deprecation.
recpositionestimated	Is the recovery position estimated?
recvbinfile	Name of the recovered bin file.
recvbinpwd	The password used to unlock the Lotek LTD bin file.
recvctag1	First recovered conventional tag.
recvctag2	Second recovered conventional tag.
recvgirth	The girth of the fish in centimeters.
recvlat	Recovery latitude. Should be an integer.
recvlen1	The length of the fish in centimeters.
recvlen1type	The type of length measurement, e.g., CFL, SFL or TL.
recvlon	Recovery longitude. Should be an integer.
recvmass	The mass of the fish in kilograms.
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.
recvspecies	Same as species in deployment table. Unnecessary and should be deprecated.
rewardaddress	The address of the person who recovered the tag and receives the reward.
reward_email	The email address of the person who recoveredthe tag and receives 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 receives the reward.
rlatdd	The decimal degree recovery latitude.
rlondd	The decimal degree recovery longitude.
sex	The sex of the recovered animal.
sn	Recovery hemisphere where s is south and n is north.
sst	The SST in fahrenheit at fish recapture location.
tagcode	Same as tagcode in deployment table.
tagfunctional	Probably unnecessary because of fields in tblfgprocessingstatus. Good candidate for deprecation.
tagreturned	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.
vessel_flag	What country is the recapture vessel from?
willbeprocessed	Used as an indicator of tag health or recovery type. Handled in processing status now. Good candidate for deprecation.