Table topp.public.tblsgpatprogramming
This table contains programming metadata for early generation (PAT1 thru PAT5) satellite tagged sharkgroup animals. Typically joins will be made to the sgdepkey field. All date fields should be converted from type text to date or timestamp.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
tkey serial 10  √  nextval('tblsgpatprogramming_tkey_seq'::regclass)
sgdepkey int4 10 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.
tagnumber text 2147483647  √  null Manufacturer serial number of tag.
_float text 2147483647  √  null Style of the float. Probably not necessary. Candidate for deprecation.
hardversion text 2147483647  √  null Manufacturer hardware revision number.
tagsoft text 2147483647  √  null The tag firmware/software version number.
argosid int4 10  √  null The Argos PTT number for the tag.
shrinklength text 2147483647  √  null Length of the leader heat shrink in inches.
leaderlength text 2147483647  √  null The length of the tag leader in inches.
progsw text 2147483647  √  null Programming software revision number.
shrinkaddress text 2147483647  √  null Address on the shrink wrap, e.g., TRCC, MBA or NMFS.
reprate text 2147483647  √  null Repetition interval for signal transmission.
dart text 2147483647  √  null What type of dart was used, e.g., deck, nylon, OTS titanium.
shrinkid text 2147483647  √  null ID on leader heat shrink.
bobbin text 2147483647  √  null What type of bobbin is on the tag? Generally either black or orange.
localdate date 13  √  null Local date of programming.
_localtime time 15,6  √  null Local time of programming.
tagdate date 13  √  null Date of programming from the tag.
tagtime time 15,6  √  null Time at programming from the tag.
acctime text 2147483647  √  null 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.
idepth text 2147483647  √  null Live reading of depth sensor.
ideppress text 2147483647  √  null Whether or not the depth button was pressed during programming.
itemp text 2147483647  √  null Live reading of the temperature sensor.
ilight text 2147483647  √  null Live reading of the light sensor.
irtctemp text 2147483647  √  null Live reading of the real time clock temperature sensor.
pinintact text 2147483647  √  null Was the bobbin pin undamaged?
ibattvolts text 2147483647  √  null Live reading of battery voltage.
idepthtemp text 2147483647  √  null Live reading of the depth associated temperature sensor.
sampdepth text 2147483647  √  null Archive sampling rate for depth sensor data.
sampdepthunits text 2147483647  √  null The depth sensor sampling units.
samptemp text 2147483647  √  null Archive sampling rate from temperature sensor data.
samptempunits text 2147483647  √  null The temperature sensor sampling units.
samplight text 2147483647  √  null Archive sampling rate for light level data.
samplightunits text 2147483647  √  null The light sensor sampling units.
samprtctemp text 2147483647  √  null Archive sampling rate for real time clock temperature sensor.
samprtctempunits text 2147483647  √  null The sampling units for the real time clock temperature sensor.
sampbattvolts text 2147483647  √  null Archive sampling rate for battery voltage.
sampbattunits text 2147483647  √  null The sampling units for battery voltage.
sampdepthtemp text 2147483647  √  null Archive sampling rate from the depth associated temperature sensor.
sampdepthtempunits text 2147483647  √  null The sampling rate for the depth temperature sensor.
popdate date 13  √  null The programmed popup date.
poptime text 2147483647  √  null The programmed time of popup. Defaults to 12:00.
translocation text 2147483647  √  null Transmission priority for location data, e.g., Low, Medium or High.
transpdt text 2147483647  √  null Transmission priority for pressure depth temperature date.
transhist text 2147483647  √  null Transmission priority for histogram data.
day3data text 2147483647  √  null Indicates whether or not the tag should transmit TransLocation only.
datainterval text 2147483647  √  null The histogram data aggravation interval in hours.
_offset text 2147483647  √  null Time offset from UTC for histogram sampling period. Affects PDT data period also.
depthcorrection text 2147483647  √  null Will a correction be applied to the depth data.
premathours text 2147483647  √  null Consecutive hours at constant depth before premature release is initiated.
prematdepth text 2147483647  √  null The minimum depth to start premature release detection.
prematoutliers text 2147483647  √  null Allow a few outliers in the constant depth data?
predetectdepth text 2147483647  √  null Not used. Duplicate of prematdepth. The minimum depth to start premature release detection.
prematsurface text 2147483647  √  null Does the tag have to be at surface to initiate premature release?
prematdayspr text 2147483647  √  null Number of days prior to to death of the organism to assign a higher priority to the data, or None.
memallocbutton text 2147483647  √  null Whether or not the memory allocation button was activated - applies to older software.
memallochistkb text 2147483647  √  null Amount of flash memory to allocate for storage of histogram data.
memalloclocationkb text 2147483647  √  null Amount of flash memory to allocate for storage of location data.
memallocpdtkb text 2147483647  √  null Amount of flash memory to allocate for storage of pdt data.
memallocarchkb text 2147483647  √  null Amount of flash memory to allocate for storage of archival data.
lightblink text 2147483647  √  null Discontinued with hardware version 4. Refers to whether or not the light on the tag was blinking.
progdelay text 2147483647  √  null Whether or not the tag was programmed to delay recording.
progdateon text 2147483647  √  null Date the tag will be active if ProgDelay was set to Y.
progcomments text 2147483647  √  null Any comments not covered by other fields.
depth_bins text 2147483647  √  null A string concatenation of the depth bin fields.
temp_bins text 2147483647  √  null A string concatenation of the temp bin fields.
uplinklutid text 2147483647  √  null Same as uplinkut. Should be combined and one of them deprecated.
daystorelease int4 10  √  null The number of days after which the tag will release. Measured from tag activation/deployment date.
bin_id_d int4 10  √  null Integer ID that links to tblprogbins_depth in order to retrieve bin values.
bin_id_t int4 10  √  null Integer ID that links to tblprogbins_temp in order to retrieve bin values.
savedrepname text 2147483647  √  null Name of the exported programming report file.

Table contained 300 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
sgdepkey Primary key Asc tblsgpatprogramming_pkey