Versions Compared

Key

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


Panel

Table of Contents

New Contracts

...


Panel

Table of Contents

New Contracts

Note

If any employee's Compensation is Archived, the Compensation will not be included in New Contracts.

...

  • Storage of historical contract information.
      • Activate of pay account data.
  • Activate data by pay group, contract start date, contract type (user defined), appointment type, and calendar type.

...

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

New Label

  • Label name

JOBSCNCheck stub desc
calendarTypeCompensationJob CalendarCALENDAR_TYPEJOBSCNCalendar type
firstNameEmployeeFirst Name


lastNameEmployeeLast Name


raiseDateN/ARaise DateDAYS_SINCE_RAISE
Days since raise
compensationDescriptionCompensationNew Description

Title
contractStartDateCompensation

New 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

New 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

New 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

New Pay Plan

  • Biweekly
  • Semimonthly
  • Monthly
PAY_PLANJOBSCNPay Plan
payUnitCompensation

New Pay Unit

  • Daily
  • Hourly
PAY_UNITJOBSCNPay unit

unitAmount


Compensation

New 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
retireHoursCompensationNew Retirement HoursRETIRE_HOURSJOBSCNRetire hours

Accrued Wages

Not Loaded

Compensation

New Accrued Wages

  • Calculated field



Amount Earned

Not Loaded

Compensation

New Amount Earned

  • Calculated field



Amount Paid

Not Loaded

Compensation

New Amount Paid

  • Calculated field



Amount Docked

Not Loaded

Compensation

New Amount Docked

  • Calculated field



payPerPeriod


Compensation

New 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

New Contract Amount

  • Format as a number
CONTRACT_AMOUNTJOBSCNNew contract

contractualObligation


Compensation

New 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
userContractTypeCompensationNew Contract TypeUSER_CONTRACT_TYPEJOBSCNContract type
paysInContractCompensationNew Pays In ContractPAYS_IN_CONTRACTJOBSCN

'# pays

Pays Paid

Not Loaded

Compensation

New Pays Paid

  • Calculated value



equalPaysCompensationNew Stretch PayEQUAL_PAYSJOBSCNEqual pays

retroNextPay

Not Loaded


New Retro Next Pay

  • Calculated value



salaryScheduleColumnCompensation

New Salary Schedule Column

  • Numeric
SALARY_SCHEDULE_COLUMN

salaryScheduleIdCompensation

New Salary Schedule Id

  • Alpha or Numeric
SALARY_SCHEDULE_ID

salaryScheduleStepCompensation

New 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

New Calendar Start Date

  • Format as 00/00/0000
CALENDAR_START_DATEJOBSCNCalendar start
calendarStopDateCompensation

New Calendar Stop Date

  • Format as 00/00/0000
CALENDAR_STOP_DATEJOBSCNCalendar stop
hoursInDayCompensation

New Hours in Day

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

jobTitlePosition Position Description


jobStatusPosition

Job Status

  • Active or A
  • Inactive or I
  • Deceased or D
  • Terminated or 
JOB_STATUS

payGroupPositionPay GroupPAY_GROUP

building Position

Building Code 

  • All lower case
BUILDING

department Position

Department Code

  • All lower case
DEPARTMENT

extendedServicePositionExtendend ServiceEXTENDED_SERVICE

fte  (must be all lower case)Position

FTE

  • All lower case
FTE

positionCodePosition

Position Code


POSITION_CODE

buildingIrnPositionBuilding IRNBUILDING_IRN

assignmentAreaPositionAssignment AreaASSIGNMENT_AREA

positionStartDatePositionPosition Start DatePOSITION_START_DATE

positionStopDatePositionPosition Stop DatePOSITION_STOP_DATE

paraprof  (must be all lower case)Position

Paraprofessional

  • All lower case
  • *  = (NA(not valid for PosCode=505 or 414))
  • N = (No)
  • Y = (Yes, meets definition of Qualified Paraprefessional)
PARAPROF

emisHoursInDayPosition

EMIS Hours In The Day

  • If nothing is supplied in the import file or in New Contract Maintenance, the system will use the value in Position Grid for Employee>Position. 
  • If a value is supplied in the import file or in New Contract Maintenance, the Position will be updated when the contract is activated. 
EMIS_HOURS_IN_DAY

emisWorkDaysInContractPositionEMIS Work DaysEMIS_WORK_DAYS_IN_CONTRACT

emisFteUnitPosition

