The physical-card metaphor became a database. Each HOLCOUP record represented half a day of leave and carried the dates needed to trace its entire life.

I built the leave card inside the AS/400 as a database record. The attendance system could issue it, assign its use date, invalidate it when necessary, and preserve the history.

I named the file HOLCOUP: HOL for holiday, COUP for coupon. It was a database of leave coupons.

  • Employee code
  • Leave code
  • Allocation date
  • Validity start date
  • Validity end date
  • Use date
  • Use portion: full day, first half, or second half
  • The date or event that justified the allocation

Because half-day leave was permitted, one record represented half a day of entitlement. An employee with twenty unused paid-leave days therefore held forty unused coupon records.

It may sound obvious once described. At the time, it was the essential step that turned a complicated real-world right into data the AS/400 could manage transparently.

WRITTEN BYYoshio Taki

A systems engineer who loves IBM i / AS/400

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

Chapter 3 index · All 35 stories