| field |
comment |
| whole table |
This table contains programming metadata for archival tagged fishgroup animals. Typically joins will be made to the fgapkey field. All date fields should be converted from type text to date or timestamp. |
| battpercent_used |
How much of the battery has already been used? |
| battvolt |
Battery voltage at programming. |
| bdatefile |
Related to Lotek LTD bin file. Never used. Good candidate for deprecation. |
| calfile |
Not used. Unsure of original intent. Good candidate for deprecation. |
| daysmemoryfilled |
Wildlife version of memory_duration_days. Could probably combine them. |
| delay |
The number of days delay from programming date before the tag starts recording data. |
| depth |
A live reading of the depth sensor. |
| dzero |
A Lotek LTD specific setting that defaults to 50 and was probably never changed. |
| etemp |
A live reading of the external temperature sensor. |
| etemp_bits |
The Lotek LAT bits used to record external temperature data. |
| etemp_max |
The Lotek LAT maximum external temperature bound. |
| etemp_min |
The Lotek LAT minimum external temperature bound. |
| etemp_precision |
The Lotek LAT external temperature resolution. |
| exitmode |
What state is the tag in? Deployed, standby or shutdown? |
| fgapkey |
This field should be called eventid. It joins to fgarkey in tblfgarchivalrecovery, fgdkey in tblfgprocessingstatus and fgadkey in tblfgarchivaldeployment as well as any other place eventid works for archival tags. |
| fieldleader |
Hardly ever used. Candidate for deprecation. |
| itemp |
A live reading of the internal temperature sensor. |
| itemp_bits |
The Lotek LAT bits used to record internal temperature data. |
| itemp_max |
The Lotek LAT maximum internal temperature bound. |
| itemp_min |
The Lotek LAT minimum internal temperature bound. |
| itemp_precision |
The Lotek LAT internal temperature resolution. |
| jdatefile |
Related to Lotek LTD journal file. Never used. Good candidate for deprecation. |
| light |
A live reading of the light sensor. |
| light_bits |
The Lotek LAT bits used to record light date. |
| light_max |
The Lotek LAT maximum light bound. |
| light_min |
The Lotek LAT minimum light bound. |
| light_precision |
The Lotek LAT light resolution in 224 unit less levels. |
| localprogtime |
Local time at programming. Not commonly used. Good candidate for deprecation. |
| memory_cleared |
Was the memory cleared during programming? |
| memory_duration_days |
The Lotek LAT value for number of days until memory is full. |
| memory_percent |
The Lotek LAT value for percent of memory used. |
| password |
What is the tag password? |
| ppassword |
Never used. Good candidate for deprecation. |
| pressure_bits |
The Lotek LAT bits used to record depth data. |
| pressure_max |
The Lotek LAT maximum depth bound. |
| pressure_min |
The Lotek LAT minimum depth bound. |
| pressure_precision |
The Lotek LAT depth resolution in decibars. |
| progbinfile |
The Lotek LTD bin file downloaded during programming. |
| progdate |
UTC date of programming. |
| progjnlfile |
The Lotek LTD journal file saved during programming. |
| progsw |
The programming software version number. |
| progtime |
UTC time of programming. |
| project |
Duplicate from deployment table. Good candidate for deprecation. |
| recint |
The sampling interval in seconds. |
| reverfile |
Not used. Unsure of original intent. Good candidate for deprecation. |
| seriesname |
Duplicate from deployment table. Good candidate for deprecation. |
| spassword |
Never used. Good candidate for deprecation. |
| startdate |
The Lotek LAT data recording start date. |
| start_logging |
Was logging started on the Lotek LAT tag? |
| tagcode |
Serial number of tag with prefix identifying manufacturer and model. The prefix matches tagcode in tbltopptags. This prefix is unnecessary given the tagmodel field and will be deprecated in future. |
| tagdate |
Local tag date. |
| tagprogby |
Who programmed the tag? |
| tagreset |
A Lotek LTD reference to whether or not the tag was reset. |
| tagsoft |
The tag firmware/software version number. |
| tagtime |
Local tag time. Duplication of localprogtime. One of them should be deprecated. |
| tele |
Will the tag telescope data? |
| timediff |
The difference between internet synchronizedtime and tag time. |
| toppid |
The basic ID number for a specific animal deployment.Matches the first 7 digits of eventid. |
| transtatus |
A Lotek LTD tag setting that confirmssuccessful bin file download. |
| workgroup |
Hardly ever used. Candidate for deprecation. |