Table topp.public.tblpatprogramming
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.

 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
fgsdkey serial 10  √  nextval('tblpatprogramming_fgsdkey_seq'::regclass) 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.
workgroup text 2147483647  √  null The TOPP workgroup of the principal investigator.
float text 2147483647  √  null Style of the float. Probably not necessary. Also a bad name related to reserved names. Candidate for deprecation.
hardversion text 2147483647  √  null Manufacturer hardware revision number.
tagsoft text 2147483647  √  null The tag firmware/software version number.
argosid text 2147483647  √  null The Argos PTT number for the tag.
leaderlength text 2147483647  √  null The length of the tag leader in inches.
shrinklength text 2147483647  √  null Length of the leader heat shrink 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.
pstdate text 2147483647  √  null Local date of programming in PST. Basically duplicated by localdate. Candidate for deprecation.
tagdate text 2147483647  √  null Date of programming from the tag.
tagtime text 2147483647  √  null Time at programming from the tag.
psttime text 2147483647  √  null Local time of programming in PST. Basically duplicated by timelocal. Candidate for deprecation.
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 text 2147483647  √  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.
depthcorrection text 2147483647  √  null Will a correction be applied to the depth data.
offsett text 2147483647  √  null Time offset from UTC for histogram sampling period. Affects PDT data period also.
depthcorr text 2147483647  √  null Never used. Duplicate of depthcorrection. Should be deprecated.
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.
project text 2147483647  √  null Rarely used. Totally unnecessary. Should be deprecated.
instrepfile text 2147483647  √  null Name of the instrument report file shipped with the tag when it was new.
savedrepname text 2147483647  √  null Name of the exported programming report file.
localdate text 2147483647  √  null Local date of programming.
pintype text 2147483647  √  null What style of pin is in the tag, e.g., monel.
histogramtype text 2147483647  √  null Unsure about this field.
uplinklut text 2147483647  √  null An ID used in an LUT system to locate a detached tag.
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.
tagnumber text 2147483647  √  null Manufacturer serial number of tag.
uplinklutid text 2147483647  √  null Same as uplinkut. Should be combined and one of them deprecated.
_localtime time 15,6  √  null Local time of programming.
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.
tkey serial 10  √  nextval('tblpatprogramming_tkey_seq'::regclass)

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

Indexes:
Column(s) Type Sort Constraint Name
fgsdkey Primary key Asc tblpatprogramming_pkey