EMPLOYEES HOLIDAY CALENDAR LIST (Core HCM)
Introduction: This SQL query is used to fetch the Holidays list for Employees like Employee number, Holiday name, Start date, End date etc… Cause of the issue: Business wants a…
Read MoreEMPLOYEE SALARY DETAILS QUERY (Core HCM)
Introduction: This SQL query is used to fetch the data of Employees Salary details (CTC)like Annual salary, Fixed CTC, Employee number, DOJ, Base element name etc .. Cause of…
Read MoreEMPLOYEE WORK SCHEDULE UPDATE (Core-HCM)
Introduction: This SQL query is used to fetching the data of Employees Work Schedule changes like Work Schedule id, Name etc… In this Last update date is used as…
Read MoreEMPLOYEE ASSIGNMENT UPDATE (Core-HCM)
Introduction: This SQL query is used to fetching the data of Employees Assignment changes like Manager change, location change etc… In this Last update date is used as a parameter…
Read MoreEmployee Revoke (Core Hr-HCM)
Introduction: This SQL query is used to fetching the data for Employees who are Revoked means cancelled the termination those employees will fetch based on last update date. SQL…
Read MoreWheebox Assessment tests (ORC-HCM) Query
Introduction: This SQL query is used to fetching the data for candidates who are applied various assessment tests (Wheebox) at the time of recruiting like one candidate can apply two…
Read MoreFusion HCM Candidate Query
Introduction: This SQL query is used to fetching the data for candidates who are attended various assessment tests at the time of recruiting. In this assessment name is used as…
Read More