Item

Data Type

Default

Description/ Hint

Options/ Examples

Reference

Billing

Payroll

Rostering

Reporting

MaxCrewCount

int

2

Max amount of persons per crew (unless changed by client override)

Numerical Value of 1 to 6 (maximum 6 man crew)

a value of -1 will force non crew billing for crew based clients

a value below -1 will force crew billing without a driver shift for crew based clients

Yes

MinHoursPerWeek

int

Cas 1, PPT 16,       FT 38

The minimum hours an employee of a particular pay type should be rostered each week

Note: Lock To Minimum hours operates on this figure when rostering so must be ticked to be effective

EG. FT 38 = Full Time Min 38 hrs per week, PPT 16 = Permanent Part Time Min 16 hrs per week, Cas 1 = Casual min 1 hr per week

Yes

Yes

DaysStraightBeforeDayOff

int

13

Maximum amount of days that an employee can work in a row

Note: ManStat will not allow employee to be rostered day after limit is reached

Note: ManStat will not allow employee to be rostered day after limit is reached

Numerical Value EG 6 = Maximum 6 days worked in a row

Yes

Yes

NormalShiftHours

decimal (18, 2)

8

Usual shift length

Numerical value EG 8 = 8 hours

Yes

NormalBreakBetweenShiftsHours

int

10

Time that must be given between shifts

Note: Manstat will flag that employee can not be rostered until break time up

Numerical Value EG 10 = 10 hours

Yes

Yes

ConsecutiveShiftLimit

int

0

Break between consecutive shifts (in minutes) before overtime rules are reset

Setting of -1- Turns off all consecutive shift calculations including progressive hours                

Setting of  0 - All shifts beginning in the same calendar day will be considered consecutive

Numerical Value > 0 - Treat as separate shifts if break between shifts is above x minutes  EG 559 =  10hrs

Yes

HoursPerWkBeforeOvertimeStarts

decimal (18, 2)

38

Number of ordinary hours to be worked in a week before overtime rules start

Numerical Value EG 38 = 38 hours

Yes

OvertimeAllowed

int

1

Is overtime Allowed?

Setting of 1=Yes

Setting of 0 = No

OT

Yes

OvertimeHoursAllowed

decimal (18, 2)

2

How many overtime hours are allowed?

Numerical Value EG 2 = 2 hours

OT

Yes

CombineOT

int

1

Is overtime to be calculated and combined into a single rate?

Setting of 1= Yes

Setting of 0= No

EG For Billing, everything becomes OT1. For Payroll, travel included into OT calculations

OT

Yes

WeeklyOT1

decimal (18, 2)

2

How many hours are paid at the first overtime rate after all ordinary hours are used

Numerical Value EG 2 = 2 hours at OT1 before OT2 charged

OT

Yes

ExcludeWeekendsFromOT

tinyint

0

Do you want to exclude weekends from running total overtime calculation? (Set in hoursperweekbeforeotstarts)

Setting of 0 = No

Setting of 1 = Yes

Setting of 2 = Friday night treated like weekend

Weekend

Yes

UseVolHoursAlways

int

0

Do you want to use the Voluntary Hours set up in this award, in all circumstances instead of normal day and night hours settings

Setting of 1=Yes

Setting of 0 = No

Vol

Yes

ForcedDaysOffWhenOvertimeReached

int

2

How many days must be taken off when overtime is reached

Numerical Value EG 2 = 2 days

Yes

MustTake2ndDayOffIfRosteredForDayOff

smallint

0

Do you want to force a second day off if not rostered on a given day? (Sunday is a free day)

Setting of 1=Yes

Setting of 0 = No

Yes

BasePayCost

decimal (18, 2)

Base pay rate for ordinary hours

Numerical Value EG 25.90 = 25.90 per hour. Used for reporting purposes only

Yes

NCorePayCost

decimal (18, 2)

 Base pay rate for night hours

As above

Yes

SatOT1PayCost

decimal (18, 2)

 Base pay rate for OT1

As above

Yes

SunOT2PayCost

