Hi
We have changed our licensing agreement recently and I’m developing a report to show our full user licence holders. I also wanted to add a column to show employees that utilise the Time Clock CTU lincence in IFS Apps 9.
My guess was that it looked for a tick in the box for ‘Time & Attendance’ in the Person Terminal Data tab of the Employee Admin screen AND that the employee needs to be currently employed. I get an extra 400+ records of the reported licence usage with this SQL…
select * from terminal_person
where TIME_AND_ATTEN = 'TRUE'
and EMP_NO IN (Select EMP_NO from PERSON_PUBLIC_HR_INFO)
;Any idea what other criteria the licence management area applies to further reduce my results?
