CODE

DATA TYPE

DEFAULT

Description/ Hint

Options/ Examples

AWARDCATEGORY

int

award name

DAYOFWEEK

char (20)

What day of the week or public holiday?

MONDAY-SUNDAY, PUBLIC HOLIDAY

NSTART

600

What time of day do our ordinary hours begin?

Numerical Value EG 600 = 6am

NSTARTRATEB

DISABLED

NFINISH

1800

At what time of day does day rate or ordinary hours stop?

Numerical Value EG 1800 = 6pm

NHOURS

decimal (18, 2)

8

Total length of daily ordinary hours before OT starts

Numerical Value EG 8 = 8 hours

NHOURSRATEB

decimal (18, 2)

Can be used to trigger x number of hours of rate B aslong as it's contained within the NHOURS

Numerical Value EG 2 - will trigger first two hours to be paid at rate B and remaining NHOURS will be paid at normal rate

OT_HOURS

decimal (18, 2)

How many hours at the first overtime (OT1) rate before the second overtime (OT2) rate starts?

Numerical Value EG 2 = 2 hours

VOLNORMHOURS

decimal (18, 2)

Alternative to NHOURS (triggered in usevolhoursalways in Award Primary Rules)

Numerical Value EG 10 = 10 hours 

VOLNORMHOURSRATEB

decimal (18, 2)

Alternative to NHOURSRATEB  (triggered in usevolhoursalways in Award Primary Rules

Numerical Value EG 1 = 1 hour 

VOLOTHOURS

decimal (18, 2)

Alternative to OT_HOURS  (triggered in usevolhoursalways in Award Primary Rules

Numerical Value EG 0 = All OT hours charged at OT2 

NIGHTNORMHOURS

decimal (18, 2)

Total length of night ordinary hours before overtime rate starts?

Numerical Value EG 4 = 4 hours

NIGHTNORMHOURSRATEB

decimal (18, 2)

Can be used to trigger x number of hours of rate B aslong as it's contained within the NIGHTNORMHOURS

Numerical Value EG 2 = Pay first 2 hours at rate B (OT1) and pay remaining NIGHTTNORMHOURS at normal rate

NIGHTOTHOURS

decimal (18, 2)

How many hours at the first overtime rate (OT1) before the second overtime rate (OT2) starts?

Numerical Value EG 2 = First 2 NIGHTOThours to be paid at OT1 before OT2 rate begins or 0 = all NIGHTOT hours to be paid at OT2

MAXHOURSNOTAUTHORISED

int

What is the maximum amount of overtime hrs you want to pay without authorizing it?

Numerical Value EG 4 = 4 OT hours will be paid without authorization

OTIFNOLUNCH

decimal (18, 2)

How many hours onsite if an employee hasnt had a break do you start paying and charging the second overtime rate (OT2)?

Numerical Value EG 1 = 1 hour

OTNOTONLATELUNCH

int

0

DISABLED

MINIMUMHOURSPERJOB

decimal (18, 2)

4

What is the minimum amount of pay or billing hours per job/day?

Numerical Value EG 4 = 4 hours

NIGHT1800RATES

int

What rates are you paying your employees before and after Fridays 1800,  Saturdays and Sundays?

Setting of 1 can be applied  -

If the shift begins after 18:00 on Fridays then Saturday rates can be billed/paid for the entire shift                                        

If the shift begins on Sunday and goes into Monday morning then Sunday rates can be billed/paid for the entire shift

If the shift begins after 00:00 on Mondays then Sunday rates can be paid/billed before 06:00

If the shift begins on Saturday and goes into Sunday morning then Saturday rates can be billed/paid for the entire shift

If the shift begins after 00:00 on Mondays then Sunday rates can be paid/billed before 06:00

Setting of 2 can be applied

If the shift begins before 18:00 on Fridays then Saturday rates can be paid/billed after 18:00

If the shift begins after 18:00 on Sundays then Night rates can be billed/paid for the entire shift

If the shift begins before 06:00 on Saturdays then Night rates can be paid before 06:00

Setting of 3 can be applied: ( 13 is now preferred )

If the shift begins after 18:00 on Fridays then Night rates can be billed/paid for the entire shift

Setting of 4 can be applied:

If the shift begins after 18:00 on Fridays then Saturday rates can be paid only after 00:00

Setting of 5 can be applied:

If the shift begins on Saturday then WeekDay rates can be billed/paid for the entire shift

Setting of 6 can be applied:

If the shift begins on Saturday then did they cross over into true OT but the hard 2 hours @ 1.5 rule is in place

Setting of 7 can be applied:

If the shift ends on Weeknights (Monday to Friday) then billing will shift all OT to Sunday Rate

Setting of 10 can be applied:

If the shift begins before day start on Weekdays (Monday to Friday) then billing/payroll can exclude Night rates from Ordinary/OT calculations for the entire shift - basically ordinary time begins at 06:00 and ATnonCore rate will apply for the portion before day start

Setting of 13 can be applied:

If the shift begins after 18:00 on Fridays then Night rates can be billed/paid for the entire shift - same as 3 but will aggregate any daytime component into night rate

Setting of 20 can be applied:

If the shift begins on Weekdays (Monday to Friday) then billing/payroll can split Night rates from Ordinary/OT calculations for the entire shift - basically the Day portion is calculated separately from Night meaning two possible active Ordinary/OT components using a hard cut at nStart and nFinish

MAJORITYRATESOFPAY

int

Can be used to pay an employee majority rate of pay.

For example, if an employee started work at 0530 (ord. hrs start time 0600) and worked 7.5 hours, pay all at normal rates instead of 7 hrs normal and 0.5 at the first overitme rate (OT1)

Setting of 1 = straight majority rates of pay but allow OT

Setting of 2 = majority rate of pay but replace OT1 with OT2 if we apply a night majority

Setting of 3 = majority rate of pay for AWU NSW Day/Night worker if Day then Pay Night as OT, if Night then Pay Day as OT

Setting of 4 = majority rate of pay for Night into Day ONLY

Setting of -2 = normal afternoon shifts extending into night, OT paid at double time instead of day conditions