-
-
-
BIP – Query to DELETE Salary data using HDL
There may be a requirement to delete salary data while doing HDL iterations for the first time. You can use below query for the same purpose
-
HDL – Query to DELETE Assigned Payroll data from Fusion
In case, you need to delete assigned payroll data for masking purpose in lower environment or for some other reason like correction etc, use below query to pull the data in HDL format: Sample HDL File:
-
BIP – Query to extract Rating Model Levels in HDL Format
This is second post in a series to extract Rating Model data from Fusion environment in HDL format. The first post has a query to extract only the rating model data and second post describes the BIP query to extract rating model levels data. Query to extract Rating Model data: Query to extract Rating Model…
-
BIP – Query to extract Rating Model data in HDL Format
You can use below query to extract Rating Model data from fusion environment for updates. Save the data as RatingModel.dat before uploading to Fusion. You can make use of this query to extract data for reference or use it as a method to extract data from one instance and upload it to a different instance….
-
-
HDL – Sample HDL to Update User Table value
SQL Query to extract data for a particular value of a user table: Sample HDL:
-
BIP – HDL to update Grade Rate values
SQL to extract data in HDL Format: Sample HDL:
-
-
-
BIP – Extract Absence Entry data in HDL Format
The below query extracts the minimum required attributes for absence entry update. In the current example, the absence status is updated to Withdrawn. You can make the changes as per your need: Sample HDL File:
-
BIP – Query to extract child positions for a logged in person’s position
Fusion HCM provides you the capability of using Position Trees as well as Position Hierarchies. In case you need to extract child position details based on position id of logged in person, you can make use of below query:
-
BIP – Extract Length of service
Use the below query to extract the length of service of a worker. In case of rehires this becomes little tricky. Below query makes use of earliest hire date for length of service calculation. If Seniority dates are implemented, then you can avoid using below query:
-
BIP – Query to extract department Tree
Use the following query to extract department tree and its child departments. Please pass correct department name before executing:
-
-
-
BIP – Query to extract count of persons without Primary email address
Below is the query to find active employees without primary email address:
-
-