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:
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:
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.
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:
Use the following query to extract department tree and its child departments. Please pass correct department name before executing:
Use any of the below formats of Organization HDL to update descriptive flexfield attribute: Using Surrogate IDs: Using User Keys: Version Validated :- 21D
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…
Below is the query to find active employees without primary email address:
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.
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/
