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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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

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!