Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Need a sample SQL Data model using DFF and EFF Flex Fields — 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 a sample SQL Data model using DFF and EFF Flex Fields

Received Response
54
Views
5
Comments
edited Mar 24, 2021 5:08AM in Reporting and Analytics for HCM 5 comments

Summary

Need a sample SQL Data model using DFF and EFF Flex Fields

Content

We have several EFF and DFF fields were created in Oracle HCM. Can someone share a sample data model sql which refers the usage of EFF and DFF fields

I like to know what tables and fields needs to used to pull DFF and EFF fields.. 

Foe example: Below is the one of DFF fields needs to be pulled

Attribute Name Flexfield Code Sequence Name Table Column Code Value Data Type Display Type Value Set
Assignment PER_ASG_DF 5 US Work Eligibility Flag ****_ATTRIBUTE11 US Work Eligibility Flag
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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