Move TID 10006 & 7 data from TID 10004 table

Issue #160 resolved
Ed McDonagh created an issue

Refs issue #159 - see that issue for details.

Create a routine to move all data in the additional fields in Accumulated_projection_xray_dose that have been removed in the current standard into the newer Accumulated_cassette_based_projection_radiography_dose and Accumulated_integrated_projection_radiography_dose tables.

Comments (11)

  1. Ed McDonagh reporter

    Changed dxdetail to refer to accumintegratedprojradiogdose for the total DAP rather than the accumprojxraydose table. Works with dx imported after previous commit, but currently data won't exist for dx already in the database (refs #160). Refs #159 Also added DAP unit conversion to the AccumIntegratedProjRadiogDose class.

    → <<cset 10581d5a7746>>

  2. Ed McDonagh reporter

    Changed dxfiltered to refer to accumintegratedprojradiogdose for the total DAP rather than the accumprojxraydose table. Works with dx imported after previous commit, but currently data won't exist for dx already in the database (refs #160). Refs #159

    → <<cset c5631d0dfa2b>>

  3. Ed McDonagh reporter

    Changed dxfiltered and dxdetail to refer to accumintegratedprojradiogdose for the number of exposures rather than counting the number of event items. Works with dx imported after previous commit, but currently data won't exist for dx already in the database (refs #160). Refs #159

    → <<cset afe771f597c5>>

  4. Ed McDonagh reporter

    Changed rffiltered and rfdetail to refer to accumintegratedprojradiogdose for the Total DAP and Total reference point dose. Refs #159. Works with existing rf imported from Siemens RDSR as the data has been imported into both tables. Therefore we won't need to do a data migration for this (refs #160). Edited rdsr extractor to group the items that should only be in 10007 that are also imported to 10004. These should be removed at some point. Also removed an unused import (ContextID) and corrected the import of AccumProjXRayDose.

    → <<cset 0fba7bbdc3cd>>

  5. Ed McDonagh reporter

    Changed dx export (xlsx and csv) to refer to accumintegratedprojradiogdose for the Total DAP and number of exposures. Refs #159. Works with new imports, crashes on existing studies, a data migration required to fix this (refs #160).

    → <<cset af86328d3778>>

  6. Ed McDonagh reporter

    Fixes #159. Data migration still required ref #160. Needs further testing. Code populating template 10004 in the rdsr extractor has not been removed yet, but doesn't hurt! Should be removed later.

    → <<cset 19e8c4527ca8>>

  7. Ed McDonagh reporter

    Hopefully fixed problem of creating AccumIntegratedProjRadiogDose objects - migration ran without any errors. However, no data was transferred - or maybe just not saved! Refs #160

    → <<cset 07f1681cbabc>>

  8. Log in to comment