Sep 2025 Production Version 4 vs Sep 2025 Production Version 5 Production package

*** HAD TO RUN LOCALLY AS PCR DOESN’T WORK WITH VET EXTENSION AT PRESENT ***

CONCLUSION:  Changes as expected:

• moduleDependency files:

  • 2 records had their UUID’s ONLY updated, as expected

• Files had their names changed, in line with new Release File Spec changes:

  • < ./der2_cRefset_AssociationReferenceFull_INT1000009_20250930.txt

  • > ./der2_cRefset_AssociationFull_INT1000009_20250930.txt

  • < ./der2_cRefset_AssociationReferenceSnapshot_INT1000009_20250930.txt

  • > ./der2_cRefset_AssociationSnapshot_INT1000009_20250930.txt

  • < ./der2_Refset_SimpleRefsetFull_INT1000009_20250930.txt

  • > ./der2_Refset_SimpleFull_INT1000009_20250930.txt

  • < ./der2_Refset_SimpleRefsetSnapshot_INT1000009_20250930.txt

  • > ./der2_Refset_SimpleSnapshot_INT1000009_20250930.txt

• Readme file has text added that Julie requested - see her email at 13:17 on Sep 26, 2025

Sep 2025 Production Version 3 vs Sep 2025 Production Version 4 Production package

*** HAD TO RUN LOCALLY AS PCR DOESN’T WORK WITH VET EXTENSION AT PRESENT ***

CONCLUSION:  Changes as expected:

• moduleDependency files:

  • 2 records had their UUID’s ONLY updated, as expected

• Relationship files:

  • 3x erroneous records (found to be from the original Delta file used to provision the Extension branch, which was spun up quickly by importing all the data from the previous VET Extension (from 2014-2019), some of which was invalid!) were removed, in order to allow for Publishing in the RAD (see IDS-37):

  • < 900000000000723025 20250930 0 332351000009108 32291000009106 5261000 2 363698007 900000000000011006 900000000000451002

  • < 900000000000723026 20250930 0 332351000009108 32291000009106 360499006 3 363698007 900000000000011006 900000000000451002

  • < 900000000000723070 20250930 0 332351000009108 350761000009107 55199003 3 116676008 900000000000011006 900000000000451002

Sep 2025 PreProduction Version 34 vs Sep 2025 Production Version 3 Production package

*** HAD TO RUN LOCALLY AS PCR DOESN’T WORK WITH VET EXTENSION AT PRESENT ***

CONCLUSION:  Changes as expected:

• refsetDescriptor files:

  • 17 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• AttributeValue files:

  • 5533 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Association Refset files:

  • 3823 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• moduleDependency files:

  • 2 records had their UUID’s + their dates updated to the new versioned date of 20250930, as planned

• Concept files:

  • 37,374 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Description EN files:

  • 102,449 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Description ES files:

  • 1410 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Description IT files:

  • 1916 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Relationship files:

  • 62,672 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• OWLAxiom files:

  • 35,882 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Language EN files:

  • 167,532 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Language ES files:

  • 1444 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Language IT files:

  • 1796 records had ONLY their dates updated to the new versioned date of 20250930, as planned

• Readme file as expected:

  • All dates changed to new effectiveTime, BUT number of files remains identical , as expected

Sep 2025 PreProduction Version 33 vs Sep 2025 PreProduction Version 34 Production package

CONCLUSION:  Changes as expected:

• 6x duplicate RefsetDescriptor records removed as planned:

  • < 23a27b2a-70e5-4c0d-92fd-8eaf4736d938    20250601    1    332351000009108    900000000000456007    332801000009103    447257003    900000000000460005    2

  • < 572870af-de9e-4b0b-a3ff-53ffe96f0234    20250601    1    332351000009108    900000000000456007    332881000009105    449608002    900000000000460005    0

  • < 63e02635-a4d3-4324-b1bd-f631afc882f7    20250601    1    332351000009108    900000000000456007    332801000009103    447255006    900000000000478000    1

  • < 73324695-d962-49e8-b98e-3f72081a4f41    20250601    1    332351000009108    900000000000456007    332881000009105    447257003    900000000000460005    2

  • < abdf2a08-13a3-4601-8ba5-0e9c90c322bb    20250601    1    332351000009108    900000000000456007    332801000009103    449608002    900000000000460005    0

  • < d1016995-7fe9-4cb1-9d1f-c26030c19d5e    20250601    1    332351000009108    900000000000456007    332881000009105    447255006    900000000000478000    1

