Load the metadata file for terminate an employee using HDL
Dat File Name: Worker.dat METADATA|WorkRelationship|LegalEmployerName|PersonNumber|ActualTerminationDate|ActionCode|ReasonCode|TerminateWorkRelationshipFlag|PeriodOfServiceId
SQL Query to get the list of terminated employees
select "PER_PERIODS_OF_SERVICE"."LAST_UPDATE_DATE" as "LAST_UPDATE_DATE", "PER_PERIODS_OF_SERVICE"."LAST_UPDATED_BY" as "LAST_UPDATED_BY", "PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER"
SQL Query to get the list of seniority date version
SELECT SeniorityDateSetUp.seniority_date_code, HcmLookup.MEANING,SeniorityDateSetUp.SENIORITY_VERSION FROM fusion.per_seniority_dates_setup SeniorityDateSetUp,
SQL Query to extract those data that have no profile code
Select distinct papf.person_number,profile_code from PER_ALL_PEOPLE_F PAPF, HRT_PROFILES_B HPB where PAPF.PERSON_ID = HPB.PERSON_ID AND Profile_Code is NULL
SQL Query to get only active employees
EXISTS (SELECT 1 FROM PER_ALL_ASSIGNMENTS_M ASG,PER_PERIODS_OF_SERVICE PS WHERE ASG.ASSIGNMENT_TYPE IN('E','C','N','P') AND ASG.EFFECTIVE_LATEST_CHANGE='Y' AND SYSDATE BETWEEN LEAST(SYSDATE,ASG.EFFECTIVE_START_DATE) AND ASG.EFFECTIVE_END_DATE AND
Load metadata file for Department using HDL
METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|SourceSystemOwner|SourceSystemId|ClassificationCode MERGE|Organization|1951/01/01||ABC-AT-SS|ABC_SS_AT|ORG_AT_DPT_001|DEPARTMENT
SQL Query to get the parent departments
SELECT DISTINCT dhou.ATTRIBUTE2 as Project_Code, dhou.ATTRIBUTE3 as Expense_Code, dhou.name AS DEPT_NAME, dhou1.name AS PARENT_DEPARTMENT_NAME
Grade Structure
The Grades are used to record the compensation for employees in the enterprise. You can define one or more grades that are applicable to jobs and positions. A list of valid grades can be used to restrict the grades that can be selected when you set up assignments or employment details for an employee. The recording of the Pay scale, Grade Scale, and Scale Rate would be recorded as Progression Grade Ladder in HCM Fusion.
Added a salary statement with zero increase
We have identified the issue why it's coming, and we have identified that this issue is coming because a salary section was added in the change assignment. For whenever we do the change assignment and if we do not enter any data in the salary section still system identifies that there is a change in salary so it's added a zero increase, that's why we have removed the
An employee is not able to see the existing absence record
We have researched and found that the employee is having 2 sick leaves with the same absence type, one is completed status and another one is In Progress status, so in the case by default system will show you the latest one. That's why we need to select all to see other absence records.
How to configure the Vacation rule for an employee
We have given the steps to configure the vacation rule in BPM worklist with the below steps 1. Login to Fusion Application as administrator. 2. Navigate to Worklist Application (BPM): Application Home -> Bell Icon Notifications-> More details 3. Go to your Username > Preferences > Other Rules
HR is not able to apply a leave for an employee
You need to perform the below steps in order to fix this issue. 1. Withdraw all the future absence records 2. Remove the attached work schedule and assign it again 3. Resubmit all the withdrawal absence 4. Now try to add the Sick absence
The absence duration must be greater than zero (ANC-3405003)
When the user had submitted the absence, he had a work schedule of Time type and now that has changed into Duration (Elapsed) type. The Start/End Time fields of the absence were changed to Start/End Duration. All absences with a date equal or greater than the new work schedule start date need to be re-submitted
Absence is not showing without selecting All
Since we have researched and found that the employee is having 2 sick leaves with the same absence type, one is completed status and another one is In Progress status, so in this case, by default system will show you the latest one. That's why we need to select all to see other absence records.
Employee cannot add the absence in the future date
We have an absence type called Vaccine, and the client wants that this absence-type employee can add the day of vaccination not before that. For that, we have written a fast formula in order to achieve this requirement. DEFAULT FOR IV_START_DATE is '0001/01/01 00:00:00' (Date
Not able to delete the withdrawn absence record
There are some steps that we need to follow. - My Client Groups - Absence - Configure Absence Batch Parameter
How to configure the CEO approval rule for absence
((absencesApprovalsRequest.absenceType == "Holiday") OR (absencesApprovalsRequest.personId != 100000000000000))
Delete absence enrollment overview
From Release 12, you can delete invalid enrollment permanently. Important: Deleting enrollment removes all data including accruals, adjustments, initialized balance, and absence details for the plan enrollment. Evaluate all your options before deleting an enrollment.
Absence Work Schedule
A work schedule determines the time when a worker is available and unavailable for work and includes: · Shift · Patterns · Calendar Event
Client wants that employee cannot add the absence type in the future date, it should be today’s day only. We have written the fast formula.
FORMULA NAME: ABC Formula FORMULA TYPE: Global Absence Entry Validation DESCRIPTION: This formula validates the absence type Name Date First Name Last Name 01/01/1951