Need SQL to extract the amount and periodicity of worker element entries — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need SQL to extract the amount and periodicity of worker element entries

edited Jun 21, 2024 9:07AM in Reporting and Analytics for HCM 3 comments

Summary:

Hi Experts,

Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement.

Written this but it's giving me Amount not Periodicty, Really appreciate your help in Advance.

select pivf.*,
(SELECT pivf.RESERVED_INPUT_VALUE
FROM pay_element_entries_f peef
,pay_element_types_f petf
,pay_input_values_f pivf
,pay_element_entry_values_f peevf
,per_all_people_f per1
WHERE peef.element_type_id = petf.element_type_id
AND petf.element_type_id = pivf.element_type_id
AND peef.element_entry_id = peevf.element_entry_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!