Extend field length for Project_Ref_Id (4.4.1) and 1.14 2nd November 2012 Reference_Nr (4.6.1) fields to accommodate imported McIlwraith characters Remove Project No from Other Customer Order in 1.15 9nd November 2012 McIlwraith Order Detail extract Extend to include Work type Master extract and Work Type in Project View and Order Details extracts. 2.0 02nd January 2013 Trish McIlwraith Review and tidy up of all extracts. Include Contract & Milestone extracts 2.1 08th January 2013 Inclusion of Metadata and App Survey extracts Trish McIlwraith 2.2 14h January 2013 Revision after feedback from Marcus & Ian Trish McIlwraith Inclusion of Supplier Operations user into Order Details 2.3 30h January 2013 Trish McIlwraith extract 2.4 13th February 2013 Inclusion of Attribute Details extract Trish McIlwraith 2.5 21st February 2013 Inclusion of Refuse Master extract Trish McIlwraith 2.6 14th March 2013 Changes after review from the customer Trish McIlwraith Update Include Docket Dates on Invoices, – Compliance expiry date, Interface flag on Orders & PV, 2.7 14th May 2013 McIlwraith Document extract, Survey Action extract, column name changes Include additional column in App Survey Extract. 2.8 9th June 2013 Rename Order Master’ to Order McIlwraith ‘Refused ‘Removed Master’. Clarify file creation and naming conventions Change SOR Master to SOR Detail extract, Modify 2.9 2nd July 2013 Primary key definition in Compliance Document Trish McIlwraith Master extract to ensure uniqueness Minor changes to file naming convention, changes to 2.10 7th October 2013 mandatory nature of some fields, Extended code set Trish McIlwraith for new PV status codes Update Code lists. Separate Address Location in Order Details extract into different fields. Update Milestone 3.0 28th February 2014 McIlwraith status table, Milestone Details extract and introduce Milestone History extract Inclusion of GST & Auditable on SOR extract. 3.1 18th 2014 Trish McIlwraith Inclusion of Records’ extract ‘Deleted Inclusion of Effective From and Effective To in SOR 3.2 25th March 2014 extract; supplier company number in invoice details Trish McIlwraith extract 3.3 16th May 2014 Removed Id from Milestone History extract McIlwraith
1.14 2nd November 2012 Extend field length for Project_Ref_Id (4.4.1) and Reference_Nr (4.6.1) fields to accommodate imported characters McIlwraith 1.15 9nd November 2012 Remove Project No from Other Customer Order in Order Detail extract McIlwraith 2.0 02nd January 2013 Extend to include Work type Master extract and Work Type in Project View and Order Details extracts. Review and tidy up of all extracts. Include Contract & Milestone extracts Trish McIlwraith 2.1 08th January 2013 Inclusion of Metadata and App Survey extracts Trish McIlwraith 2.2 14h January 2013 Revision after feedback from Marcus & Ian Trish McIlwraith 2.3 30h January 2013 Inclusion of Supplier Operations user into Order Details extract Trish McIlwraith 2.4 13th February 2013 Inclusion of Attribute Details extract Trish McIlwraith 2.5 21st February 2013 Inclusion of Refuse Master extract Trish McIlwraith 2.6 14th March 2013 Changes after review from the customer Trish McIlwraith 2.7 14th May 2013 Update – Include Docket Dates on Invoices, Compliance expiry date, Interface flag on Orders & PV, Document extract, Survey Action extract, column name changes McIlwraith 2.8 9th June 2013 Include additional column in App Survey Extract. Rename ‘Refused Order Master’ to ‘Removed Order Master’. Clarify file creation and naming conventions McIlwraith 2.9 2nd July 2013 Change SOR Master to SOR Detail extract, Modify Primary key definition in Compliance Document Master extract to ensure uniqueness Trish McIlwraith 2.10 7th October 2013 Minor changes to file naming convention, changes to mandatory nature of some fields, Extended code set for new PV status codes Trish McIlwraith 3.0 28th February 2014 Update Code lists. Separate Address Location in Order Details extract into different fields. Update Milestone status table, Milestone Details extract and introduce Milestone History extract McIlwraith 3.1 18th 2014 Inclusion of GST & Auditable on SOR extract. Inclusion of ‘Deleted Records’ extract Trish McIlwraith 3.2 25th March 2014 Inclusion of Effective From and Effective To in SOR extract; supplier company number in invoice details extract Trish McIlwraith 3.3 16th May 2014 Removed Id from Milestone History extract McIlwraith
ConSol_Datamart_Specification_v6.0.docx