×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ALA dilemna...

ALA dilemna...

ALA dilemna...

(OP)
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

 

RE: ALA dilemna...

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close