Hi All,

I’m trying to do same data analyses about direct/indirect hours, therefore i tried accessing data which is shown in screen “Time Registration”. View TIMMAN_JOB_TRANS.

I did this by the use of PL/SQL dev. I had not all te results i expected, so i viewed the time registration for another employee in IFS. After i had checked that in IFS, that employee also showed up as result in PL/SQL. So, it seems like the data is stored in the view afther i;'ve viewed it in IFS.
 

Does anyone have an idea how to be able to see the data without opening the time registration screen for every employee one by one in IFS?

Or any suggestions for another view is also welcome

this is the SQL query:
 

select COMPANY_PERSON_API.Get_Internal_Display_Name(Company_id,EMP_NO),ifsapp.TIMMAN_JOB_TRANS_status.*
from TIMMAN_JOB_TRANS_STATUS
where company_id='***'
and account_date= DATE'2024-01-29'
and (HOURS_DAY1 >0)