IM Relationship Resolution Information Center, Version 4.2

Net change utility action flags

When net change utility compares records it adds a one-character instruction (action flag) to the first position of each record in the difference (.diff) output file.

As part of processing, net change utility automatically adds the following data to each record:

Added Data Definition
Action Flag One character, at the beginning of the record
AddDate Date the record is added, at the end of the record
ModDate Date the record is modified, at the end of the record
SeenDate Date the record is last seen, at the end of the record
NCEID Sequential unique 34-character ID for every record in the database, at the end of the record
Table 1 defines the action flags that the net change utility uses.
Table 1. Net Change Utility action flags
Action Flag Description Determining Factor Action
A Add The key/criteria do not exist in the Base File. Record marked and moved to the Difference File.
C Change The key is the same but the criteria are different. Record marked and moved to the Difference File.
D Delete The key does not exist in the new incoming file. Record marked and moved to the Difference File
  • Optional flag, turned on with a switch.
  • Created only in a full comparison.
  • Because the incoming file becomes the new Base File, a record that does not exist in the incoming file will not exist when that file becomes the new base file.
S Seen A record is marked "seen" if the key and the criteria for the incoming record are the same as a previous record in the incoming file. Seen records are ignored. Record marked "seen" and moved to the Difference File
  • You must decide you want to use "seen" and set an optional flag, turned on with a switch.
  • If you have a need to use the duplicate records, use this flag.


Feedback

Last updated: 2009