Employee balances

The EMBAL_DELTA field is used to change or cancel employee balances. The Employee Import process can change or cancel multiple employee balances.

Changing employee balances

This is the format for changing an employee balance field: 

{Balance_Name}~{Value}~{Action}

{Action} can be SET or ADD.

Balance {Value} can have a maximum of three decimal places.

The {Balance_Name} (for example, VACATION) must exist in the application. Otherwise, the system rejects the entire record and generates an error message.

For example, to set an employee's vacation balance to 15, this string, including the tilde (~) symbols, is required: 

VACATION~15~SET

Cancelling employee balances

This is the format for cancelling an employee balance: 

{Balance_Name}~~{CANCEL}

If a value is specified for the CANCEL action, a warning message is generated. The specified value is ignored.

When an employee balance is cancelled, the overrides for that balance that start on the Ovr_Start_Date for that employee are cancelled (if such an override exists).

If an override is not found, then the system rejects the row and generates an error message.

For example, to cancel an employee's vacation balance, this string, including the tilde (~) symbols, is required: 

VACATION~~CANCEL