Hello! Can anyone help me? What are the tables that contain the information in the Time module?
Hi Leonardo,
Have a look at
Oracle Fusion Cloud HCM Tables and Views for HCM G26438-01 25B
https://docs.oracle.com/en/cloud/saas/human-resources/25b/oedmh/index.html
Chapter 27 Time and Labor
Also use SQL to query the following 4 subject areas to get information about business process "Report Time", "Approve Time", and "Transfer Time" of approved timecards to payroll and expenses (processed timecards).
Oracle Fusion Cloud HCM Subject Areas for Transactional Business Intelligence in HCM G26460-01 25B
https://docs.oracle.com/en/cloud/saas/human-resources/25b/faohb/Workforce-Management-Reported-Time-Cards-Real-Time-SA-274.html
Workforce Management - Reported Time Cards Real Time Workforce Management - Processed Time Cards Real Time Workforce Management - Historical Reported Time Cards Real Time Workforce Management - Historical Processed Time Cards Real Time
Review the data lineage to review what presentation tables and columns in the metadata repository database (logical) are available to query along with their mapping to view objects to the source transaction tables and views in the application database (physical). Use View Log on page Issue SQL or Manage Sessions to view the sql generated for your query along with data security where clauses added.
HWM_TM_REC_GRP
https://docs.oracle.com/en/cloud/saas/human-resources/25b/oedmh/hwmtmrecgrp-7973.html
