Extracting data

This section outlines the changes to the Extracting data manual arising from changes made to Synergetic (version 59.15-v60.37).

Change	More information	See
Views available for use.	The introduction has been updated and two new topics have been added, listing the main views available: Main Synergetic views Main Finance views.	Extracting data from the Synergetic database Synergetic views Main Synergetic views Main Finance views
New views added.	Descriptions have been included for the following views, which were added recently: vxeOliverBorrowingExport vStudentRelationsAll vNZMOE_StudentDataChanges vStudentContactsLivesWith vNZMOE_eAR_SchoolDetails vStudentParentsMCEETYA vStudentAbsenceEvents vStudentAbsenceEventsAttendances vStudentMedicalDetails Fields in the following views have been changed or added but no specific information has been included in the documentation: vCommunityAddresses vCommunityAddressesConstit vDebtorFees vStudentMedDetailsPrimContact vStudentsCurrentPastFutureCombined vStudentContactAddress Absences vStudentReportsSemesterResults vStaffTimetableFull vStudentClassesAll pvStudentAssessmentMarkbookAreas vTimetableRooms vCreditorTransactions pvPayrollEmployeeLeaveEntitleAll vPayrollEmployeeLeaveSummary	Main Synergetic views
Updated topics.	Additional screen captures have been included to: improve the readability of the examples provide updated information for a later release of Microsoft Excel (2003).	Extracting data using the Microsoft Query wizard Extracting student name and contact details example Editing a Microsoft Query using the wizard Extracting student name and contact details example
New topics.	New topics have been included to provide information on using stored procedures to retrieve Synergetic data. Examples are provided for developing mail merge letters.	Using stored procedures to retrieve Synergetic data Creating mail merge letters using stored procedures Printing mail merge letters using an existing document Reprinting mail merge letters