Mass Change
The Mass Change option is available for employees that have the Module checked under the SYSTEM/MODULE section. By default, the Mass Change option to create and execute will be available to users with the Administrator Role and the Mass Change option to execute will be available to the Group_Manager Role.
The permissions below may be granted to other roles as desired by the school district.
- ADMIN_MASSCHANGE
- ADMIN_MASSCHANGE_CREATE
- ADMIN_MASSCHANGE_DELETE
- ADMIN_MASSCHANGE_EXECUTE - able to run/execute any pre-existing Mass Change definitions but cannot create new
The Mass Change button will be available within most of the Core Menu selections.
Adding the Mass Change Module
To add the Mass Change Service module, go to SYSTEM/MODULE and click on .
Once selected, the will change to a next to the Mass Change Service option:
An Info message will appear . 'Click on the 'Refresh Page' to finished installing the new Module.
Once the process has been installed, you will then see the 'Mass Change' option next to the 'Create' button on most of the Core menu Selections:
Example of Positions screen:
To Clear a field using Mass Change
If needing to clear a field, us the New Value of: null
Menu Core options that have the 'Mass Change' Available:
ACH Destination
ACH Source
Adjustments
Attendance
Bank Account
Compensation (when downloading a Mass Change definition, it must be loaded under the 'All Compensations' tab)
Date Codes
EMIS Entry/EMIS Contract Service (CC)
Attendance
- Change Length. Enter the length in the New Value. Quotes are not necessary.
- Change Unit - From Hourly to Daily or Daily to Hourly. Enter the unit in the New Value. Quotes are necessary.
If changing both the length and unit, be sure to Mass Change each separately - changing the length first.
Employee
Under 'Load Definition' option, are Mass Change definitions that are commonly used:
Change Archived Flag (SSDT)
Change Email Direct Deposit Flag (SSDT)
Clear Employee Long Term Illness (SSDT)
Job Calendars
Leaves- Only available for Accumulations
Max Leave Amount - Mass change is not available to update the Max Leave amount. But Mass Load can be used:
Create a Excel-FieldNames spreadsheet pulling in the Sick employee's that need changing.
Then remove the headers: first and last name, resetValue, balance,
update the headers to be:
employee.number
type
accumPerMonth
leaveUnit
maxLeaveAmount
New Contract
The Mass Change definition below, can be used to check or uncheck the New Reportable to EMIS checkbox.
- Uncheck the New Reportable to EMIS checkbox, click here.
- Check the New Reportable to EMIS checkbox, click here.
Pay Distributions
Pay Group
Payee
Payroll Accounts
Payroll Item
- Under 'Load Definition' option, are Mass Change definitions that are commonly used: NOTE: if adding/updating a value field, these fields cannot be null (blank), needs to have 0.00 added first or use Mass Load to update these fields
Change Rate (SSDT)
- Clear Federal Tax COVID 19 Fields (SSDT) (under Payroll Item, you can't see the COVID fields in the grid but can under 'Federal Tax' Payroll Item)
To Clear Federal Tax COVID 19 Fields (SSDT), select . Click on the links below for more detail instructions:
Payroll Item Configuration
Position
- Under 'Load Definition' option, are Mass Change definitions that are commonly used:
Clear EMIS Contract Fields (SSDT)
Mass Change CANNOT be used to change Pay Groups, use Mass Load. Click here for instructions.
Mass Change Dates
In Maintenance Mode, select from the Script Definition (Normal Mode) drop down, the date that you want to change and enter org.ssdt_ohio.model.util.DateConverter.convertDate('MM/DD/YYYY') in the New Value box
Termination Date
To enter a Termination Date using Mass Change, click here for a .mcd.json procedure
Menu System/Users Mass Change 'Enable Two Factor Authentication (SSDT)' only
ITC's have the availability to Mass Change ALL Employee's in a district.
Create Mass Change using 'Script Definition'
- From the Core menu select the record to be changed
- Click on 'Mass Change':
- Once selected, a box will open at the bottom:
- Select the employees in the grid to be changed before continuing. The Mass Change will change every employee that is listed on the grid otherwise.
- From here, select the 'Script Definition' by clicking on the key.
- Enter in the New Value needed
- If making the change through the 'Script Definition' option, the 'New Value' needs to be in quotes " ".
- At this time you can the Definition Name for later use and will be saved under option or Select to save to your desktop and email to other employees
- The can be used to Import a saved definition from an outside source Or click on to start over on your change
- After your change has been entered, select . At this time, employees can be filtered in the grid for the change if not done early. The system will then bring up how many positions will be modified by this change:
- Then click on to submit changes or select to return to the Grid:
- The change will be made to all 25 Positions that were selected:
- Positions Example change:
Create Mass Change using 'Script Parameters'
- From the Core menu select the record to be changed
- Click on 'Mass Change':
- Once selected, a box will open at the bottom:
- Select the employees in the grid to be changed before continuing. The Mass Change will change every employee that is listed on the grid otherwise.
- Enter in the 'Script Parameters' Name (there is no restriction or limit in the 'Name' of the Script parameter)
- From here, select the Script Definition by clicking on the button
- Enter in the 'New Value' the 'Name' of the 'Script Parameters'
- For example, the Name in the Script Parameters was called 'var1' so the 'New Value' under Script Definition has to match.
- At this time you can the Definition Name for later use and will be saved under option or Select to save to your desktop and email to other employees
- The can be used to Import a saved definition from an outside source or click on to start over on your change
- After your change has been entered, select on 'Execution Mode'. At this time, employees can be filtered in the grid for the change if not done early. The system will then bring up how many positions objects will be modified by this change:
- Enter in the var1 Value name to be changed or added: (certified). Then click on
- The change will be made to all 25 Positions that were selected:
- Positions Example change:
- Positions Example change:
Advanced Query
The is a more elaborate search where the user selects the property field to search on, the operation to search by, and enters what they are searching for. For example in the Attendance Advance Search, Select Property of 'Activity Date', Select Operation of 'Equals', and a Filter Value of '12/19/2017'. The user is searching for Employee's with a default activity date of 12/19/2017. The Filter Value is a value entered by the user based on what they are searching for and the property field type; for some operations this may be a list or range with the values separated by commas. The information entered in the Filter Value box is dependent on the property field selected. If the user chooses a property field of type Boolean, the user would have to enter in true or false.
The user can add as many search lines as desired by dragging and dropping them in the desired order into the Display box or double clicking the Properties. The Search properties can be 'Removed' by clicking on the
The Advance Query searches can be saved and recalled later. The Query can be saved by entering in a Query Name and clicking on ''. Then the Query can then be reloaded using the
- 'Apply Query' starts the search
- 'Clear Query' clears the search items and returns all the original values back to the grid
- 'Hide Advanced Query Controls' hides the Advanced Search Query window
Mass Change
Example of adding a Stop Date on a Payroll Item:
Select the Payroll Item from the drop down box. From here you can enter what Code you are wanting to enter a stop date for. Click on
Mass Change Stop Date
In Maintenance Mode, select from the Script Definition (Normal Mode) drop down, select and enter org.ssdt_ohio.model.util.DateConverter.convertDate('MM/DD/YYYY') in the New Value box:
To save the Script Definition, enter a name in the Definition Name and click on . This definition can then be used again for just that Payroll Item (example.. OSDI Tax Item) that was selected by clicking on
To Execute the load, click on option. Once this has been selected, it will show how many records will be modified . Verify and click on
Stop Date Mass Changed:
Mass Change Pay Cycle
- EveryPay
- FirstPay
- SecondPay
- FirstAndSecondPay
The quotes are needed for the new value
Example of changing the Position Job Status to Inactive:
Mass Change Total Experience and Authorize Experience
To add 1 year to Authorize Experience and Total Years of Experience, this Mass Change procedure Increment Experience.mcd-json can be used