Versions Compared

Version Old Version 319 New Version 320
Changes made by

Lori Nye

Michelle Drewes

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel

Table of Contents

...

Enter a date to only Include Active Compensations  in the Selected Compensation grid.  This will eliminate of including both old and new compensations for an employee.  The included compensations, active as of date, looks for compensations with a start date that is either empty, or before or equal the date entered AND a stop date that is either empty, or after or equal the date entered. If the compensation meets these criteria, then it is displayed in the grid. The grid updates when the date is changed.

Select Pay Groups options using the  to select Available Pay Groups to Selected Pay Groups.

...

Click on  to activate all contract information into the Compensation records, then deletes it from New Contract maintenance file.

Import New Contracts

Note

**Please be aware the header columns listed below are case sensitive**

...

Redesign Import File Column Heading NameRedesign Field LocationNew Contract Description and ValuesClassic Field NameClassic Field LocationClassic New Contract Description
employeeIdCompensation

Employee Number

  • Employee Number
  • Employee SSN
EMPLOYEE_ID

jobNoCompensationPosition NumberJOB_NOJOBSCNJob#
contractTypeN/A

Type

1 - Mid-year change with no Retro

2 - Mid-year change with Retro spread over pays

3 - Mid-year change with lump sum retro

4 -  New Contract from existing Compensation

CONTRACT_TYPE

newCompensationLabel

Label is only required if the employee has more then one Compensation for a Position.

Compensation

Label

  • Label name

JOBSCNCheck stub desc
calendarTypeCompensationJob CalendarCALENDAR_TYPEJOBSCNCalendar type
firstNameEmployeeFirst Name


lastNameEmployeeLast Name


raiseDateN/ARaise DateDAYS_SINCE_RAISE
Days since raise
compensationDescriptionCompensationDescription

Title
contractStartDateCompensation

Compensation Start Date

  • If importing a New Contract (Type = 4),  a Contract Start Date is needed to help determine the Work Days for the Compensation.
  • If no date is entered, the system will populate a random date.
CONTRACT_START_DATEJOBSCNCont start
contractStopDateCompensation

Compensation Stop Date

  • If importing a New Contract (Type = 4),  a Contract Stop Date is needed to help determine the Work Days for the Compensation.
  • If no date is entered, the system will populate a random date.
CONTRACT_STOP_DATEJOBSCNCont stop

contractWorkDays


Compensation

Contract Work Days 

  • If not provided in the import file, then will default to the calculated value. 

This value currently can only be loaded for new contracts.  

WORK_DAYS_IN_CONTRACTJOBSCNWork Days

payPlan

Not an option at this time. Use Mass Change in New Contract to update Pay Plan.

Compensation

Pay Plan

  • Biweekly
  • Semimonthly
  • Monthly
PAY_PLANJOBSCNPay Plan
payUnitCompensation

Pay Unit

  • Daily
  • Hourly
PAY_UNITJOBSCNPay unit

unitAmount


Compensation

Unit Amount

  • The Unit Amount will still be calculated for contracted Compensations when the new contract is imported even if the Start and Stop Dates are populated, or the user provides Contract Work Days in the import file.

JOBSCNDaily rate
retireHoursCompensationRetirement HoursRETIRE_HOURSJOBSCNRetire hours

Accrued Wages

Not Loaded

Compensation

Accrued Wages

  • Calculated field



Amount Earned

Not Loaded

Compensation

Amount Earned

  • Calculated field



Amount Paid

Not Loaded

Compensation

Amount Paid

  • Calculated field



Amount Docked

Not Loaded

Compensation

Amount Docked

  • Calculated field



payPerPeriod


Compensation

Pay Per Period 

  • The Pay Per Period will be calculated if a Pay Per Period is not provided in the import file and the import file contains all of the necessary fields needed to calculate a Pay Per Period.  The necessary fields are:
    • Contract Obligation
    • Contract Amount
    • Stretch Pay must be true
    • Pays in Contract must be greater than 0
    • Pays Paid must not equal Pays in Contract



contractAmount 

Required for Stretch Paid Compensations

Compensation

Contract Amount

  • Format as a number
CONTRACT_AMOUNTJOBSCNNew contract

contractualObligation


Compensation

Contract Obligation 

  • The Contract Obligation will be set to the Contract Amount the Contract Obligation is not provided in the import file. 
  • The Contract Obligation will be set to the Contract Amount if the Contract Obligation is not provided in the import file and the user clicks the Calculate button.  This will only occur if the Calculate option is used within New Contract - not the Calculate option in the Compensation.  
  • If entered in import file, needs to be formatted as a number.
CONTRACTUAL_OBLIGATIONJOBSCNObligation
userContractTypeCompensationContract TypeUSER_CONTRACT_TYPEJOBSCNContract type
paysInContractCompensationPays In ContractPAYS_IN_CONTRACTJOBSCN

'# pays

Pays Paid

Not Loaded

Compensation

Pays Paid

  • Calculated value



