November 2021 PREPRODUCTION (Version
56) vs November 2021
PREPRODUCTIONPRODUCTION (Version
61) traceability
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| .JSON file | n/a | Removed the Member Release warning, as this is the final production release | RefsetDescriptor files | 9 | 9 new records had their UUID's refreshed, as expected | SimpleMap files | 3559 | 3559 records refreshed with new UUID's as expected, due to final number of January 2021 concept changes after last minute vaccines changes and other fixesNot populating the Language Refset fields as expected! However, as it looks like this has been broken for a few cycles now, I'm opening up a ticket to fix it urgently (
| ||||||||||
| SimpleMap files | 548 | 548 records had their UUID's updated as expected, as this matches exactly the number of records added for CTV3 (900000000000497000) as part of the normal authoring cycle updates, exported from the termServer | ||||||||||||||||
| Readme file | n/a | All x prefixes removed, and Package naming convention updated to Production, as expected. |
October 2021 PRODUCTION (PUBLISHED) to November 2021 PREPRODUCTION (Version 6) traceability
SUMMARY COMPONENT REPORT: https://docs.google.com/spreadsheets/d/1WPmrSuS3cXNN3OLkYe8NW0vp9lUGmb4opP2Tcyshw3w/edit#gid=0
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| RefsetDescriptor files |
9 records added for new expression refsets as expected - see email from Linda + Kai at 02:37 on
> 0aee0539-4dab-4ece-ba63-df08a347fb2c 20210131 1 900000000000012004 900000000000456007 1119417006 449608002 1119460002 0
> 1d472f20-d375-4b15-bccb-fff42ae145ce 20210131 1 900000000000012004 900000000000456007 1119468009 449608002 1119460002 0
> 29d8e58d-ed48-46f9-ad3f-ba1f4f01302e 20210131 1 900000000000012004 900000000000456007 1119468009 1119454002 1119437005 1
> 673ec076-149d-4df0-9bb0-9faac6479377 20210131 1 900000000000012004 900000000000456007 1119435002 1119436001 1119437005 1
> 74023db2-c222-475f-a97f-3a98250e5d04 20210131 1 900000000000012004 900000000000456007 1119417006 1119456000 1119461003 2
> 8f6aa174-31a6-471f-af95-1418194ed6e0 20210131 1 900000000000012004 900000000000456007 1119435002 733616009 1119461003 2
> c5e6e15c-97c5-4a74-ac82-a432590e3cb7 20210131 1 900000000000012004 900000000000456007 1119468009 1119457009 1119461003 2
> f09f2c8a-2007-4226-9df6-e5fcb20edb1e 20210131 1 900000000000012004 900000000000456007 1119417006 1119454002 1119437005 1
> f61db339-44bd-498b-90ca-a2c47b2a4b16 20210131 1 900000000000012004 900000000000456007 1119435002 449608002 1119460002 0
0 changes as expected | |||
| Concept files | 909 | 151 |
152 new records
plus 17 inactivated records
As expected as matches Yong's intentions, which he sent in email at 16:29 on ...
Which again matches the 169 records in the Delta file downloaded from the Refset Tool...
records updated, plus |
210 records inactivated, plus |
548 records added, ...as expected as the |
...plus the updated total (1901) matches exactly with the total records in the Concepts Changed report (5413): https://docs.google.com/spreadsheets/d/1QhxK1cja523C8CADBK75wzJ4qeXgIKSOfxgSPCR6E8g/edit#gid=0
MINUS the total number of inactivations (3512) - therefore 5413-3512 = 1901totals match exactly with Summary Component Stats report (linked above) (plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on ) |
| Description files |
| 2874 |
98 records updated, plus |
495 records inactivated, plus |
2281 records added ...as expected as the |
totals ALMOST match exactly |
with Summary Component Stats report (linked above) ****** THE PROBLEM HERE IS THAT MY COMPARISON REPORTS USE THE ">" and "<" symbols, which are also present in nearly 3000 Descriptions themselves! Therefore MY TOTALS are definitely wrong! We therefore have to trust the reports from now on.. (plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on ) |
| Relationship files |
| 10892 |
356 records updated, plus |
3681 records inactivated, plus |
6855 records added ...as expected as the |
totals match exactly with Summary Component Stats report (linked above) (plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on ) |
| Relationship Concrete Values files |
| 43 |
0 records updated, plus |
1 records inactivated, plus |
42 records added ...as expected as |
the totals match exactly with the Summary Component Stats report (linked above) (plus confirmed by Maria/Yong to be as expected in email trail at 07:31 + 17:24 on + ) | |||
| OwlExpression files | 2923 | 2281 records updated, plus 212 records inactivated, plus 430 records added ...as expected as the totals match exactly with Summary Component Stats report (linked above) (plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on ) | |
| Stated Relationship files | 0 | 0 records updated, plus 0 records inactivated, plus 0 records added As expected due to full migration to OWLExpression file in the last July 2019 International Edition | |
| TextDefinition files |
| 104 | 0 records updated, plus |
9 records inactivated, plus |
95 records added ...as expected as the |
totals ALMOST match exactly |
with Summary Component Stats report (linked above) ****** THE PROBLEM HERE IS THAT MY COMPARISON REPORTS USE THE ">" and "<" symbols, which are also present in nearly 20 Text Definitions themselves! Therefore MY TOTALS are definitely wrong! We therefore have to trust the reports from now on.. (plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on ) |
| SimpleMap files |
| 568 | 0 records updated, plus |
4 records inactivated for ICD-0 (446608001) |
, as expected, matching the 4 inactivation records in the Delta from mapping tool + the figures in the icd0stats.txt file from WCI. 564 records added, as expected as: |
|
|
|
| ExtendedMap files |
| 529 |
0 records updated, plus |
98 records inactivated, plus |
431 records added, as expected from |
the 431 additions + |
98 inactivations + |
0 updates in the ICD-10 map (449080006) Delta file that WCI sent us from the mapping tool export + NOT the figures in the icd10stats.txt file from WCI (WHICH CANNOT CURRENTLY BE USED FOR VALIDATION PURPOSES DUE TO THE EXTENDED MAP ALLOWING MULTIPLE MAP RECORDS PER CONCEPT, AND US ONLY BEING ABLE OT VALIDATE NUMBER OF MAP RECORDS (not number of concepts) ADDED/INACTIVATED IN THIS CYCLE - HAVE ASKED RICK HOW EASY IT'D BE TO UPDATE THE REPORT TO INCLUDE THESE STATS INSTEAD OF/AS WELL AS THE CURRENT Concept level STATS.... |
| Simple Refset files |
| 84 | 0 records updated, plus |
30 records inactivated, plus |
54 records added, as expected from the Lateralizable Refset changes (723264001) that Yong made in this cycle, exported in a Delta file from the Refset tool |
SENT LATERALIZABLE CHANGES TO PETER + YONG ON 18/11 FOR REVIEW in Yong finally signed off content on 23/11/2021 in the FRI-317 ticket: "Hi Andrew Atkinson, I have run my scripts and the results are the same (30 inactivations and 54 new records). Cheers, Yong" Yong to run his local scripts to cross check 2x final times (December + January) to ensure still matching and no more edge cases - if so we can finally move to the new automated solution with no manual cross checks required | ||||||||
| ModuleDependency files | 3 | 3 records updated, as expected for |
November 2021 effectiveTimes |
| Readme file |
November 2021 dates updated + Beta "x" prefixes added, as expected |
| Association Reference files |
| 850 |
2 new records added:
> 02f30651-d535-40d1-83be-3e73bacb0c20 20210131 1 900000000000012004 723561005 320081000221109 373873005 0 0..1 0..0 723597001 723596005
> 5c0fcb70-c87f-4058-9ee5-02d3756faace 20210131 1 900000000000012004 723561005 320091000221107 373873005 0 0..1 0..0 723597001 723596005
as confirmed by Maria/Yong to be as expected in email trail at 12:18 on
2 records added, plus
> 47eced5c-af89-41ec-95a4-cbcb992438c3 20210131 1 900000000000012004 723562003 320081000221109 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 320081000221109 |Unit of presentation size quantity| = < 260299005 |Number (qualifier value)| 723597001 723596005
> 5c1e3361-3410-460e-87e3-3c8b76e00c39 20210131 1 900000000000012004 723562003 320091000221107 << 767524001 |Unit of measure (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 320091000221107 |Unit of presentation size unit| = << 767524001 |Unit of measure (qualifier value)| 723597001 723596005
3 records updated:
< 3385133c-0886-4c6f-9e6d-2f1d216c9f91 20170731 1 900000000000012004 723562003 370133003 << 105590001 |Substance (substance)| << 123038009 |Specimen (specimen)|: [0..*] { [0..1] 370133003 |Specimen substance| = << 105590001 |Substance (substance)| } 723597001 723596005
> 3385133c-0886-4c6f-9e6d-2f1d216c9f91 20210131 1 900000000000012004 723562003 370133003 << 105590001 |Substance (substance)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)| << 123038009 |Specimen (specimen)|: [0..*] { [0..1] 370133003 |Specimen substance| = (<< 105590001 |Substance (substance)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)|) } 723597001 723596005
< adbbf064-83a0-4125-85a5-6409dc352888 20200731 1 900000000000012004 723562003 370130000 << 118598001 |Property of measurement (qualifier value)| (<< 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|): [0..1] { [0..1] 370130000 |Property| = << 118598001 |Property of measurement (qualifier value)| } 723597001 723596005
> adbbf064-83a0-4125-85a5-6409dc352888 20210131 1 900000000000012004 723562003 370130000 << 118598001 |Property (qualifier value)| (<< 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|): [0..1] { [0..1] 370130000 |Property| = << 118598001 |Property (qualifier value)| } 723597001 723596005
< f58d75aa-599a-42e7-9f35-31a9c8a7d6d9 20200131 1 900000000000012004 723562003 246501002 << 272394005 |Technique (qualifier value)| OR << 273249006 |Assessment scales (assessment scale)| << 363787002 |Observable entity (observable entity)|: [0..*] { [0..1] 246501002 |Technique| = (<< 272394005 |Technique (qualifier value)| OR << 273249006 |Assessment scales (assessment scale)|) } 723597001 723596005
> f58d75aa-599a-42e7-9f35-31a9c8a7d6d9 20210131 1 900000000000012004 723562003 246501002 << 254291000 |Staging and scales (staging scale)| OR << 272394005 |Technique (qualifier value)| << 363787002 |Observable entity (observable entity)|: [0..*] { [0..1] 246501002 |Technique| = (<< 254291000 |Staging and scales (staging scale)| OR << 272394005 |Technique (qualifier value)|) } 723597001 723596005
6 records updated, plus 128 records inactivated, plus 716 records added This includes:
SENT SEP CHANGES TO PETER + YONG ON 18/11 FOR REVIEW in ...as expected as the totalsALMOSTmatch exactly with total of all Inactivation Reasons in the "Refsets" tab in the Summary Component Stats report (linked above) Yong finally signed off content on 23/11/2021 in the FRI-299 ticket: "HiAndrew Atkinson, I have run my scripts and the changes for the SEP refset and Laterality are covered by the latest Pre-prod version of the November release. So, these refsets are ready for release. Yong to run his local scripts to cross check 2x final times (December + January) to ensure still matching and no more edge cases - if so we can finally move to the new automated solution with no manual cross checks required | |||||||||
| Attribute Value files | 1524 | 30 records updated, plus 82 records inactivated, 1412 records added ..as expected as the totals ALMOST match exactly with total of Description Inactivation Indicators (900000000000490003) + Concept Inactivation Indicators (900000000000489007) in the "Refsets" tab in the Summary Component Stats report (linked above) |
5 records updated, plus
0 inactivated, plus
0 new record added
As confirmed by Maria/Yong to be as expected in email trail at 12:18 on
2 records updated, plus
4488 records inactivated, plus
8301 records added
...as expected as the added (8301) + inactivated (4488) + updated (2) totals ALMOST match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1-XU7byTRnBJUYaDhvlXdzFpHlFxDV746o5F2Msa1Olk/edit#gid=0
Yong confirmed that this is not quite what he expected in email trail at 12:18 on inactivation for the 734138000|Anatomy structure and entire association reference set (foundation metadata concept)|
4791 records updated, plus
3186 records inactivated,
29298 records addedAs confirmed by Maria/Yong to be as expected in email trail at 12:18 on |
| Language refset files |
| 5891 |
351 records updated, plus |
992 records inactivated, plus |
4548 records added ...as expected as |
the |
totals match exactly with Summary Component Stats report (linked above) As confirmed by Maria/Yong to be as expected in email trail at 12:18 on |
November 2021 PREPRODUCTION (Version 5) vs November 2021 PREPRODUCTION (Version 6) traceability
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| All files | n/a | 0 changes as expected |