NEWCNT

1
NEWCNT

• Presented by ACCESS
• Eileen Pakula
• April 25, 2007

2
What is NEWCNT?

• Program to enter new contract information
• New contract for school year
• Mid-year change with retro payment
• Mid-year change without retro
• payment

3
NEW FIELDS
Find
SSN/ID Job
Last Name First Name ID 111111111
Job 01 Name 0 0
Position New cont type
Obligation Days since
raise Equal pays N New contract
Cont start 00/00/0000 Hours per day
Old contract Cont stop
00/00/0000 Pay unit 2 Amount paid
Job status 1 Pay per period
Amount due Pay group
Daily rate Amount
earned Appt. type 1
Dock next pay Amount docked
Retirement Retro next pay
Extended service Position
Contract type pays/Pays paid
/ Building IRN 000000 New Hire date
00/00/0000 Wrk days/Worked /
Bldg./Dept. 000/000 Qual. Paraprof Title
HQPD

4
(No Transcript)
5
NEWCNT Options

• Main processing menu in NEWCNT

6
MAINT Option
7
MAINT Option

• NEWCNT Maintenance
• Add new contracts
• Modify new contracts
• Delete new contracts
• Purge individual contracts

8
BUILD Option
9
BUILD Option

• Auto process for groups of like jobs
• Subs
• Teachers
• Places jobs for access with MAINT option
• Zeroes all contract-to-date figures
• Amount paid
• Amount earned
• Days
• Pays

10
PURGE Option
11
Purge Option

• Purges contracts into JOBSCN
• Updates JOBSCN information with NEWCNT data
• Adds LPA/LPE pay types to UPDCAL_FUT for pay off
  amounts
• Creates job history data reportable on JOBHIS
  report
• Deletes new contract data from NEWCNT

12
DELETE Option
13
DELETE Option

• Deletes new contracts from NEWCNT
• Mass delete of new contracts
• Useful for early salary notices based on old rate
• No need to use for normal purge functions

14
REPORT Option
15
REPORT Option

• Generates report
• Reports all NEWCNT data
• MAINT
• BUILD
• Summary report
• Detail report

16
IMPORT Option
17
Import Option

• Allows import of data from outside source
• Spreadsheets
• Third party vendor salary schedules
• CSV (comma separated values)
• Tab delimited
• Free format of data

18
Import Option

• Fields required in load file
• Employee ID
• Job number
• Contract type
• All calculations are completed as if the MAINT
  option was used
• Pay per period
• Retro amounts
• Etc.

19
Import Option Example CSV
20
Import Option Example
21
NEWCNT Calculations

• Contract Obligation
• Amount earned plus amount to be earned plus full
  retro earned
• Contract Amount Earned
• Days worked times daily rate
• Contract Amount Due
• Contract amount earned minus the amount paid

22
NEWCNT Calculations

• Pay per period
• Obligation minus amount paid minus amount docked
  divided by remaining pays
• Daily rate
• Contract amount divided by total days
• Dock next pay (lump sum retro)
• Full pay per period minus old pay per period
  times pays paid negative result

23
NEWCNT Calculations

• Retro next pay (lump sum retro)
• Full pay per period minus old pay per period
  times pays paid positive result
• Rounding
• All intermediate calculations use 5 decimal
  places
• The rounding is processed at the end of all
  processing
• Based on rounding flag in USPCON

24
NEWCNT Fields Defined

• Days since raise
• Must be greater than zero for retro payments
• Must be less than or equal to days worked
• Used to calculate retro earned
• Contract obligation
• Amount district owes to employee

25
NEWCNT Fields Defined

• Contract amount
• Location of current job on the salary schedule
• Total contract that could be payable to the
  employee for job

26
Purging Of New Contract Data

• When to purge for new contract
• Timing is everything
• Before last pay of old contract is ideal
• After last pay can cause incorrect data and
  manual updates

27
NEWCNT Purge Example
28
NEWCNT Purge Example
29
NEWCNT Purge Example
30
NEWCNT Purge Example
31
NEWCNT Purge Example
32
NEWCNT Purge Example
33
NEWCNT Purge Example
34
NEWCNT Purge Example

• If neither option is used
• Days from 8/26/2002-8/30/2002 are lost
• Amount earned incorrect
• Accrued wages incorrect
• Days worked incorrect

35
NEWCNT Purge Example
36
NEWCNT Purge Example
37
NEWCNT Purge Example
38
NEWCNT Purge Example
39
NEWCNT Purge Example
40
NEWCNT Purge Example
41
RESET NEWHIRE DATE

• The Reset New Hire date field applies to NEW
  Contracts only, and offers the following options
  
• Y ODHS new hire date field will be updated
  using the value entered in NEWCNT/MAINT or the
  contract start date. The new hire reported
  flag in in BIOSCN will be reset to allow the
  employee to be reported through the NEWHIRE
  program.
• N The new hire date field will be left as-is in
  JOBSCN. Even if a different date has been entered
  in NEWCNT/MAINT, the date from USPSCN/JOBSCN will
  not be updated. The new hire reported flag will
  not be reset.

42
MID YEAR

• CONTRACT
• CHANGES

43
Purging Of New Contract Data

• When to purge for a mid-year change
• Effective at period begin date is ideal
• Mid pay period mid-year contract changes cant be
  done with NEWCNT, manual updates are necessary
• Doesnt currently work if zero days worked

44
Purging Of New Contract Data

• Pay one beyond mid pay period change and retro
  pay
• Retro effective 3/3/2003
• Payroll dates 2/23 3/8 pay date 3/14/2003
• Complete 3/14 payroll at old rates
• Prior to 3/28 payroll
• Mid-year contract change with retro
• Process retro for 5 days (3/3 3/7)
• No manual updates

45
NEWCNT Functions Clarified

• Using the Clear function
• Should be used only for new contract type
• Adding an employee new to district
• Use JOBSCN rather than NEWCNT
• Contract start date
• Used to calculate LPE/LPA amounts correctly
• Should be first physical day of work