BIP – Query to find workers with FTE < 1
Below SQL query can be used to find part-timers in HCM. Any worker where FTE is less than 1 is normally considered as part-timer:
-
-
BIP – Query to find list of same person having same position multiple times
On the responsive Position UI, the position screens shows the Pending Worker and Worker record as an incumbent and the FTE goes in negative. Below SQL can be used to identify such persons:
-
BIP – Query to Extract Position FTE values
When position hierarchy is enabled in Cloud HCM, Manage Positions UI shows some dynamically populated fields along with Parent position. For example: Use the below query to extract above details: