Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ALA dilemna...

Status
Not open for further replies.

CGServices

Technical User
Aug 18, 2005
6
US
Hello all -

Have a program that is calculating the proper earnings for each department that an EE has as either a home dept or ALA dept through the use of derived fields.

Currently, the PS_AL_ALA_DATA table is populate in two scenarios when it comes to the percentages to be applied to the earnings - in about half the cases, the EE has a total of 100% and in the other half the home dept has been left out but the other dept(s) are present but not totalling 100%.

This is presenting a challenge in the programming as it now has to recognize the two scenarios - it has to see if the home dept is not present in the ALA Dept for that EE -- AS WELL AS caclulate how much the percentage should be for the home dept.

My economic solution to populate the PS_AL_ALA_DATA table through the Earnings Distribution panel is not being widely accepted so they are pushing for the programming.

Anyone have any suggestions as well as has anyone done this before???...

Example
Pay Code --- Home Dept --- ALA Dept
REG 108001 107003
OT 108001 107003
HOL 108001 109000
PTO 108001 109001

 
As an addendum to my original thread, the example given should end up looking like...

Example:
Pay Code --- Dept
REG 108001
REG 107003
OT 108001
OT 107003
HOL 108001
HOL 109000
PTO 108001
PTO 109001



-- Garrett O'Brien
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top