All posts on Sample SQL Queries
Do you know how to fetch the hdl data load counts from BI publisher? We might load data in multiple iterations and summing up the counts from the import and load data screen might not be a wise decision. Read on to know more details.
Do you know how to fetch the grade ladder step rates for both normal grade ladder and progression grade ladder? Read on to know more details.
Do you know how to find the lookup type for an attribute from UI? Is there any cheat sheet which can be used as ready reference to find out the lookup type easily? Read on to know more details.
Do you know Oracle has provided new Payroll views for PAY_RANGE_ITEMS_F and PAY_VALUE_DEFINITIONS_F from 24A? Why did they introduced these new views? What would happen to reports/value sets if these are not modified? Read on to know more details.
Do you know how to use SQL Developer like tool for Oracle Cloud? Have you used any alternatives earlier? Do you know that we have a free alternative that we can run ad hoc queries? Read on to know more details.
Do you know how to fetch the payroll balance initialization and balance adjustment information for balances of an employee? This will be helpful in reconciling the data loaded and also in reporting balances. Read on to know more details.
Do you know how to handle the run results query when employees have multiple assignments to avoid duplicating of amounts? Read on to know more details.
Do you know how to extract the payslip information from the Document of Records tables? Read on to know more details.
Do you know to customize the check printing template in Payroll? How to add a custom pay check template to extract? Read on to know more details.
Do you know how to fetch the country specific lookup values? What's the significance of TAG field on the lookup table? Read on to know more details.