Versions Compared

Version Old Version 7 New Version Current
Changes made by

Daria Chebotaieva

Helen Ustych

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In this view, you can check and compare that each individual entry code has the corresponding script number set. The view only shows the entry codes that exist in the current Payroll period.

SQL Statement

Code Block
select
pay.PIN,
p01.NAME,
p01.EMPLOYMENTSTARTDATE,
p01.EMPLOYMENTENDDATE,
p01.CLIENT NUMORGID,
convert(varchar,pay.ENTRYCODE)+' '+ec.Text as 'EC Name',
pay.Entrycode as 'EC Code',
right(ec.script,3) as SCRIPT,
right(ec.script,3)-pay.ENTRYCODE as DIFF
from
pw001pay pay
left join pyety001 ec on ec.entrycode=pay.entrycode
left join pw001p01 p01 on p01.pin=pay.PIN

...