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

BIP Report - Goals - Employee Sumbission Date and Manager Approval Date

Accepted answer
41
Views
3
Comments
edited Aug 30, 2023 1:56PM in Performance Management 3 comments

Summary:

Customer asks to modify existing BIP GOAL report by adding two more columns with values New Goal Submission date of Employee and Manager approval Date of this goal.

Content (required):

I would like to ask you, if there is existing report or any manual how to map Goals to these two dates information. I tried to use tables HRC_TXN_HEADER TRR, HRC_TXN_DATA, HRC_TXN_HEADER_ARCHIVE, HRC_TXN_DATA_ARCHIVE. I found the dates in HRC_TXN_DATA and HRC_TXN_DATA_ARCHIVE as submission_date and completed_date however I faced here two complications:

  1. I do not know how to uniquely specify record in HRC_TXN_DATA so I used Subject_ID from HRC_TXN_HEADER and Goal_ID as Extractvalue from HRC_TXN_HEADER.XML_DATA_CACHE column. Is this correct approach ? The reason why I done this is that Object_ID and Subject_ID in HRC_TXN_HEADER are both filled by person_id.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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