Before granting annual paid leave, the system had to determine whether the employee met the statutory attendance threshold. Even defining the denominator was real work.

Under Japan’s Labor Standards Act, annual paid leave is tied to an attendance rate of at least 80 percent of total working days during the relevant period.

That sounds like one division problem. First, however, the system must determine each person’s required working days. The number can vary by department, location, secondment arrangement, and working pattern.

A seconded employee might follow a workplace where Saturday was a half day. Our rules even allowed half-day paid leave on such a half-day schedule. The data therefore included values such as 243.5 days rather than neat integers.

The numerator was not simply days physically present. Paid leave, maternity leave, childcare leave, and other categories may count as attendance for this purpose.

Attendance rate = qualifying attendance ÷ required working days.

The formula was easy. Defining both sides was not.
WRITTEN BYYoshio Taki

A systems engineer who loves IBM i / AS/400

CHAPTER 03 · PART 02 · EPISODE 8 / 9 STORIES · 35 STORIES TOTAL

Chapter 3 index · All 35 stories