Overtime

Formula

[OpenInputValueBlock]

IF (NOT @ISUDA([Dimension("DIM_NAME_SCENARIO")], "ACTUAL"))

IF (@ISDESC("New Employees"))

IF ("BegBalance"->"Start Month" != #MISSING)

IF ([FiscalOffset] == 0)

IF ("Cal TP-Index">= "BegBalance"->"Start Month")"Annual Overtime" * [TimeBalanceSpread];

ELSE

#MISSING;

ENDIF

ELSEIF (("BegBalance"->"Start Month" - [FiscalOffset]) > 0)

IF ("Fiscal TP-Index">= ("BegBalance"->"Start Month" - [FiscalOffset]))"Annual Overtime" * [TimeBalanceSpread];

ELSE

#MISSING;

ENDIF

ELSEIF ("Fiscal TP-Index">= ("BegBalance"->"Start Month" + [NumberOfPeriodsInYear] - [FiscalOffset]))"Annual Overtime" * [TimeBalanceSpread];

ELSE

#MISSING;

ENDIF;

ELSE

#MISSING;

ENDIF;

ELSE

IF (@ISMBR("BegBalance"))

#MISSING;

ELSE

IF (("Annual Overtime" == #MISSING) OR ("Status" == [Status.Departed]) OR ("Status" == [Status.Resigned]) OR ("Status" == [Status.TransferOut]) OR ("Status" == #MISSING))

#MISSING;

ELSEIF ("Status" == [Status.LeaveOfAbsence])

0;

ELSEIF ("Status" == [Status.Maternity])

0.65 * "Annual Overtime" * [TimeBalanceSpread];

ELSE"Annual Overtime" * [TimeBalanceSpread];

ENDIF

ENDIF;

ENDIF;

ENDIF;

[CloseInputValueBlock]

Description

Calculates overtime for new and existing employees. Existing employees’ overtime takes employee status into account.