Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Calculation Card Details - Table Information

edited Feb 26, 2021 12:03PM in Reporting and Analytics for HCM 2 comments

Summary

Additional Information on Descriptive Flexfields in PAY_DIR_COMP_DETAILS_F

Content

Hello,

I was looking into fetching the Pension Auto Enrollment information from the Calculation Card associated with an employee. I've figured the query et al, but was looking if someone had an idea on what each of the DF columns in the PAY_DIR_COMP_DETAILS_F table stood for?

I understand the PAY_DIR_COMP_DETAILS_F handles the calculation card details across various cards, so I understand we might not have the same data for each card (For ex, for the card Benefits and Pensions, DIR_INFORMATION_CHAR1 might indicate a flag, whereas for Pension Auto-Enrolment it might indicate if the person is eligible for pensions or not). I've checked the table guidelines / docs, but the fields are labelled vaguely and linking with PAY_DIR_COMP_FLEXS_F etc. doesn't return anything usable.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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