-
-
-
HDL – Query to generate worker email in HDL format
Sample HDL File:
-
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:
-
-
-
HDL – Sample file to delete element eligibility
HDL supports deletion of element eligibilities. You can make use of PayrollElementDefinition business object. Child object ElementEligibility supports create, update and delete operations. You can create a simple BIP query to extract the requisite data and create an HDL file out of it: Sample HDL file: Sometime you may get an error that You can’t delete…
-
BIP – Query to extract count of persons without Primary email address
Below is the query to find active employees without primary email address:
-
-
-
-
-
-
-
BIP – Query to Extract Learner Completion Details
Use below query to extract the learner completion details. The same query can be used to generate the Learning Record HDL format with small changes.
-
BIP – Query to extract GL Cost Details from Department
GL Cost center Information can be maintained at Department Level. This information can be extracted using below SQL: To bulk upload GL Cost Centers Organization.dat HDL can be used. Please check the below link for more details: https://fusionhcmconsulting.com/2021/01/hdl-sample-hdl-to-load-gl-information-at-department-level/
-
BIP – Extract UDT data
Use below query to extract data related to User Defined Tables in Oracle HCM