This article describes the Synergetic database objects access requirements for running the CareMonkey agent which performs One-Way or Two-Way synchronisation.

SQL scripts configuring these permissions are generated by the set-up process as described in the article Setting up CareMonkey-Synergetic integration

One-Way Syncronisation

One-Way synchronisation required read (Select) access on the following tables ( the list of columns is provided when the access to the table is restricted to these columns)

  • SynDatabases(VersionNumber Code )
  • FileSemesters(FileYear FileSemester SystemCurrentFlag )
  • Consent(ID ConsentCode ActiveFlag ConsentGivenBy ConsentGivenDate )
  • MedicalImmunisation(ID ImmunisationCode AdministeredDate ActiveFlag )
  • Ability(ID AbilityTypeCode )
  • MedicalCondition
  • MedicalDetails
  • MedicalAdditionalAsthmaDetails(ID MedicalConditionSeq AsthmaTriggers AsthmaAction )
  • MedicalAllergy(ID MedicalAllergySeq )
  • MedicalConditionAllergy(MedicalAllergySeq MedicalConditionSeq )
  • Medication(ID MedicationSeq MedicationTypeCode MedicationDetails ActiveFlag Medication MedicationExpiryDate)
  • MedicalEquipment(ID MedicalEquipmentTypeCode MedicalConditionSeq MedicalEquipmentFlag )
  • MedicalSymptom(ID MedicalConditionSeq )
  • MedicalRisk(ID MedicalConditionSeq )
  • MedicalConditionMedication(MedicationSeq MedicalConditionSeq )
  • MedicalPlanMedication(MedicationSeq MedicalPlanSeq)
  • MedicalPlan(MedicalPlanSeq )
  • luRelationship(Code Description )
  • luAsthmaCategory(Code Description )
  • luMedicalImmunisationType(Code Description ActiveFlag SortOrder )
  • luAbilityType(Code Description AbilityType SortOrder )
  • luMedicalConditionType(Code Description ActiveFlag SortOrder )
  • luConsentType(Code Description ActiveFlag )
  • Students
  • luHouse(Description Campus Code ActiveFlag )
  • StudentYears(ID Status FileYear House Tutor Form YearLevel )
  • Timetable(ClassCode StaffID FileYear FileSemester )
  • luStudentStatus(Code SynergyMeaning )
  • Staff(ID ActiveFlag )
  • SubjectClasses(Description SubjectClassesSeq )
  • StudentClasses(ID ClassCode StopDate SubjectClassesSeq FileYear FileSemester)               
  • StudentContacts(ID ContactType LinkedID LinkedIDSeq PrimaryOnlyFlag ParentFlag LivesWithFlag )
  • Community(ID Given1 Given2 Surname Preferred MobilePhone Email OccupEmail CommunityModifiedDate SpouseID MobilePhoneActual Gender WorkWithChildrenCheckVerifiedDate )
  • StudentSemester(ID StudentCampus FileYear FileSemester Status Boarder House Form Tutor)

Two-Way Synchronisation

All the read access listed on the One-Way and additionally the following

Insert Access

  • Consent
  • MedicalImmunisation
  • Ability
  • MedicalAdditionalAsthmaDetails
  • MedicalAllergy
  • MedicalConditionAllergy
  • MedicalCondition
  • Medication
  • MedicalConditionMedication
  • MedicalEquipment
  • luMedicalImmunisationType
  • luAbilityType
  • luMedicalConditionType
  • luConsentType

Update Access

Update access on the following tables and the list of columns which can be updated is provided in brackets

  • MedicalDetails(BloodGroup AmbulanceFlag AmbulanceNo PrivateInsuranceFlag PrivateInsuranceNo MedicareNo MedicareLineNo MedicareExpiryDate )
  • MedicalImmunisation(ID ImmunisationCode AdministeredDate ActiveFlag )
  • MedicalAdditionalAsthmaDetails(AsthmaTriggers AsthmaAction )
  • MedicalAllergy(MedicalAllergyTypeCode SeverityCode AllergyTreatment ActiveFlag AllergyDescription )
  • MedicalCondition(ConditionDetails SeverityCode EmergencyTreatmentDetails )
  • Medication(MedicationDetails ActiveFlag MedicationExpiryDate )
  • MedicalEquipment(MedicalConditionSeq MedicalEquipmentFlag )
  • Students(ID EmergencyName EmergencyAddress EmergencyPhone EmergencyPhoneAlt EmergencyRelat MedicalAlert Emergency2Name Emergency2Address Emergency2Phone Emergency2PhoneAlt Emergency2Relat Emergency3Name Emergency3Address Emergency3Phone Emergency3PhoneAlt Emergency3Relat DoctorName DoctorPhone DoctorPhoneAlt DoctorAddress Doctor2Name Doctor2Phone Doctor2PhoneAlt Doctor2Address DentistName DentistPhone DentistPhoneAlt DentistAddress CreatedDate CreatedBy ModifiedBy ModifiedDate )

Delete Access

  • Consent
  • MedicalImmunisation
  • Ability
  • Medication
  • MedicalRisk
  • MedicalCondition
  • MedicalEquipment
  • MedicalSymptom
  • MedicalAllergy
  • MedicalPlanMedication
  • MedicalPlan
  • MedicalConditionMedication
  • MedicalConditionAllergy
  • MedicalAdditionalAsthmaDetails

Photographs table access

In Synergetic version 67 the photos are stored in a separated Schema "SynergyOneMedia". Within this schema, the integration requires read  (Select)  access to the table:

  • Photos (ModifiedDate, Thumbnail)

Related Articles

CareMonkey and Synergetic Integration
Setting up CareMonkey-Synergetic integration
How to manually update Integration
How does an Administrator perform a manual sync
Configure the data that was picked up by the integration
Spreadsheet for uploading profiles
How does an Administrator upload Profile Photos

Did this answer your question?