How to find the contexts required for a Payroll Balance and Dimension
Do you know how to find the contexts required to fetch a payroll balance dimension? Read on to know more details.
All posts on Sample SQL Queries
SQL Query to get the User status and assignment information
Do you know how to get the user status and his/her assignment details? Read on to know more details.
SQL Query to pull Legal Employer and Enterprise Hire Dates
Do you know the importance of Legal Employer and Enterprise Hire dates? How do you pull them using SQL Query? Read on to know more details.
SQL Query to pull Assigned Payrolls Information
Do you know how to load the AssignedPayrolls and extract that information from the HCM system? Read on to know more details.
How to resolve column splitting into multiple rows issue in BI Publisher?
Do you know how to resolve the issue of columns merging into multiple rows? Can the template be fixed to handle this issue? Can we get .xlsx output format? Read on to know more details.
SQL Query to get the Payroll Definition Config Information
Do you know how to extract the Payroll Definition information from HCM? Read on to know more details.
SQL Query to find Worker Count by Person Type
Do you know how to query the worker count by Person Type? Read on to know more details.
How to refer candidates in ORC and track them?
Do you know how to refer a candidate in ORC? How do you track the referrals in the system? Read on to know more details.
How to fetch the flattened Supervisor Hierarchy for employees using SQL Query?
Do you know how to fetch the flattened supervisor hierarchy for employees using SQL Query? Does the query work if there are multiple levels? Read on to know more details.
How to translate BI Report Output to other languages?
Do you know how to translate the BI Publisher Output to languages other than English? How to derive the language dynamically based on user? Read on to know more details.