L TmpV2 multi-entry clean-up

Some of the entries in L_TmpV2 were set up to be sent before the patient was complete/sent. They were sent with a date with the assumption that eventually only the last entry would be used. During Overstay it was discoverd that the last entry is not always the best, since sometimes we explicitly want early impressions.

When we do the 2013 data upgrades we will automatically move to a system where only the final impression is kept. To do this the entries in L_Tmpv2 need to be reconciled. This article describes how.

Proposal

I would like to eliminate from L_TmpV2 all entries that don’t have the latest available sent-date for a given patient-ward-stay. Ttenbergen 13:24, 2014 March 12 (CDT) We would keep a copy of the last pre-cleaning version of L_TmpV2, like of all other files finalized in 2013 Data Upgrades.

• Overstay 2 lines or more per patient for this patient being displayed in patient list. Also for a number of others
  • this is probably when there are multiple records in L_tmpv2 and I have not reconciled picking only the last one... Ttenbergen 13:49, 2014 February 13 (CST)
    • email ("reconciling Tmp to only last record") to Julie to confirm that using last only is acceptable Ttenbergen 10:50, 2014 February 26 (CST)
      • Julie mentioned that some projects have more than one entry per patient-ward stay, so I undated proposal to "I would like to eliminate from L_TmpV2 all entries that don’t have the latest available sent-date for a given patient-ward-stay." and emailed Julie to find out if that should be OK. Ttenbergen 13:24, 2014 March 12 (CDT)