Background

There are several ways of getting staff into Consent2Go:

  1. Staff can be manually created
  2. Staff can be imported in bulk (via request to Customer Support)
  3. For Synergetic Connector schools, staff can be imported on a scheduled basis from Synergetic Staff Maintenance. 

This article describes the steps for setting up this third process 


If you would like this set up at your school, please review this article, and get in touch with us to arrange us to turn on staff syncing with Synergetic.

Prerequisites

This feature is available to schools that store their staff details in Synergetic. Your school must also have the Synergetic Connector set up between Synergetic and Consent2Go. Please contact us if you would like to arrange this.

Staff Syncing Process

On a scheduled basis, Consent2Go will pull staff details from Consent2Go, and do the following:

  • Add any new staff to Consent2Go
  • Remove any staff who are no longer active in Synergetic

Currently, no staff details are written back to Synergetic.

Technical Details

When we set up schools with the Synergetic / Consent2Go connector tool, we create a database view on your Synergetic database, called "uvC2GStaffDetail". This view defines which staff, and which details will be brought from Synergetic to Consent2Go. Depending on your desired setup, we can help you customise this view.

Which staff are imported to Consent2Go?

Generally, all staff in Synergetic with the "Active" flag are imported. We will also add a check that the staff member has their Occupation Email Address set to the standard staff email address format for your school. For example, we would set up the connector to only import staff where the Occupation Email is like "...@yourschool.com.au". 

We can help you customise this view if you have different requirements at your school.

Which staff details are imported to Consent2Go?

The following columns are brought from Synergetic to Consent2Go by default (you can look at "uvC2GStudentDetail" to see how these are defined). If you would like to prevent any information from being copied to Consent2Go, then those columns can be set to NULL (unless they are marked as "Mandatory"):


 

Column Name (in uvC2GStaffDetail)Data TypeMandatory? 

Note: If a column is not mandatory, it can be set to NULL
Comment
IDvarchar(15)YesThis is the Synergetic ID. In Consent2Go, it will be stored as the "Unique Identifier"
CampusIDint
This is a Consent2Go identifier. If your school is set to Mult-Campus within Consent2Go, then we will work with you to fill this in. For most schools, this can be left as NULL.
HomeRoomnvarchar(150)

Housevarchar(50)


WWCNumbervarchar(50)

WWCExpirydate

ModifiedDatedatetime
Most recent modified date for this staff member's Synergetic record (from the Community table, or from the Addresses table)
FamilyDoctorNamenvarchar(150)

FamilyDoctorAddressnvarchar(250)

FamilyDoctorNumbernvarchar(15)

EmergencyContactNamevarchar(100)

EmergencyContactNumbernvarchar(50)

EmergencyRelationshipsmallint
This value comes from Consent2Go mapping table in Synergetic, for example: "SELECT RelationshipId FROM uC2GSynergeticRelationship WHERE SynergeticCode = vStaff.Emergency2Relat"
Emergency2ContactNamevarchar(100)

Emergency2ContactNumbernvarchar(50)

Emergency2Relationshipsmallint
See comment for "EmergencyRelationship"
Titlevarchar(7)

FirstNamenvarchar(50)Yes
LastNamenvarchar(50)Yes
DateofBirthdate
This column is set to NULL by default, so it won't be brought across
MobileNumbernvarchar(50)
This column is set to NULL by default, so it won't be brought across
Emailnvarchar(256)Yes
Addressnvarchar(300)
This column is set to NULL by default, so it won't be brought across
Suburbnvarchar(100)
This column is set to NULL by default, so it won't be brought across
Statenvarchar(100)
This column is set to NULL by default, so it won't be brought across
Postcodenvarchar(50)
This column is set to NULL by default, so it won't be brought across
PhoneNumbernvarchar(50)
This column is set to NULL by default, so it won't be brought across
GenderintYes1=Male, 2=Female (Currently these are the only options)
Medic_IsAmbulancebit
Has Ambulance Cover
Medic_Ambulancevarchar(50)
Ambulance Member Number
Medic_BloodTypesmallint

MedicareExpiryDatechar(5)
E.g. If the Medicare card expires in June 2024, then it would be in the format "06/24"
MedicareLinesmallint

MedicareNumbernvarchar(50)

Medic_IsPrivateHealthbit

Medic_PrivateHealthInsurervarchar(50)

Medic_PrivateHealthPolicyvarchar(20)

Medic_PrivateHealthCovervarchar(50)

isPhotoUseAuthorisedWebbit
Permission to use image in web content
isPhotoUseAuthorisedPrombit
Permission to use image in school promotional material
isPhotoUseAuthorisedPrintbit
Permission to use image in print material
SwimmingCommentsvarchar(500)

SwimmingLevelsmallint

Medic_IsParacetamolbit

Medic_IsAntihistaminebit

Medic_IsAntiinflammatorybit

Medic_IsPrescriptionbit

Medic_IsTranfusionsbit

IsEmergencyMedicalAuthorisedbit
Emergency medical treatment is authorised
RoleIdint
This can be used to allocate schools to specific roles (when the staff member is first created). If this is left as NULL, then new staff will be allocated to the Default User Role for the school. The Default User Role can be found under the "System Settings" menu. Please confirm with Consent2Go before using this column, so that we can check that the correct RoleId numbers have been used for your school.
IsFirstaiderbit

FirstAidDateAttaineddate

FirstAidExpiryDatedate

LicenseNumbervarchar(20)

IsPoliceCheckedbit

PoliceCheckEndDatedate



If your school would prefer to bring over less staff information from Synergetic to Consent2Go, that can be arranged by customising the Synergetic database view "uvC2GStaffDetail" (we can do this, or assist you in doing this). The columns that are not required would be assigned to "NULL". The mandatory columns would be:

  • First Name
  • Last Name
  • Email
  • Gender (at this stage, "Male" or "Female")
  • Unique ID


Reviewing the Default Role for Users

When new staff records are created in Consent2Go by the syncing process (or even by manual process), those staff will automatically be assigned to the Consent2Go staff security role that is default for your school. 


It is important to review this role's security level, to ensure that new staff aren't given inappropriate access to sensitive or private staff or student data. This is especially important if your school is using Single Sign On for your users. In this case, staff will be able to log on to Consent2Go as soon as the account is created in Synergetic. (If your school is not using Single Sign On, then staff won't get access until a System Administrator explicitly creates an account and issues a login).


To see the default role for your school:

  • Press the small cog wheel in the top-right corner of the Consent2Go website:
  • Choose "System Settings" from the menu: 
  • You can see the Default Role for your school in the "System Roles" tab: 

You can edit this role, or choose a different role to be the default role. 

For more information on System Roles, please see: Helpdesk : Consent2Go (freshdesk.com) 


Existing Staff in Consent2Go

If you have existing staff in your system, please review these staff before we turn on Staff Syncing. If the staff still require access to Consent2Go, please ensure that the "Unique ID" field is filled in with the matching Staff ID from Synergetic staff maintenance. 


If you already have a large number of staff in Consent2Go, and you need to update their Unique IDs, we can do a bulk upload for you.


Filling in the Unique ID will ensure that, when the syncing starts, it will update that staff record with the latest details from Synergetic. (If you do not fill in the "Unique ID", then a duplicate staff record will be created for the same person):


Staff records that do not have the "Unique ID" filled in will be unaffected by the syncing process. If the "Unique ID" is filled in, but doesn't match an Active staff member in Synergetic, then that staff record will be removed from Consenet2Go.