[IS_TERMINATING] - Is Terminating

22-Jan-2026 · Wing Au Yeung
其他語言版本 English

What is this?

A Yes/No question variable.

Check Whether the Placement is terminated within the Pay Period.

What will the Value be Returned?

Y - if the Placement is terminated(have End Date with Termination Reason) within the Pay Period.

N - if the Placement is active

Usage

Hightlight part content can be changed

1. Basic Form

Check single Placement Type.

If the condition is correct, return the 1st value. Otherwise, returns the 2nd value.

Payroll Variable Description Usage
[IS_TERMINATING] Check whether the Placement is terminated within the Pay Period Only Staff is not terminated would have HKD 1,000 allowance
IIF ('[IS_TERMINATING]'='Y',0,1000)

2. Parameters/Variations

Parameters/Variations Description Usage
TERMINATION_REASON_CODE=Termination Reason Code Check the Termination Reason [IS_TERMINATING(TERMINATION_REASON_CODE=00)]