Jul 14, 2014

Data Load Notification Enhancements

Enhancements to the Tag Data Load (TDL) process were rolled out on June 19 and July 11, 2014. Most of the changes were designed to improve efficiency and long-term maintainability. However, data contributors will see that notifications emails have been improved, as well.

Notification emails now show the file name and the status of the load attempt (Failed, Loaded, or Loaded with duplicates) in the subject of the email. For those files that fail, the descriptions of the reason for failing have been clarified. For those files that are loaded successfully, the notifications now include a summary of what was loaded into PTAGIS from that file. The summary shows the number of records that were inserted, updated, removed and disowned. If a file contains duplicate records, those tag codes are listed. An example of the tag file load notification summary is shown below:

Summary of Records Loaded
Data Rows:20
Mark Records Inserted:0
Mark Records Updated:10
Mark Records Disowned:10
Recap Records Inserted:0
Recap Records Updated:0
Recap Records Deleted:0
Mort Records Inserted:0
Mort Records Updated:0
Mort Records Deleted:0
Dupe Records Inserted:5
Dupe Records Updated:0
Dupe Records Removed:0
DotOut Records:5 

Duplicate Tag Codes:
3D9.1C2DAFBED3
3D9.1C2DAFC4EA
3D9.1C2DAFD415
3D9.1C2DAFE8A4
3D9.1C2DB001F1

Definitions:
Data Rows - number of detail records in the tag file.

Mark Records Inserted: number of records that were loaded as new mark events.

Mark Records Updated: number of previously loaded mark records that were updated by the information in this file. Disowned and orphaned records can be updated by any tag file. Mark records can only be updated by the current file if they were initially loaded in a file of the same name.

Mark Records Disowned: number of previously loaded mark records that were dotted out, removed, or changed to recap or mort records in this version of the file.

​Recap Records Inserted: number of records that were loaded as new recapture events.

Recap Records Updated: number of previously loaded recap records that were updated by the information in this file.

Recap Records Deleted: number of previously loaded recap records that were dotted out, removed, or changed to mark or mort records in this version of the file.

Mort Records Inserted: number of records that were loaded as new mortality events.

Mort Records Updated: number of previously loaded mort records that were updated by the information in this version of the file.

Mort Records Deleted: number of previously loaded mort records that were dotted out, removed, or changed to mark or recap records in this version of the file.

​Dupe Records Inserted​: number of records that were loaded as new duplicate mark records. A duplicate record is created if a tag code submitted as a mark event already exists as a mark record and is not orphaned or disowned.

Dupe Records Updated: number of previously loaded duplicate records that were updated by the information in this version of the file.

Dupe Records Removed: number of previously loaded duplicate records that were dotted out, removed, or changed to mark, recap, or mort records.

DotOut Records: number of detail records in the tag file that contain 10 dots in place of a PIT tag code.