Skip to main content

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?

 

Hi,

As far as I know, it depends on below check box: 

 

Best regards,

Martin

Thanks Martin. Yes, I had forgotten about the General tab 😀

I’m still 50+ records over when using that view and based on current employees, but it’s nearer the mark

Thanks

Reply


Terms & ConditionsCookie settings