For more information, please refer to this announcement explaining best practices for getting answers to questions.
Expiring and Expired Talent Profile item Alert
Summary:
Hi Folks,
Talent Profile Item Expiry Alert - Issue
Below are listed filters used in the Licence Expiry Alert,
----Days for expiry----
${ExpirationDate}=trunc(sysdate) or ${DaysForCertificationExpiry} = 7 or 0
----List of certification for Alert----
${CertificationName} = 'High Risk Work Licence' OR ${CertificationName} = 'Electrician’s Licence' OR ${CertificationName} = 'Enter and Work in Confined Spaces' OR ${CertificationName} = 'High Voltage Switching Operations'….
--- Renewal required needs to validated for every profile item----
EXISTS (select 'X' from HRT_PROFILE_ITEMS where content_item_id=${ContentItemId} and profile_id=${EmployeeProfileId} AND PROFILE_ITEM_ID=${Id} and ITEM_TEXT30_1='Y' )
--------Below filter condition to avoid the triggers whenever the person is recertified within the due for expiry---