Full UOW

Full UOW processing examines timestamps in the source UOW tables to determine which records have changed since the last Full UOW or Full Reload processing job and creates an execution set for those records' UOW key (subject or subject visit) and no others. It inserts, updates, and refreshes all records belonging to subjects or subject visits in the execution set and no others. However, if the program has never been run in any mode, all units of work are included in the execution set. If records previously existed in the target tables it also deletes records:

• Records in processed units of work (subject or subject visit) that are not reloaded are deleted.

• Entire units of work are deleted if they exist in the target table but are not reloaded.

  For example, if a transformation reads from an Adverse Event table and writes to a Severe Adverse Events table and has previously inserted records with a Serious flag set to Y for a particular subject, a change to the Serious flag to N for all of a subject's records results in no records being inserted and, since the subject is in the UOW execution set, the deletion of all records for that subject from the target.