Get Started with Redwood for Oracle Cloud HCM Begin Now
Filter extract to Primary Address = Y
Summary:
I apologize for using unclear/incorrect terminology, I am quite new to Oracle. Please ask additional questions if needed.
We have an extract definition based on the Data Group "Person Address Details" and we would like to filter the extract to only show Primary Addresses.
The current filter looks as follow:
((pauf.address_type='HOME')
AND (pauf.effective_end_date>=pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE')))
but we aren't able to find what element/field corresponds to the Primary Address Flag.
Now I expect this to be standardized across Oracle, so maybe someone can help out?
Tagged:
0