3.4 29th August 2014 Corrections to text McIlwraith Inclusion of IntegralPLUS related fields PMO_NR and 3.5 25th September 2014 Hamish Goddard OP_NR to extracts 3.6 26th September 2014 Correction to PMO_NR label Hamish Goddard Convert SOR to History extract and changes to SOR 3.7 24th February 2015 Trish McIlwraith extract (p33). Convert Deleted Events extract from Master to (p 3.8 24th March 2015 Trish McIlwraith 30) Update to Datamart services and inclusion of SLAs no – 3.9 15th July 2015 McIlwraith change to extracts (p7) Inclusion of Geo-cordinates in Order Details extract and Order Invoice History extract. Inclusion of Used Qty in the Order Item details extract. McIlwraith, 4.0 24th September 2015 Hamish Goddard Inclusion of new BASELINE_DATE field and change name of TARGET_DATE to FORECAST_DATE in Milestone Details delta extract. Removed section 2.10 Service Level Agreement Hamish Goddard, 4.1 8 October 2015 (redundant). Changes to Milestone Details and Norval Hope Milestone Type extracts. Order Invoice History extract changes: Removal of field ‘Subtype’ 4.2 5 November 2015 Hamish Goddard GPS longitude and latitude field positions reordered Extension of document history extract field FORM_ID 4.3 28 February 2017 Hamish Goddard from 8 to 16 characters Introduction of Claim History extract Introduction of Batch Job extract. Extended length of Attribute Name in Attribute Master extract Extend length of Special Instructions in Order Details extract 5.0 14 June 2017 Trish McIlwraith Extend Contract Details extract to identify method of invoicing and contract category Multiple changes to Document History extract Apply filter to Datamart processor to remove characters Introduce to Order Invoice History ‘Sequence’ extract
3.4 29th August 2014 Corrections to text McIlwraith 3.5 25th September 2014 Inclusion of IntegralPLUS related fields PMO_NR and OP_NR to extracts Hamish Goddard 3.6 26th September 2014 Correction to PMO_NR label Hamish Goddard 3.7 24th February 2015 Convert SOR to History extract and changes to SOR extract (p33). Trish McIlwraith 3.8 24th March 2015 Convert Deleted Events extract from Master to (p 30) Trish McIlwraith 3.9 15th July 2015 Update to Datamart services and inclusion of SLAs – no change to extracts (p7) McIlwraith 4.0 24th September 2015 Inclusion of Geo-cordinates in Order Details extract and Order Invoice History extract. Inclusion of Used Qty in the Order Item details extract. Inclusion of new BASELINE_DATE field and change name of TARGET_DATE to FORECAST_DATE in Milestone Details delta extract. McIlwraith, Hamish Goddard 4.1 8 October 2015 Removed section 2.10 Service Level Agreement (redundant). Changes to Milestone Details and Milestone Type extracts. Hamish Goddard, Norval Hope 4.2 5 November 2015 Order Invoice History extract changes: Removal of ‘Subtype’ field GPS longitude and latitude field positions reordered Hamish Goddard 4.3 28 February 2017 Extension of document history extract field FORM_ID from 8 to 16 characters Hamish Goddard 5.0 14 June 2017 Introduction of Claim History extract Introduction of Batch Job extract. Extended length of Attribute Name in Attribute Master extract Extend length of Special Instructions in Order Details extract Extend Contract Details extract to identify method of invoicing and contract category Multiple changes to Document History extract Apply filter to Datamart processor to remove characters Introduce ‘Sequence’ to Order Invoice History extract Trish McIlwraith
ConSol_Datamart_Specification_v5.1.docx