BIP – Extract absence type schedule hierachy start point

While defining absences, schedule hierarchy start point can be defined to tell the system from where to pick the working days for a person.

Once the values are defined, you can use below query to validate if setup has been defined correctly:

select * from ANC_ABSENCE_TYPES_F
WHERE LEGISLATION_CODE IN ('US','GB','CA','CO')
and DUR_CALC_BASIS is not null
order by LEGISLATION_CODE