Page Comparison

SELECT pay.PIN,
       p01.Name,
       persorg.name               AS Organization,
       pay.accountdim2            AS VesOrgID,
       ISNULL(ves.name, 'N/A')    AS 'Vessel Name',
       CASE 
            WHEN pay.ACCOUNTDIM3 IS NULL OR pay.ACCOUNTDIM3 = '' THEN 'N/A'
            ELSE pay.ACCOUNTDIM3
       END 'Department',
       ISNULL(CAT.NAME, 'Other')  AS 'Category',
       CAST(
           REPLACE(
               CASE 
                    WHEN pay.ENTRYFIELD2 = '' THEN '0'
                    ELSE pay.ENTRYFIELD2
               END,
               ',',
               '.'
           ) AS FLOAT
       )                          AS Days,
       CASE 
            WHEN pay.entryfield3 = '' THEN 0
            ELSE ROUND(
                     (
                         dbo.ad_StrToFloat(
                             RIGHT(
                                 pay.entryfield3,
                                 LEN(pay.entryfield3) - PATINDEX('%[0-9]%', pay.entryfield3) + 1
                             )
                         )
                     ),
                     2
                 )
       END                        AS 'Daily Rate',
       pay.periodeused            AS Period,
       CONVERT(VARCHAR, PAY.ENTRYCODE) + ' ' + EC.TEXT AS 'Entry Code',
       CASE 
            WHEN PAY.ENTRYCODE BETWEEN 30 AND 39 THEN pay.CALCULATEDAMOUNT10
            ELSE pay.CALCULATEDAMOUNT1
       END 'Amount',
       pay.payscaletable          AS 'PayScale Table',
       pay.payscalecode           AS 'PayScale Code',
       payscaleinfo.Table_Name 'PayScale Table Name',
       payscaleinfo.Payscale_Name 'PayScale Name',
       pay.rank                   AS RANK,
       pay.currencyforpayment     AS 'Payment Currency ',
       pay.currencyrateforpayment 'Payment Currency Rate',
       p01.client                    numorgid,
       p01.employmentstartdate,
       p01.employmentenddate
FROM   pw001pay pay
       LEFT JOIN pw001p01 p01
            ON  p01.pin = pay.pin
       LEFT JOIN pworg ves
            ON  ves.numorgid = pay.accountdim2
       LEFT JOIN pyety001 ec
            ON  ec.entrycode = pay.entrycode
       LEFT JOIN pworg persorg
            ON  persorg.numorgid = p01.client
       LEFT JOIN PW001C117 CAT
            ON  ec.CATEGORY = CAT.SEQUENCENO
            AND pay.ENTRYCODE = ec.ENTRYCODE
                --left join pw001p03 p03 on p03.SEQUENCENO=pay.ACTIVITYSEQ
                --left join pw001c12 c12 on c12.CODE=p03.CODE
                --LEFT JOIN dbo.PWORG DEP ON DEP.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 4)
                --LEFT JOIN dbo.PWORG POS ON POS.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 5)
                
       LEFT JOIN (
                SELECT C0.REGULATIVECODE  AS 'Table_Code',
                       C0.REGULATIVENAME  AS 'Table_Name',
                       C1.PAYSCALECODE    AS 'Payscale_Code',
                       C1.PAYSCALENAME    AS 'Payscale_Name'
                FROM   PWPSC000 C0
                       LEFT JOIN PWPSC001 C1
                            ON  C1.SEQNO = C0.SEQNO
            ) payscaleinfo
            ON  payscaleinfo.Table_Code = pay.PAYSCALETABLE
            AND payscaleinfo.Payscale_Code = pay.PAYSCALECODE
WHERE  p01.CLIENT NOT IN (10012602)