Sharkgroup table 'tblsgmk10processing'

field comment
whole table This table contains programming metadata for later generation (MK10, miniPAT) satellite tagged sharkgroup animals. Typically joins will be made to the sgdepkey field. There are 14 bin fields for depth and temperature each. The histogram bin values, in order from lowest to highest, can be found in these fields in incremental order starting with bin1. These same values are concatenated into the depth_bins and temp_bins fields, as well as stored in tblprogbin_depth and tblprogbin_temp. The idea of using the progbin tables is to make this programming table simpler. Some fields are MK10 or miniPAT specific. Many are not required for a successful deployment. Some have carried over from tblpatprogramming and should be eliminated. Fields datainterval and samphistogram are easily confused. In tblpatprogramming the field datainterval represents the same data as samphistogram in tblmk10programming. In tblmk10programming the field samphistogram replaces datainterval for storing summarization in hours, and datainterval stores the histogram sampling interval in seconds. The field samphistogram is the much more commonly used value.
actualsequence A MK10 setting. Ratio of light level location transmissions to other transmissions (i.e. histograms and PDTs) after popup.
argosid The Argos PTT number for the tag.
auto_depth_release Will the tag auto release at a certain depth?
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 Histogram data sampling interval in seconds. This parameter goes away in miniPATs.
daysdblprior Number of days of data just prior to a premature release that will be transmitted with double priority. Rarely used. Could be deprecated.
daysmemoryfilled Number of days from deployment until the memory on the tag will be filled.
daystorelease The number of days after which the tag will release. Measured from tag activation/deployment date.
deployed Was the tag put in deployment mode? This is duplicated by the exitmode field. Good candidate for deprecation.
depth_bins A string concatenation of the depth bin fields.
depthcorrmethod Method to calibrate depth sensor (usually shallow depth).
depthvar Acceptable variation in depth within which the tag is considered to be at a constant value.
exitmode What state is the tag in? Deployed, standby or shutdown? This field essentially duplicated the deployed field.
_float Style of the float. Probably not necessary. Candidate for deprecation.
hardversion Manufacturer hardware revision number.
homing_pinger MiniPAT specific. Was the homing pinger activated?
ibattvolts Live reading of battery voltage.
idepth Live reading of depth sensor.
idepthtemp Live reading of the depth associated temperature sensor.
iexttemp Live reading of the external temperature sensor.
iinttemp Live reading of the internal temperature sensor.
ilight Live reading of the light sensor.
isensthresh Threshold value for wet/dry determinations. Defaults to dynamic.
iwetdry Live reading of wet/dry sensor. If tag is dry should read 255.
leader_cuff Type of construction used to build the leader cuff.
leaderer Who built the leader?
leaderlength The length of the tag leader in inches.
leader_type Type and size of material used to construct leader.
lllocations Will the tag record light level locations?
localdate Local date of programming.
_localtime Local time of programming.
locationpriority Transmission priority for location data, e.g., none, low or high.
_offset Time offset from UTC for histogram sampling period. Affects PDT data period also.
patdtprofile Will the tag transmit PDT data?
popdate The programmed popup date.
poptime The programmed time of popup. Defaults to 12:00.
popuphour The programmed hour of popup.
predetectdepth Not used. Duplicate of prematdepth. The minimum depth to start premature release detection.
prematdayspr Not used. Carry over from tblpatprogramming. Candidate for deprecation.
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?
progby Who programmed the tag.
progcomments Any comments not covered by other fields.
progcycle Not used anymore. Good candidate for deprecation. Counting from 1, the current number of times the tag has been programmed for current project.
progsw Programming software revision number.
pswdchanged Was the password changed? Not generally used. Candidate for deprecation.
reprate Repetition interval for signal transmission.
sameaswake Not used. Carry over from tblpatprogramming. Candidate for deprecation.
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.
sampexttemp Archive sampling rate from external temperature sensor data.
samphistogram The histogram data summarization interval in hours. A commonly used variable.
sampinttemp Archive sampling rate from internal temperature sensor data.
sample_int Time in seconds for time series sample interval.
samplemode Wet or dry sampling mode. WetDry is the only value stored in this field.
samplight Archive sampling rate for light level data.
sampwetdry Archive sampling rate for wet/dry data.
savedrepname Name of the exported programming report file.
sgdepkey This field should be called eventid. It joins to sgdepkey in tblsharkdeployment and tblsharkrecovery, and sgdkey in tblsgprocessingstatus.
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.
tagprobs Duplicate of progcomments. They should be merged and this field can be deprecated.
tagsoft The tag firmware/software version number.
tagtime Time at programming from the tag.
temp_bins A string concatenation of the temp bin fields.
timeacc Not consistently used. Y indicates a time difference of less than 4 seconds between tag clock and internet synchronized computer.
trans_count How many transmissions has the tag made?
transmit_histo MiniPAT specific. Will the tag transmit depth and temperature histrogram data?
transmit_mlt MiniPAT specific. Will the tag transmit data on mixed layer stats?
ts_depth_transmit MiniPAT specific. Will the tag transmit depth time series data?
ts_temp_transmit MiniPAT specific. Will the tag transmit temperature time series data?
uplinklutid An ID used in an LUT system to locate a detached tag.
verifymode Not generally used anymore. Was exit mode verified with a magnet?