Status

Formula

[OpenInputValueBlock]

IF (@ISDESC("New Employees"))

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

IF ([FiscalOffset] == 0)

IF ("Cal TP-Index">= "BegBalance"->"Start Month")"Status" = [Status.Active];

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

IF ("Fiscal TP-Index">= ("BegBalance"->"Start Month" - [FiscalOffset]))"Status" = [Status.Active];

ENDIF

ELSEIF ("Fiscal TP-Index">= ("BegBalance"->"Start Month" + [NumberOfPeriodsInYear] - [FiscalOffset]))"Status" = [Status.Active];

ENDIF

ENDIF

ELSE

IF ("Action" == [Status.TransferIn])"Status" = [Status.Active];

ELSE"Status" = "Action";

ENDIF

IF("Status" == #MISSING)"Status" = @PRIORS(SKIPMISSING, "Status");

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates the employee’s status based on last action applied. Status determines whether an employee is paid.