EMIS FTE

  • If nothing is supplied in the import file or in New Contract Maintenance, the system will use the value in Position Grid for Employee>Position. 
  • If a value is supplied in the import file or in New Contract Maintenance, the Position will be updated when the contract is activated. 
EMIS_FTE_UNIT

checkDistributionEmployeeEmployee Check DistributionCHECK_DISTRIBUTION

...

Info

The New Reportable to EMIS checkbox can only be mass updated using Mass Change in New Contract.  The Mass Change definitions below can be used to mass uncheck or check the New Reportable to EMIS checkboxs.

Note

jobTitle will also update the Position Description field on the Position record when the new contract is activated.

           

Note

Compensation drop down information on the Future records comes from the Position Description (Position record) and Label (Compensation record) data .         

Compensation drop down information on the Current record comes from the Position Description field on the Position record..

                              


Example of an Import.csv:

Creating New Non Contract Compensations

To create new non contract compensation record the Reports/Report Manager/Non Compensation Mass Load Extract can be processed to create an excel file with the appropriate headers. The file then can then be updated-removing unwanted records, updating unit amount, start/stop date, etc. Once the file has been updated it will need to be saved in csv format. This will then allow the file to be loaded directly to Compensation. using Utilities/Mass Load/Compensation.


There is an available Non Compensation Mass Load Worksheet available that contains the Pay Group and excludes archived employees. 

...

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.

Creating

...

Salary Notices 

The Salary Notices are created using the New Contracts that are listed under New Contract Maintenance.

To create the Employee Salary Notices, listed under 'New Contract Maintenance', click on Salary Notices.

The Output File Name is defaulted to Salary Notices , but can be changed. *Required Field 

...

  • Certificated
  • Classified

Check  if wanting to run create Salary Notices with specific Employee's(this for specific employees(This will then exclude any employee's listed under New Contract Maintenance and just create those listed in the selected Employee's option.)

  • Select Employee(s) from dropdown the  Image Removed and dropdown and click on ADDAdd:Image Removed

Image Added

Check to include the district information on when the salary notices when using are printed - either using the default form.  This option can also be used on custom forms that are setup to use it.  Custom or custom forms.  When the checkbox is marked, the information from Core>Organization is what will be printed.  District forms may also be setup customized to always already include district information.  When using a custom salary notice form, please be aware of the district fields the form is setup to use. This information is directly pulled from Core/Organization when selecting Default:Districts will want to be conscious of the form being used to know how this checkbox needs to be marked.   

Image Modified

Select the Salary Notice appropriate salary notice Form from the drop down option:  Default.

Image Modified

...

Click Image Added to create Salary Notices.

Example of the Default Salary Notice

Image Added

Customizing 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

DescriptionField NameMerge Field Name
Employee NumberemployeeNumber${(row.employeeNumber)!}
First NamefirstName${(row.firstName)!}
Middle NamemiddleName${(row.middleName)!}
Last NamelastName${(row.lastName)!}
Street 1street1${(row.street1)!}
Street 2street2${(row.street2)!}
Citycity${(row.city)!}
Statestate${(row.state)!}
Zipzip${(row.zipCode)!}
Position NumberpositionNumber${(row.positionNumber)!}
Position DescriptionpositionDescription${(row.positionDescription)!}
Compensation LabelcompensationLabel${(row.compensationLabel)!}
Contract AmountcontractAmount${(row.contractAmount?string(",##0.00"))!}
Contract Work DayscontractWorkDays${(row.contractWorkDays)!}
Number Of PaysnumberOfPays${(row.numberOfPays)!}
Compensation Start DatecompensationStartDate${(row.compensationStartDate)!}
Appointment TypeappointmentType${(row.appointmentType)!}
School YearschoolYear${(row.schoolYear)!}
Statement DatestatementDate${(row.statementDate)!}
District NamedistrictName${(row.districtName)!}
District StreetdistrictStreet${(row.districtStreet)!}
District CitydistrictCity${(row.districtCity)!}
District StatedistrictState${(row.districtState)!}
District ZipdistrictZip${(row.districtZip)!}
Include District Info On NoticeincludeDistrictInfoOnNotice${(row.includeDistrictInfoOnNotice)!}
Name For NoticenameForNotice${(row.nameForNotice)!}
Salary Scheduled IdsalaryScheduleId

${(row.salaryScheduleId)!}

