Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Leave Balance Calculation date showing different than UI in BIP report — 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

Leave Balance Calculation date showing different than UI in BIP report

Received Response
11
Views
16
Comments
in Reporting and Analytics for HCM 16 comments

Summary:

Hi Team,


Leave Balance Caluclation date showing diffrent than UI in BIP report

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Select papf.person_number Person_id, 

    ppnf.FULL_NAME,

    papf1.person_number Manager_number,

    ppnf1.FULL_NAME Manager_Name,

    to_char(ppos.ORIGINAL_DATE_OF_HIRE,'MM-DD-YYYY') Enterprise_Hire_Date,

    aapft.NAME Plan_Name, 

    to_char(apae.ACCRUAL_PERIOD,'MM-DD-YYYY') Balance_End_Date,

  apae.END_BAL current_balance,

  haou.name Legal_Employer               

from PER_PERSON_SECURED_LIST_V papf,

   PER_PERSON_NAMES_F ppnf,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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