Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Get total amount paid for single element for the selected date range- SQL help
Summary
How to retive sum of total amount paid for the employee for one elementContent
Hello all,
I am new to HCM payroll and have requirement to get total amount paid for each element for the given time period for each employee. I am trying the following SQL and unable to get the results. Please help.
SELECT Distinct PET.ELEMENT_TYPE_ID,PET.base_ELEMENT_NAME, --PIV.NAME,
PEEV.EFFECTIVE_START_DATE ELE_ENTR_EFF_STDT, PEEV.EFFECTIVE_END_DATE
ELE_ENTR_EFF_ENDT,PEEV.SCREEN_ENTRY_VALUE,
PEE.ELEMENT_ENTRY_ID
--,PEL.PAYROLL_ID, Prf.Payroll_name,PEE.ASSIGNMENT_ID
Tagged:
0