How to fetch the Employee Degrees from the Skills and Qualifications screen?
Do you know how to fetch the Employee Educational details/degrees from the Talent Profile tables? Read on to know more details.
All posts on Sample SQL Queries
How to check the Approval Rule status using BI Report?
Do you know how to fetch the Approval Rule status using BI Report? Can we retrieve the list of all Approval rules that exist in the system? Read on to know more details.
How to get Dynamic Default for Payroll Period LOV based on the system date?
Do you know how to assign default values to a BI input parameter based on the system date? Read on to know more details.
How to extract the Element Eligibility Info from Element Config?
Do you know how to extract the element eligibility information and the criteria that has been defined as part of Element Config? Read on to know more detials.
How to fetch the Employee Social Insurance Calculation Card details for AE legislation?
Do you know how to fetch the Employee Social Insurance Calculation Card details for the AE Legislation using SQL Query? Read on to know more details.
How to get the list of all BI Reports from an instance?
Do you know how to extract list of BI Reports from an instance? Read on to know more details.
SQL Query to fetch Costing of Payroll information
Do you know how to fetch the costing of Payroll information? Read on to know more details.
SQL Query to fetch Costing of Persons information
Do you know how to fetch the Costing of Persons information? Read on to know more details.
SQL query to fetch Position Costing information
Do you know how to fetch Position Costing information using BI Report? Read on to know more details.
How to bulk inactivate the Document Types using HDL?
Do you know how to inactivate the document types in bulk using hdl? Read on to know more details,