LP Maximum Balances by Employee

Tracy,
I built a report showing accrual transaction by employee. This then lead to a request to add max accural limits. I created a subreport using the sql below. I hope this helps point you in the right direction

SELECT "PGEMPLOYEE"."EMPLOYEE", "TASTRUCTUR"."R_PLAN", "TATABLEX"."R_TABLE", "TATABLEX"."R_FROM", "TATABLEX"."AMT_PCT", "TALIMIT"."LIMIT_RULE", "EMPLOYEE"."ADJ_HIRE_DATE"
FROM ((("LAWSON"."PGEMPLOYEE" "PGEMPLOYEE" INNER JOIN "LAWSON"."TASTRUCTUR" "TASTRUCTUR" ON ("PGEMPLOYEE"."COMPANY"="TASTRUCTUR"."COMPANY") AND ("PGEMPLOYEE"."GROUP_NAME"="TASTRUCTUR"."EMPLOYEE_GROUP")) INNER JOIN "LAWSON"."TALIMIT" "TALIMIT" ON ("PGEMPLOYEE"."COMPANY"="TALIMIT"."COMPANY") AND ("TASTRUCTUR"."LIMIT_RULE"="TALIMIT"."LIMIT_RULE")) INNER JOIN "LAWSON"."TATABLEX" "TATABLEX" ON ("PGEMPLOYEE"."COMPANY"="TATABLEX"."COMPANY") AND ("TALIMIT"."BAL_HRS_TBL"="TATABLEX"."R_TABLE")) INNER JOIN "LAWSON"."EMPLOYEE" "EMPLOYEE" ON ("PGEMPLOYEE"."COMPANY"="EMPLOYEE"."COMPANY") AND ("PGEMPLOYEE"."EMPLOYEE"="EMPLOYEE"."EMPLOYEE")
WHERE "TASTRUCTUR"."R_PLAN"<>'PTOCASHIN' AND "PGEMPLOYEE"."EMPLOYEE"=XXXX
ORDER BY "PGEMPLOYEE"."EMPLOYEE", "TASTRUCTUR"."R_PLAN"

Thanks Mark, I will certainly try this. One question first, are you guys still on TA? It looks at first glance you are still pulling some SQL from those tables and I wanted to make sure before I start converting your file names. We are ISeries so I have to find the equivalent names. Thanks.

We have been on LP for 2 years. Lawson had not updated the table names to start with LP.