How to fetch the Delegated or Proxy Users?
Do you know how to identify the Delegation of Roles and Approvals setup by Employees and who is the serving as proxy for whom? Read on to know more details.
All posts on Sample SQL Queries
How to fetch Grade Ladder details and Grades in Ladder?
Do you know how to fetch the Grade Ladder details and Grades that are added to Grade Ladder? Read on to know more details.
How to extract Grade Rate details from backend tables?
Do you know how to fetch the Grade Rates from backend tables? Read on to know more details.
How to get the Flow Instance Name using Payroll Action ID from BI History?
Do you know how to get the Flow Instance Name from the Payroll Action ID? From BI Report History we can get the Payroll Action ID for all HCM Extract related reports and Payroll Processes like Pay Check, EFT and Payslips etc. Read on to know more details.
How to fetch Element Definition load errors using SQL Query?
Do you know how to get the element definition load errors? How to resolve the issues? Read on to know more details.
How to query the HCM Extract Errors?
Do you know how to extract the HCM Extract errors? Where would you check the errors of the extract on the application? Read on to know more details.
How to get the count of data loaded from multiple tables post-data conversion?
Do you have to get the data counts from multiple tables in an easy way? Have you reconciled data post data conversion? Read on to know more details.
How to get the Audit History of the changes done by a user?
Do you know how to access the audit history of table level changes done by a user? Read on to know more details.
How to get list of Fast Formulas used in HCM Extract?
Do you know how to get the Fast Formulas used in a HCM Extract? If there are multiple Data Groups and multiple Records, it will be tough to get the list manually? This SQL query comes as a saviour in those tough times to get the list easily. Read on to know more details.
How to extract the Sandbox, features enabled, and published status?
Do you know if there is a way to extract the sandbox details and what all sandboxes are published recently? Who published them? Read on to know more details.