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.
Requirement: Require internal sql function or alternative that determines duration of absence for tw
Summary
This requirement is specifially for interfacing absence transactions to a third-party payroll system. However, third-party payroll is not date effectiveContent
Requirement
We designed a HCM extract, to extract absence transaction data that adheres below mentioned criteria.
Parameters are as follows
Effective date – Date in a month for extracting all absence transactions (Example: 01-Mar-2018 is interpreted as all absence transactions for month of Mar-2018 should be extracted.)
- All absence transactions should be part of output for a month selected
- All absence transactions, that are past-dated with reference to Effective date provided
- There should be no future-dated absence transactions extracted
Tagged:
1