decimal (18, 2)

 Base pay rate for OT2

As above

Yes

ATNormal

char (31)

Paycode for Ordinary Hours / Billing for Day Rate

*Assign a paycode to Ordinary Hours EG CA@NORM (Casual at normal rate)

Note paycodes prefixed with UNP_ or billing codes prefixed with UNB_ will create no output during generation of pays or invoices

Ordinary

Yes

Yes

ATNormalB

char (31)

Paycode for Normal B Rate

 As Above  EG CA@NORMB

Ordinary

Yes

Yes

ATNonCore

char (31)

Paycode for Night Hours / Billing for Night Rate

 As Above

Night

Yes

Yes

ATNonCoreB

char (31)

 Paycode for Night OT hours

  As Above

Night

Yes

Yes

ATNonContinuousNight

char (31)

Paycode for Night Hours - if using different rules for night time work that is consecutive and non-consecutive

  As Above

Night

Yes

Yes

ATNonContinuousNightB

char (31)

 Paycode for Night Hours - if using different rules for night time work that is consecutive and non-consecutive - rate B

  As Above

Night

Yes

Yes

AT15

char (31)

Paycode to pay time and a half overtime

  As Above

OT

Yes

Yes

AT20

char (31)

Paycode to pay double time overtime

  As Above

OT

Yes

Yes

AT25

char (31)

Paycode double time & a half overtime

  As Above

OT

Yes

Yes

ATSat

char (31)

Paycode to pay Saturday (when it is ordinary hours)

  As Above

Weekend

Yes

Yes

ATSatB

char (31)

Paycode to use if the Saturday rate changes after a certain time

  As Above

Weekend

Yes

Yes

ATSun

char (31)

Paycode to use to pay Sunday (when it is ordinary hours)

  As Above

Weekend

Yes

Yes

ATSunB

char (31)

Paycode to use when Sunday rate changes after a certain time.

  As Above

Weekend

Yes

Yes

ATPH

char (31)

Paycode to use when paying Public Holiday rate

  As Above

PH

Yes

Yes

ATPHNW

char (31)

Paycode to pay a public holiday that is not worked

  As Above

PH

Yes

Yes

ATMeal

char (31)

Paycode for Meal Allowance

 Assign paycode for Meal Allowance EG MEAL

Meal

Yes

Yes

NoLunchMealAllow

decimal (18, 2)

How much time needs to pass if lunch is not taken, for a meal allowance to be paid?

Numerical Value EG 5 = 5 hours (Usually 5)

Meal

Yes

Yes

ATMeal2

char (31)

Paycode for OT Meal Allowance

Assign paycode for OT Meal Allowance EG OTMEAL

Meal

Yes

Yes

OTMealAllow

decimal (18, 2)

Length of shift at which meal allowance is payable

Numerical Value EG 9.5 = 9.5 hours (Usually 9.5)

Meal

Yes

CostNoLunchMealAllow

 INACTIVE

Meal

Yes

Yes

CostOTMealAllow

 decimal (18, 2)

 INACTIVE

Meal

Yes

IncludePaidMealsInCalcs

int

Include paid meal breaks taken in OT and allowance calculations

Setting of 1=Yes

Setting of 0 = No

Meal

Yes

ForceOrIgnoreMBMinutesDay

int

0

How many minutes of meal break to ignore or force?

Setting of 0 = pay exactly what is verified

Setting of - 30 = pay through the break (usual setting)

Setting > 30 = enforce a non paid break (up to the number entered)

Meal

Yes

Yes

ForceOrIgnoreMBMinutesNonCore

int

0

How many minutes of meal break on night shift to ignore or force?

As Above

Meal

Yes

Yes

ForceOrIgnoreMBMinutesSat

int

0

How many minutes of meal break to ignore or force on Saturday

As Above

Meal

Yes

Yes

ForceOrIgnoreMBMinutesSun

int

0

How many minutes of meal break to ignore or force on Sunday

As Above

Meal

Yes

Yes

ForceOrIgnoreMBMinutesPHol

int

0

How many minutes of meal break to ignore or force on Public Holiday

