New single database structure.

The Synergetic suite has been updated to use a new single database structure. The following updates have been made in relation to this change:

• Database naming conventions have been updated. See Database naming.
• Synonyms have been added to maintain third-party functionality by referring pre-68 databases to the new single database. See Database synonyms.
• Schemas have been added to contain the database objects previously contained in SynergyOne, SynergyOneFinance and SynergyOneMedia. See Database schemas.
• Support for multiple collation sequences. See Collation Sequences.
• Synergetic is run in SQL as a contained database. See Contained databases.
• Crystal reports need to be updated to work with the single database structure. See Updating Crystal Reports for the single database structure.
• MS Query queries need to be updated for the single database structure. See Updating MS Query queries for the single database structure.
• Security access to financial information is maintained in SQL using the publicfinance database role. See Maintaining public finance role security access in the single database structure.

Single database structure

Main Database tab renamed.

The Main Database tab of the Edit Synergetic Configuration File [Synergy.cfg] window has been renamed the Main tab.

Edit Synergetic Configuration File [Synergy.cfg] window

Fields and buttons have been updated on the Main tab of the Edit Synergetic Configuration File [Synergy.cfg] window.

The following fields and buttons on the Main tab of the Edit Synergetic Configuration File [Synergy.cfg] window have been updated.

The following fields have been added:

• Finance Schema
• Use Impersonated user when connecting to database
• Non-Finance User Name
• Finance User Name.

The following button has been added:

• .

The following field has been removed:

• Use application roles.

The following field has been renamed:

• Multi-tenant has been renamed Multi-tenant environment.

Tabs removed from the Edit Synergetic Configuration File [Synergy.cfg] window

The following tabs have been removed from the Edit Synergetic Configuration File [Synergy.cfg] window:

• Finance Database tab
• Media Database tab.

Crystal Reports tab renamed.

Crystal Reports tab of the Edit Synergetic Configuration File [Synergy.cfg] window has been renamed the Reports tab.

Fields and buttons have been updated on the Reports tab of the Edit Synergetic Configuration File [Synergy.cfg] window.

The fields and buttons on the Reports tab of the Edit Synergetic Configuration File [Synergy.cfg] window have been updated.

The following fields have been added in the Crystal Reports area:

• Non-Financial Reports
• Financial Reports.

The following fields and buttons have been added in the SSRS area:

• Non-Financial Reports
• Financial Reports
• .

New security resource types.

You can use the following new security resources to maintain security permissions on the Groups View of the Groups/User Security Maintenance:

• API Roles
• Dashboard Tiles.

Maintaining security permissions

Group/User Security Maintenance - Groups View

New address validation search functionality.

You can configure address validation to enable address search fields that display matching records as you type.

Configuring address validation

Maintaining address validation setup data

New school lookup table.

The following lookup table has been added:

• luSchoolAttainment lookup table.

Maintaining school settings

General lookup tables updated.

The following lookup tables have been added:

• luBuilding lookup table
• luLocalisation lookup table
• luRegion lookup table.

The following lookup tables have been updated:

• luCountry lookup table
• luYearLevel lookup table.

Maintaining general setup data

Community lookup tables updated.

The following lookup tables have been added:

• luCommunityDedupMergeIgnore lookup table
• luGivenName lookup table
• luPermResStatus lookup table
• luStudentSafetyActivityStatus lookup table
• luStudentSafetyActivityType lookup table

The following lookup tables have been updated:

• luQualification lookup table
• luTitle lookup table.

Maintaining community setup data

Current student lookup tables updated.

The following lookup table has been added:

• luStudentIDMapper lookup table.

The following lookup table has been updated:

• luActivity lookup table.

Maintaining current students setup data

Staff lookup table added.

The following lookup table has been added:

• luTrainingProvider lookup table.

Maintaining staff maintenance setup data

Staff configuration settings added.

The following configuration settings have been added:

• ExternalRegNumber:Caption configuration setting
• ExternalRegNumber:ReadOnly configuration setting.

Course lookup tables added.

The following lookup tables have been added:

• luCourseConditions lookup table
• luCourseConditionStatus lookup table
• luStudentCourseExtraCharge lookup table
• luStudentCourseSpecialOffer lookup table.

Maintaining courses setup data

Absence events lookup tables added.

The following lookup tables have been added:

• luAbsenceEventsTerminalDefinition lookup table
• luAbsenceEventsTerminalReasonDefinition lookup table
• luAbsenceNotificationReply lookup table.

Maintaining absence events lookup tables

Student report lookup tables updated.

The following lookup tables have been updated:

• luReportResultClassification lookup table
• luReportResultType lookup table
• luReportResultTypeMaskExpanded lookup table
• luReportStyle lookup table.

Maintaining student reports lookup tables

Subject assessment lookup table added.

The following lookup table has been added:

• luSubjectAssessmentProvider lookup table.

Maintaining subject assessments lookup tables

Timetable lookup table added.

The following timetable lookup table has been added:

• luDays lookup table.

The following timetable lookup table has been updated:

• luTimetableOperationMode lookup table.

Defining and setting up timetables

Materials lookup table added.

The following lookup table has been added:

• luSupplier lookup table.

Maintaining materials setup data

Development lookup table added.

The following lookup table has been added:

• luDonorStatus lookup table.

Maintaining development setup data

luActionMessageType lookup table has been removed.

The luActionMessageType lookup table has been removed.

Maintaining Action Centre setup data

Events lookup table updated.

The following lookup table has been updated:

• luEventType lookup table.

Maintaining events setup data

Events configuration setting added.

The following configuration setting has been added:

• TermsAndConditions:DefaultHTML configuration setting.