HDL – Sample file to update user name to email address
Sample File:
-
-
HDL – Query to generate worker email in HDL format
Sample HDL File:
-
HDL – Sample file to cancel Pending Worker Work Relationship
In case, you want to cancel work relationship of a Pending worker, below HDL can be used. Make sure to pass CancelWorkRelationshipFlag as Y. Sample HDL: You can extract the relevant Ids using below SQL:
-
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:
-
HDL – Sample HDL to load rehire Workers
Below is the sample file (tested on an older version) to load rehire worker records but the structure should remain same. Few attributes may be deprecated now, so you may get an error. Please remove those and it should work fine.
-
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 HDL file to update Organization DFF
Use any of the below formats of Organization HDL to update descriptive flexfield attribute: Using Surrogate IDs: Using User Keys: Version Validated :- 21D
-
-
-
-
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:
-
-
-
-
-