Fishgroup table 'tblfgpatprogramming'

field comment
whole table This table contains programming metadata for early generation (PAT1 thru PAT5) satellite tagged fishgroup animals. Typically joins will be made to the fgsdkey field. All date fields should be converted from type text to date or timestamp.
acctime Not consistently used. Y indicates a time difference of less than 4 seconds between tag clock and internet synchronized computer. Why is the name different than the MK10 programming table.
argosid The Argos PTT number for the tag.
bin_id_d Integer ID that links to tblprogbins_depth in order to retrieve bin values.
bin_id_t Integer ID that links to tblprogbins_temp in order to retrieve bin values.
bobbin What type of bobbin is on the tag? Generally either black or orange.
dart What type of dart was used, e.g., deck, nylon, OTS titanium.
datainterval The histogram data summarization interval in hours. The name changes to samphistogram in tblmk10programming. A commonly used variable.
day3data Indicates whether or not the tag should transmit TransLocation only.
daystorelease The number of days after which the tag will release. Measured from tag activation/deployment date.
depth_bins A string concatenation of the depth bin fields.
depthcorr Never used. Duplicate of depthcorrection. Should be deprecated.
depthcorrection Will a correction be applied to the depth data.
fgsdkey This field should be called eventid. It joins to fgsdkey in tblfgsatdeployments, fgdkey in tblfgprocessingstatus and fgsdkey in tblfgsatrecovery as well as any other place eventid works for satellite tags.
float Style of the float. Probably not necessary. Also a bad name related to reserved names. Candidate for deprecation.
hardversion Manufacturer hardware revision number.
histogramtype Unsure about this field.
ibattvolts Live reading of battery voltage.
ideppress Whether or not the depth button was pressed during programming.
idepth Live reading of depth sensor.
idepthtemp Live reading of the depth associated temperature sensor.
ilight Live reading of the light sensor.
instrepfile Name of the instrument report file shipped with the tag when it was new.
irtctemp Live reading of the real time clock temperature sensor.
itemp Live reading of the temperature sensor.
leaderlength The length of the tag leader in inches.
lightblink Discontinued with hardware version 4. Refers to whether or not the light on the tag was blinking.
localdate Local date of programming.
_localtime Local time of programming.
memallocarchkb Amount of flash memory to allocate for storage of archival data.
memallocbutton Whether or not the memory allocation button was activated - applies to older software.
memallochistkb Amount of flash memory to allocate for storage of histogram data.
memalloclocationkb Amount of flash memory to allocate for storage of location data.
memallocpdtkb Amount of flash memory to allocate for storage of pdt data.
offsett Time offset from UTC for histogram sampling period. Affects PDT data period also.
pinintact Was the bobbin pin undamaged?
pintype What style of pin is in the tag, e.g., monel.
popdate The programmed popup date.
poptime The programmed time of popup. Defaults to 12:00.
predetectdepth Not used. Duplicate of prematdepth. The minimum depth to start premature release detection.
prematdayspr Number of days prior to to death of the organism to assign a higher priority to the data, or None.
prematdepth The minimum depth to start premature release detection.
premathours Consecutive hours at constant depth before premature release is initiated.
prematoutliers Allow a few outliers in the constant depth data?
prematsurface Does the tag have to be at surface to initiate premature release?
progcomments Any comments not covered by other fields.
progdateon Date the tag will be active if ProgDelay was set to Y.
progdelay Whether or not the tag was programmed to delay recording.
progsw Programming software revision number.
project Rarely used. Totally unnecessary. Should be deprecated.
pstdate Local date of programming in PST. Basically duplicated by localdate. Candidate for deprecation.
psttime Local time of programming in PST. Basically duplicated by timelocal. Candidate for deprecation.
reprate Repetition interval for signal transmission.
sampbattunits The sampling units for battery voltage.
sampbattvolts Archive sampling rate for battery voltage.
sampdepth Archive sampling rate for depth sensor data.
sampdepthtemp Archive sampling rate from the depth associated temperature sensor.
sampdepthtempunits The sampling rate for the depth temperature sensor.
sampdepthunits The depth sensor sampling units.
sample_int Time in seconds for time series sample interval.
samplight Archive sampling rate for light level data.
samplightunits The light sensor sampling units.
samprtctemp Archive sampling rate for real time clock temperature sensor.
samprtctempunits The sampling units for the real time clock temperature sensor.
samptemp Archive sampling rate from temperature sensor data.
samptempunits The temperature sensor sampling units.
savedrepname Name of the exported programming report file.
shrinkaddress Address on the shrink wrap, e.g., TRCC, MBA or NMFS.
shrinkid ID on leader heat shrink.
shrinklength Length of the leader heat shrink in inches.
tagdate Date of programming from the tag.
tagnumber Manufacturer serial number of tag.
tagsoft The tag firmware/software version number.
tagtime Time at programming from the tag.
temp_bins A string concatenation of the temp bin fields.
transhist Transmission priority for histogram data.
translocation Transmission priority for location data, e.g., Low, Medium or High.
transpdt Transmission priority for pressure depth temperature date.
uplinklut An ID used in an LUT system to locate a detached tag.
uplinklutid Same as uplinkut. Should be combined and one of them deprecated.
workgroup The TOPP workgroup of the principal investigator.