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

pay_element_entries attached to assignments that are not active

Received Response
11
Views
2
Comments

Summary:

Pay_element_entries attched to assignments that are not active

Content (required):

trying to understand why the pay_element_entries are attached to assignments that are not active but employee is paid correctly

this employee has multiple assignments in the system (2 of them active). When I run the sql below against the data, the assignment number associated with the current element entries is pointing to an inactive assignment_number

sample:

expecting code below to show the highlighted assignment numbers. instead it is showing E107115-3 which is an inactive assignment. have traced the issue to the pay_element_entries.element_entry_id join to pay_entry_usages table, etc.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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