equalPaysCompensationStretch PayEQUAL_PAYSJOBSCNEqual pays

retroNextPay

Not Loaded


Retro Next Pay

  • Calculated value



salaryScheduleColumnCompensation

Salary Schedule Column

  • Numeric
SALARY_SCHEDULE_COLUMN

salaryScheduleIdCompensation

Salary Schedule Id

  • Alpha or Numeric
SALARY_SCHEDULE_ID

salaryScheduleStepCompensation

Salary Schedule Step

  • Numeric
SALARY_SCHEDULE_STEP

Local Contract Code

Not Loaded

Compensation

Local Contract Code

  • Automatically populated when Compensation is included in a Data Collection.  Used for EMIS reporting.



calendarStartDateCompensation

Calendar Start Date

  • Format as 00/00/0000
CALENDAR_START_DATEJOBSCNCalendar start
calendarStopDateCompensation

Calendar Stop Date

  • Format as 00/00/0000
CALENDAR_STOP_DATEJOBSCNCalendar stop
hoursInDayCompensation

Hours in Day

  • Required for Contract Compensations with the Pay Unit set to Hourly.
HOURS_IN_DAYJOBSCNHours per day
retirementCodePositionRetirement SystemRETIREMENT_CODE

jobTitlePositionPosition DescriptionTITLE

jobStatusPositionJob StatusJOB_STATUS

payGroupPositionPay GroupPAY_GROUP

building (must be all lower case)PositionBuilding CodeBUILDING

department  (must be all lower case)PositionDepartment CodeDEPARTMENT

checkDistributionEmployeeEmployee Check DistributionCHECK_DISTRIBUTION

extendedServicePositionExtendend ServiceEXTENDED_SERVICE

fte  (must be all lower case)PositionFTEFTE

positionCodePositionPosition CodePOSITION_CODE

buildingIrnPositionBuilding IRNBUILDING_IRN

assignmentAreaPositionAssignment AreaASSIGNMENT_AREA

positionStartDatePositionPosition Start DatePOSITION_START_DATE

positionStopDatePositionPosition Stop DatePOSITION_STOP_DATE

paraprof  (must be all lower case)PositionParaprofessionalPARAPROF

emisHoursInDayPositionEMIS Hours In The DayEMIS_HOURS_IN_DAY

emisWorkDaysInContractPositionEMIS Work DaysEMIS_WORK_DAYS_IN_CONTRACT

emisFteUnitPositionEMIS FTEEMIS_FTE_UNIT

emisContractAmountPositionEMIS Contract AmountEMIS_CONTRACT_AMOUNT

...

  • Report to EMIS - Can only be changed using Mass Change under New Contract, after importing is complete into New Contract Maintenance.

     


Example of an Import.csv:

Creating New Non Contract Compensations

...

Example of New Contract under New Contract Maintenance option:

Salary Notices

This program produces salary notices that can be distributed to employees with New Contract information.

Info

Creating and Emailing Salary Notices 

...

  • Districts have the option to create a custom salary notice.  To create a custom form, you can begin with the default form and then customize it.  To download the default salary notice, click here. This follows the same rules as creating a customizing a direct deposit form.  For further instructions in customizing forms, click here.  

Available Fields for Salary Notices

...

Setup for Salary Notices

Info

The "Email Notifications" module must be installed in System->Modules. Once this is installed, the Email Salary Notices button will be enabled in New Contract/Salary Notices.  Also, in System->Configuration, the Email Configuration needs at least 'Smtp Host' specified, and the Salary Notice Configuration needs 'From Email' specified as a "real" email address that your smtp email server will recognize.   

The next step is setting up the Configuration->Salary Notice Configuration to show who sent the Email Salary Notices, the Subject and what the email should state:

The From Email will be the email address of the person sending the notifications.

The Subject line to be used for Email Salary Notice

  • Salary Notice for {POSITION_DESC} {COMPENSATION_LABEL}

The Body is the text to use for the body of the Email Salary Notice

  • Attached to this message is your salary notice for {POSITION_DESC} {COMPENSATION_LABEL}.

The Send Notification To All Addresses allows the districts to choose whether to send to all or only the primary email address.  This is checked by default.

The Exclude Employee Number From Emailed Salary Notice is to exclude the Employee Number from the Notice.  This is checked by default.

The Default Salary Notice Form dropdown, will show any Custom Forms created by the district to use for Salary Notice printing.  To use the default custom form, leave blank.

Image Modified

Districts will also have the option to Email Salary Notices directly to their employee's.  Click to schedule a Date and time to send email notices:

...

This report list the data from New Contract maintenance

Mid Year Contract Change

See Checklist  USPS-R Mid Year Contract Change Checklist#RMidYearContractChangeChecklist

...

Note

The contract obligation field will reflect the amount to be earned on the new contract plus the amount already earned on the old contract plus the lump sum retro amount.

The Days Since Raise field will be automatically populated, utilizing the raise date, when the Calculate button is clicked.

...