AS Above

Meal

Yes

Yes

MB1

decimal (18, 2)

Time for first crib break (smoko)

24 hour time EG 1000 = 10am

ATBreak1

char (31)

Paycode for Crib Break

Assign a paycode for Crib Break EG CBREAK1

Meal

Yes

MB2

decimal (18, 2)

Time for second crib break (smoko)

24 hour time EG 1500 = 3pm

Meal

Yes

ATBreak2

char (31)

Paycode for second crib break (if different amount from first)

Assign a code to second crib break EG CBREAK2

Meal

Yes

PPTOT2CAS

int

Should permanent part time overtime be paid at the casual rate?

Setting of 1=Yes

Setting of 0 = No

OT

Yes

ATCasNormal

char (31)

Paycode for Permanent Part Time overtime paid at casual rates - Normal

Only assign this paycode if PPT employees will be paid casual overtime rates

EG T@CASNORMAL

OT

Yes

ATCasNonCore

char (31)

Paycode for PPT overtime paid as Casual - Night

As Above

OT

Yes

ATCasSAT

char (31)

Paycode for PPT overtime paid as Casual - Sat

As Above

OT

Yes

ATCasSUN

char (31)

Paycode for PPT overtime paid as Casual - Sun

As Above

OT

Yes

ATEBAAllow

char (31)

Code for allowance paid per award

Assign a paycode for allowances in award EG CA@FLEX (Casual Flexitime) FT@RDO (Full Time RDO)

Allowance

Yes

ATEBAType

int

Special Allowances ie First Aid Allowance, RDO

Setting of 1 = Ordinary hours for hourly allowance

Setting of 2 = All hours First 38 (max 38)

Setting of 3 = Ordinary hours *-0.1 FOR FLEXI TIME/RDO (36 hour week)

Setting of 4 = Ordinary hours *-0.05 FOR FLEXI TIME/RDO (38 hour week)

Setting of 5 = M-F normal hours *-0.1 FOR FLEXI TIME/RDO (36 hour week)

Setting of 6 = M-F normal hours *-0.05 FOR FLEXI TIME/RDO (38 hour week)

Setting of 7 = M-F normal hours for hourly allowance (38 hour week)

Setting of 8 = M-F normal hours *-0.8 hours per shift FOR FLEXI TIME/RDO (36 hour week)

Setting of 9 = M-F normal hours *-0.4 hours per shift FOR FLEXI TIME/RDO (38 hour week)

Setting of 10 = All hours per hour - &NS in code will trigger Super/NoSuper segmentation

Allowance

Yes

ATGrade1

char (31)

Paycode to be paid for a Grade 1 Allowance

 Assign a paycode to grade 1 allowance EG CA@G1A

Allowance

Yes

Grade1max

decimal (18, 2)

How many hours in the week before Grade 1 Allowance stops

Value > 1 EG 38 = 38 hours

Value of -1 for daily

Allowance

Yes

ATGrade2

char (31)

Paycode to be paid for a Grade 2 Allowance

 Assign a paycode to grade 2 allowance EG CA@G2A

Allowance

Yes

Grade2max

decimal (18, 2)

How many hours in the week before Grade 2 allowance stops

Value > 1 EG 38 = 38 hours

Value of -1 for daily

Allowance

Yes

ATGrade3

char (31)

Paycode to be paid for a Grade 3 Allowance

 Assign a paycode to grade 3 allowance EG CA@G3A

Allowance

Yes

Grade3max

decimal (18, 2)

How many hours in the week before Grade 3 allowance stops

 Value > 1 EG 38 = 38 hours

Value of -1 for daily

Allowance

Yes

AllowPayLevelShift

int

0

Allow dockets to be flagged to pay a shift at a level other than that set against the employee (if allowed in award)

Seting of 0 = No

Setting of 1 = Increase Paylevel by 1 for A and 2 for T in flag

Setting of -1 = Set Paylevel to x for Tx in flag

Setting > 2 = Increase Paylevel by 1 for T in flags where AllowPayLevelShift is 2 or greater (if greater add difference x-2 too) i.e. =2 therefore 0/1 =4 therefore 2/3

