This content has been marked as final. Show 2 replies
All the information you need is in the table PER_ABSENCE_ATTENDANCE_TYPES
If you see multiple records of Absence Types with the same Input Value Id, then all those use the same Element Input Value.
Just incase you are still looking for query. Here is a shortest one:-
select name as absence_type
,d_element_name as element_name