We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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 parameter name to reference Effective Date and Update Date dates in Value Set SQL

Received Response
27
Views
1
Comments
edited Aug 26, 2019 7:30PM in HCM Mobile 1 comment

Summary

Need parameter name to reference Effective Date and Update Date dates in Value Set SQL.

Content

Need parameter name to reference Effective Date and Update Date  dates in Value Set SQL.

One of the Individual Comp Plan Element-> Input Value, ICP Code is associated with a value Set which fetches values based on Assignment->Department as of Effective Start Date of the Individual Comp Element Entry, we need to fetch Assignment Department as of “Effective Date of Change” Please suggest the Parameter name to be used to get the value from “*What is the effective date of change?” from the screenshot below..

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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