Flag

Yes

PayLevelAllowance

char (31)

 Allowance Code

Code with prefix of N. or W.

N. xxx - Normal hours per hour allowance

W.xxx - Weekly

A. - for team leaders with amount of crew under their care in conjunction with Tx flag where x is the number of crew (qty of allowance units to pay)

H. - for team leaders with amount of crew under their care in conjunction with Tx flag where x is the number of crew. Will pay the defined allowance code at a qty equalling the total hours worked.

Allowance

Yes

PayCombineTravel

int

Forces depot-depot payment of work and travel time including OT calculation

Setting of 1 - Alters Start and Finish Times

Setting of 2 - Alters travel day rates for weekends (TravelatRealDayRate)

Setting of 3 - Will combine travel into 4hr min and/or deny daily fares

Setting of 4 - Will combine travel total hours and deny daily fares (if hours off threshold exceeded)

                   or charge itemised travel total hours at ordinary hourly rate and and deny daily fares (if hours off threshold exceeded)

                   or pay itemised travel total hours at single base hourly rate and deny daily fares (if hours off threshold exceeded)

Setting of 5 - Charge/ Pay Depot-Depot travel total hours and deny daily fares (if hours off threshold exceeded)

Setting of 6 - Pay itemised travel total hours at ordinary hourly rate and deny daily fares (if hours off threshold exceeded)

Setting of 7 - Pay combine travel into 4hr min and/or deny daily fares AND pay at applicable day rate

Setting of 8 - Same as 4 in billing but uses Alternate OT settings in award daily rules

Special setting 99 - Pay driver only Depot-Depot travel total hours and deny daily fares (if hours off threshold exceeded)

Special setting 98 applies to PIV staff only - Convert to itemised travel inclusive of OT if limits exceeded for PIV meaning OT applies to all hours paid

Travel

Yes

Yes

TravelAtDayRate

int

Is travel always paid at day rate?

Setting of 1=Yes

Setting of 0 = No

Travel

Yes

ATTravel

char (31)

Paycode for travel that is paid during normal hours

 Assign a paycode for travel that is paid during normal hours EG NORMAL

Travel

Yes

Yes

ATTravelRateB_KM

int

Should a KM allowance be paid?

Setting of 0 = No

Value > 0 = Travel radius x 2 or number of km before allowance begins (EG 50 = Pay allowance after 50kms travelled)

Travel

Yes

Yes

ATTravelRateB

char (31)

Paycode for KM allowance

 Assign a paycode to kilometer allowance EG CA@KM

Travel

Yes

Yes

ATTravelNonCore

char (31)

Paycode for travel that is paid during night shift

Assign paycode if different rate is to be paid for travel during night EG CA@TRAVELNIGHT

Leave blank to pay all travel time at day rate

Travel

Yes

Yes

ATTravelSat

char (31)

Paycode for travel that is paid on Saturdays

As above

Travel

Yes

Yes

ATTravelSun

char (31)

Paycode for travel that is paid on Sunday's

As Above

Travel

Yes

Yes

AtCrewTravelInsert

 Billing Option -Code insert for award

Travel

ATSite

char (31)

Paycode for Site Allowance (triggered in billing option site allowance pay site to staff)

Assign a paycode to site allowance EG CA@SITE

Allowance

Yes

Yes

ATTravDriver

char (31)

Pay code applicable for daily travel allowance driver

 Assign a paycode for driver travel allowance EG CA@TRAVDRIVER

Travel

Yes

DailyFaresQty

int

Are daily fares paid to driver?

Setting of 1=Yes

Setting of  0 = No

Value >1 = Qty per day

Travel

Yes

Yes

DailyFaresHoursOff

decimal (18, 2)

After how many hours travel is it paid?

 Numerical Value EG 2 = 2 hours

Travel

Yes

Yes

ATTravPass

char (31)

Pay code applicable for daily travel allowance passenger

 Assign a paycode to passenger travel allowance EG CA@TRAVPASS