• MDRS records had their UUID's updated as expected

Sep 2025 PreProductionVersion 27 vs Sep 2025 PreProduction Version 33 Production package

CONCLUSION:  Changes as expected:

• 2x MDRS records added back in as planned:

  • > 2c24ba0b-83da-4da9-be9c-88fb7c9eda55    20250601    1    332351000009108    900000000000534007    900000000000012004    20250601    20250201
    > d80602db-a739-4784-97e2-fa70d7892654    20250601    1    332351000009108    900000000000534007    900000000000207008    20250601    20250201

• STILL AWAITING RDA TO DELETE ERRONEOUS RefsetDescriptor DUPES FROM THE VET25 PROJECT

  • ONCE CONFIRMED NEED TO REBUILD AND ENSURE ONLY THE ORIGINAL 14x RECORDS (+ maybe 3x NEW RECORDS FOR NEW REFSET THEY JUST ADDED IN - 332831000009106)

Sep 2025 PreProduction Version 19 to Sep 2025 PreProduction Version 27 traceability

CONCLUSION:  Changes as expected:

• moduleDependency has 2x records DELETED, NOT as expected

  • id    effectiveTime    active    moduleId    refsetId    referencedComponentId    sourceEffectiveTime    targetEffectiveTime
    cafae406-847b-4942-9540-0d4119d311f8    20250707    1    332351000009108    900000000000534007    900000000000207008    20250707    20250701
    5793661f-b21e-4466-83f7-052757010fd2    20250707    1    332351000009108    900000000000534007    900000000000012004    20250707    20250701

  • THIS IS LIKELY TO BE BECAUSE WE HAVEN'T UPDATED THE EXTERNALLYMAINTAINED INPUT FILE THOUGH WITH THE NEW EFFECTIVETIME!!!

• Some refsetDescriptor records DUPLICATED???  (BUT WITH NEW UUID'S)     Perhaps as a result of the date change???

  • (eg)

    • abdf2a08-13a3-4601-8ba5-0e9c90c322bb    20250601    1    332351000009108    900000000000456007    332801000009103    449608002    900000000000460005    0

    • 51ed8298-29a1-4612-b65c-f636c697aaa2    20250601    1    332351000009108    900000000000456007    332801000009103    449608002    900000000000460005    0

  • INVESTIGATION:

    • Confirmed the duplicate records are coming out of VET25 - 

      • possibly because RDA re-used the project?

      • possibly because he versioned SOME of content but not all?? (I'm running UNPUBLISHED) -

        • BUT HE DIDN'T SAY HE WAS GOING TO VERSION ANY OF IT????

• Concept files:

  • 3820 removed + 37374 added, so seems about right as compared to Julie’s expectations in her email from 15/07/2205 at 20:37

• Description EN files:

  • 102,449 removed + 102,449 added, so seems about right in total (all Description records totalled up) as compared to Julie’s expectations in her email from 15/07/2205 at 20:37

• Description ES files:

  • 1410 removed + 1410 added, so seems about right

• Description IT files:

  • 1916 removed + 1916 added, so seems about right

• Relationship files:

  • 62,659 removed + 62,672 added, so seems about right as compared to Julie’s expectations in her email from 15/07/2205 at 20:37

• OWLAxiom files:

  • 35,882 removed + 35,882 added, so seems about right

• Association files:

  • 37374 removed + 37374 added, so seems about right

• AttributeValue files:

  • 5533 removed + 5522 added, so seems about right

• Language EN files:

  • 166,869 removed + 167,532 added, so seems about right

• Language ES files:

  • 1444 removed + 1444 added, so seems about right

• Language IT files:

  • 1796 removed + 1796 added, so seems about right

• Readme file as expected:

  • All dates changed to new effectiveTime, BUT number of files remains identical , as expected