Tablename: etags
Electronic tags deployed upon animals. One row for each tag deployed on the start sighting of the trip.
| Field name | Field type | Field length | Field description |
|---|---|---|---|
| etag_entry_id | integer | None | Unique record id number. | sighting_id | integer | None | Refers to Sightings table. | tag_model_id | integer | None | Number representing tag model, link to table tagmodels column tag_model_id. | argos_id_old | double precision | None | If tag is a PTT, PTT number (Argos ID) assigned to tag for deployment. | vhf_frequency | double precision | None | If tag is a radio locator tag, frequency of radio signal (MHz). | program_date | timestamp without time zone | None | Date tag was programmed for deployment. | program_file_name | character varying | 254 | The name of the programming journal file for this tag deployment. | data_file_path | character varying | 254 | Directory path and filename of recovered tag data file on lab file server. | is_file_here | boolean | None | True if data file was recovered and in data holdings. | data_lost | boolean | None | True if the data was lost and cannot be recovered. | is_file_bad | boolean | None | True if the data file from the recovered file was corrupted. | is_tag_lost | boolean | None | True if the tag was lost at sea and cannot be recovered. | last_transmission_date | timestamp without time zone | None | If transmittong tag (PTT), last known date of transmission. | file_type | character varying | 50 | Extension of data file. Not really used. | clock_drift | double precision | None | Difference between known time and tag internal time at recovery, in seconds. | comments | text | None | Comments on this deployed tag. | iknos_command | text | None | Iknos DA command line for this tag data file. | etag_code | character varying | 50 | Manufacturer’s serial number of tag, or labs own serial number if manufacturer didn’t supply one. | start_tag | timestamp without time zone | None | Date and time of the event when tag started transmitting. | stop_tag | timestamp without time zone | None | Date and time of the event when tag stopped transmitting. | is_recovered_without_animal | boolean | None | True if the tag was recovered without animal. | duty_cycle | boolean | None | None | duty_cycle_comment | character varying | 254 | None | argos_id | bigint | None | If tag is a PTT, PTT number (Argos ID) assigned to tag for deployment. |