BIP – Query to check if employee bank account is active or not
select ext_bank_account_id
,case when nvl(end_date,trunc(sysdate)) >= trunc(sysdate)
then 'Active'
else 'Inactive'
end active_inactive
from IBY_EXT_BANK_ACCOUNTSSimilar Posts
BIP Reports – Query to get Position Profile Attachment details
While creating a position profile, there is an option to add the attachments. In order to get the various details of the attachment like name, UCM content ID etc, please use the below query: In order to download the attchments from UCM, the user should have AttachmentsRead role attached. Please check the below post on…
HDL – Talent Profile HDL related useful queries
Loading the profile data against a worker/job/position is little tricky one. One has to understand the templates thoroughly before uploading any data. Below are some of the most commonly used queries to extract some of the required information for loading Talent profiles data. Extract Person Profile Code: Extract Profile Type Id:
BIP – Extract Grade Ladder, Grade and Step details
Below query can be used to extract grade ladder, grades in ladder and step details of a grade.
BIP – Query to extract business unit attached to a Job
In multi country HCM Implementations, work structures data can be stored in a COMMON set or a country specific set. In such cases, it becomes important to show the correct business unit name against the jobs in reports. Use the below report to extract the Job and the business unit: To get more details on…