Travel

Yes

DailyFaresQtyPass

int

Are daily fares paid to passenger?

Setting of 1=Yes

Setting of  0 = No

Value >1 = Qty per day

Travel

Yes

DailyFaresHOPass

decimal (18, 2)

After how many hours travel is it paid?

 Numerical Value EG 2 = 2 hours

Travel

Yes

ATTravOther

char (31)

Pay code applicable for daily travel allowance other

 Assign a paycode for daily travel allowance 'other' EG CA@TRAVOTHER

Travel

Yes

Yes

DailyFaresQtySTS

int

Are daily fares paid to STS

Setting of 1=Yes

Setting of 0 = No

Value >1 = Qty per day

Travel

Yes

Yes

DailyFaresHOSTS

decimal (18, 2)

After how many hours travel is it paid?

Numerical Value EG 5 = 5 hours

Travel

Yes

Yes

ATTravPerm

Paycode applicable for daily fares paid to a permanent driver

 Assign a paycode for daily dares paid to perm drivers EG CA@TRAVPERM

Travel

Yes

DailyFaresQtyPerm

int

Are daily fares paid to a permanent driver?

Setting of 1=Yes

Setting of  0 = No

Value >1 = Qty per day

Travel

Yes

DailyFaresHOPerm

decimal (18, 2)

After how many hours travel is it paid?

 Numerical Value EG 5 = 5 hours

Travel

Yes

ATEMEAllow

char (31)

Paycode for Emergency Allowance

 Assign a paycode for Emergency Allowance EG CA@ER

Allowance

Yes

Yes

EMErgencyType

int

 INACTIVE

Allowance

Yes

ATEMEDay

char (31)

Paycode for Emergency work - day

 As above.  EG CA@ERDAY

Allowance

Yes

ATEMENight

char (31)

Paycode for Emergency work - night

 As Above

Allowance

Yes

ATEMESat

char (31)

Paycode for Emergency work - Sat

 As Above

Allowance

Yes

ATEMESun

char (31)

Paycode for Emergency work - Sunday

 As Above

Allowance

Yes

ATEMEOT1

char (31)

Paycode for Emergency work - OT1.5

 As Above

Allowance

Yes

ATEMEOT2

char (31)

Paycode for Emergency work - OT2.0

 As Above

Allowance

Yes

AwayAllowanceType

int

Is an Away Allowance Payable?

Setting of 1=Yes

Setting of 0 = No

Allowance

Yes

Yes

ATAwayAllowance

char (31)

Paycode for Away Allowance

 Assign a paycode for away allowance EG CA@AWAY

Allowance

Yes

Yes

Code

Code

OTtoNoSuper

int

 Flat or aggregated rate modifier

Payroll

Setting of 0 = Off

Setting of 1= Sat and Sun become Night rate (NCORE)

Invoicing

Setting of 0 = Off

Setting of 1= Sat Sun OT1 OT2 become Night rate (NCORE)

Setting of 2= Sat Sun OT1 OT2 become Day rate (TD)

OT

Yes

Yes

OTtoNoSuperSuffix

char (10)

Modifies the code used by adding a suffix

OT

Yes

Yes

ATEmpGrp

char (10)

 Attache employee group

Yes

PayCostCtrA

char (10)

 Hard Coded award cost centre instead of depot based

Yes

ATLocation

char (10)

 Set an entire award to a location in Attache

Yes

ATPHB

 INACTIVE

Yes

Yes

Service Text

char (50)

 Text on the first line of an invoice

Yes

RosteringRulesSet

int

 Multiple sets of rostering rules can be changed for different awards

Yes

PassengerShiftType

int

 Changes non driver shift by using shift type number in lookup table maintenance or Reports, Master Setup, Lookup Entries, under Shift Type.. Use award primary rules Billing to change

Yes

PaySillyWeekendRate

int

Weekend/ Public Holiday Rate

Setting of 1 = Allows this rate to be paid in the instance where a shift begins before 23:59 on the day before a PH, then Public Holiday rates can be paid/billed after 18:00)

PH

Yes