Do you know how to query the payroll flow tables to get the payslips generated count?
Do you know how to query the payroll flow tables to get the count of employees for whom the payslip has been generated? Read on to know more details.
All posts on Sample SQL Queries
SQL Query to fetch HCM Data Loader Load Summary
Do you know how to fetch the HCM Data Loader status from backend tables? Does it pull both HDL and HSDL data loads? Read on to know more details.
SQL Query to fetch Data Roles and Security Profiles
Do you know how to extract the data roles from a POD? Check which security profiles are mapped to data roles. Read on to know more details.
SQL Query to fetch Pending Job Requisitions
Do you know how to fetch the Job Requisitions which are waiting to be approved? Can we get the info on where exactly the approval is struck? Read on to know more details.
SQL Query to fetch Fast Formulas used in HCM Extract
Do you know if there is a way to get the list of all fast formulas that were used in a HCM Extract? It will be a life saver when there is a need to migrate the HCM Extract to target instances. Read on to know more details
SQL Query to fetch Recruiting Location Hierarchy
Do you know how to fetch the Recruiting Location Hierarchy for ORC? Read on to know more details.
SQL Query to fetch Requisition attachment details
Do you now how to pull the attachment information for Job Requisitions in ORC? Read on to know more details.
SQL Query to get Element Costing Information
Do you know how to fetch the Element Costing information along with Element Eligibility? Read on to know more details.
How to pull the Payroll Elements Listing Report using SQL Query?
Do you know how to pull the Element Configuration from Fusion Application? Want to know whether the element is recurring/Non-Recurring, Classification, Level at which the element can be assigned? Read on to know more details.
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.