Salary Schedule ColumnsalaryScheduleColumn${(row.salaryScheduleColumn)!}
Salary Schedule StepsalaryScheduleStep

${(row.salaryScheduleStep)!}

Raterate

${(row.rate?string(",##0.00#"))!}

Rate TyperateType${(row.rateType)!}
District YearsdistrictExperience${(row.districtExperience)!}
Building YearsbuildingExperience

${(row.buildingExperience)!}

Accred Dist YearsaccredDistrictExperience${(row.accredDistrictExperience)!}
Military YearsmilitaryExperience${(row.militaryExperience)!}
Trade YearstradeExperience

${(row.tradeExperience)!}

Retire System YearsretireSystemExperience${(row.retireSystemExperience)!}
Ohio Public YearsohioPublicExperience

${(row.ohioPublicExperience)!}

Ohio Private YearsohioPrivateExperience ${(row.ohioPrivateExperience)!}

Non Ohio Public Years

nonOhioPublicExperience${(row.nonOhioPublicExperience)!}
Non Ohio Private YearsnonOhioPrivateExperience

${(row.nonOhioPrivateExperience)!}

Purchased YearspurchasedExperience

${(row.purchasedExperience)!}

Authorized YearsauthorizedExperience${(row.authorizedExperience)!}
Total YearstotalExperience

${(row.totalExperience)!}

Principal YearsprincipalExperience

${(row.principalExperience)!}

Degree TypedegreeType${(row.degreeType)!}
Degree Type DescdegreeTypeDescription

${(row.degreeTypeDescription)!}


After

...

creating the new form, go to

...

Reports>Report Manager and click Create Form.

...

 

Image Added

  • Report Name , enter - Enter the name Name of the custom form.
  • Description - A description of the form, if desired.
  • Tags - Enter a tag for the form.  Select New Contract under Entity Type.  Upload , if desired.
  • Entity Type - NewContract
  • Filename - Browse to find your custom form using the Select Form button.  Save the custom form.  Now when you generate salary notices from compensations or new contract, you will be able to select the default form or your custom form you created:
    • Image Removed
    On the Salary Notice Configuration, there is an option to set the default salary notice form.  If you select your custom form, then when you go to compensation or new contract it will be selected by default, but you still have the option to change it.  .
Info
iconfalse

A default salary notice form can be set.  Go to System>Configuration>Salary Notice Configuration and in the Default Salary Notice Form, select the custom form from the drop down.  

Image Added

Click Save.  

When in Compensation>Salary Notice or New Contracts>Salary Notices, the salary notice selected as the default salary notice form will be the form that you see.  Use the drop down to change the form, if desired.  

Please click here for more information on setting a Custom Salary Notice as default under Configuration/Salary Notice Configuration.

  • Image Removed

Once all information is selected, click on Image Removed to create Salary Notices

...

Image Removed

Email Salary Notices

Setup

...

Involved to Send Salary Notices

...

First, theEmail Notifications module must be installed. To install the module, go to System>Modules and click the + sign next to the Email Notification Services. Click the Image Addedoption to refresh the page.  Once the module is installed, the Email Salary Notices button will be enabled in New

...

Contract>Salary Notices.  Also,

...

go to System>Configuration>Email Configuration and add or verify there is a value in the 'Smtp Host

...

.'  

The next step is setting up the

...

System>Configuration>Salary Notice Configuration. 

Image Added

 

The From Email will be the email address of the person sending the notifications. This should be an valid email that your Stmp email server will recognize. 

The Subject line to be used for

...

emailed salary notice.

  • For example - Salary Notice for {POSITION_DESC} {COMPENSATION_LABEL}

The Body is the text to use for the body of the

...

email salary notice.

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

The Send Notification To All Addresses

...

allows districts to choose whether

...

to send the email salary notices to the 'Primary Email Address,' the 'Secondary Email Address,' and the 'Other Email Address' (located on the Employee record) or only the 'Primary Email Address.'  By default, this checkbox is marked and the employee will receive their emailed salary notice to all email addresses. 

The Exclude Employee Number From Emailed Salary

...

Notice will exclude the Employee Number from the

...

email salary notice.  By default, this checkbox is marked and the Employee ID will not be printed on the email salary notice.

Select the appropriate form for generating the email salary notices by using the Default Salary Notice Form dropdown

...

Image Removed

Districts will also .  The default form listed is based on the form selected in System>Configuration>Salary Notice Configuration. 

Sending the Salary Notices

Districts will 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.

...