| field |
comment |
| whole table |
This is the management table for archival tags. Typically joins will be made to the tagnumber field. Important fields used as query filters are tagmodel, tagstatus, invoicedate and owner. All date fields should be converted from type text to date or timestamp. |
| comments |
Any comments about the tag including past locations. |
| eventid |
The eventid assigned to the tag if it was deployed. The most recent eventid if it was deployed multiple times. |
| eventid_prev |
Previous eventids if the tag was deployed multiple times. Still trying to decide if this field is useful. |
| free_test |
Is this a free and/or test tag? |
| hardwareversion |
Specific to Wildlife Computers tags. The hardware revision number of the tag. |
| invoicedate |
What is the date on the shipping invoice? |
| ordernumber |
The order number. |
| owner |
Who owns the tag? |
| physicallocation |
Duplicated by tagstatus and comments. Should be merged into them and deprecated. |
| rewardamount |
What is the reward amount printed on the tag? |
| rma_number |
RMA number associated with tag return to manufacturer. |
| rma_request |
The requested action associated with rma_number. |
| startdate |
Not sure about this one. Candidate for deprecation. |
| suture |
Belongs in the deployment or programming table. Candidate for deprecation. |
| taglabel |
Generic reference to label style and content. Generally either Pacific or Atlantic. |
| tagmodel |
Manufacturer model number of tag. |
| tagmodel_num |
Probably specific to Wildlife Computers. More specific tag model information, e.g., newer Mk9s can be number 286C or 286F. |
| tagnumber |
The manufacturer serial number. |
| tagstatus |
The current location and/or status of the tag. |
| tagware |
Wildlife Computers specific. The tag firmware/software version number. |
| tk0 |
Unique ID serial primary key field. |
| trade_date |
If the tag was traded between owners on what date did the trade take place? |
| trade_owner |
If the tag was traded between owners who is the new owner? |
| trade_tag |
If the tag was traded between owners what tag was it traded for? |
| warranty_denied |
Was warranty replacement denied for this tag? |
| warranty_replaced |
Was the tag replaced under warranty? |
| warranty_requested |
Was a warranty replacement requested for this tag? |