How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?

Summary:

I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management - Reported Time Cards Real Time" subject area, and they match the data on the "Team Time Cards" screen. However, we need the flexibility of a data model.

Content (please ensure you mask any confidential information):

 I have attempted to use the view titled “HWM_EXT_TIMECARD_DETAIL_V”, and although it works for most employees, it does not work for all employees.  Can someone provide me with a query that will pull the same ABSENCES and TIME_RPTD data that the “Team Time Cards” screen in Oracle pulls?  For some reason, I am having issues with absence records pulling twice because they have both TIME_RPTD and ABSENCES layer code, which is causing them to pull more than once. I am also having issues with old data pulling for some employees who changed their timecard, even though I added criteria to only pull