SELECT p.PIN,
       p.CLIENT                      NUMORGID,
       p.EMPLOYMENTSTARTDATE,
       p.EMPLOYMENTENDDATE,
       CASE 
            WHEN p.EMPLOYMENTSTARTDATE IS NOT NULL AND CONVERT(DATE, p.EMPLOYMENTSTARTDATE) <= CONVERT(DATE, GETDATE()) 
                 AND (
                     p.EMPLOYMENTENDDATE IS NULL
                     OR CONVERT(DATE, p.EMPLOYMENTENDDATE) > CONVERT(DATE, GETDATE())
                 ) THEN 'Employed'
            WHEN p.EMPLOYMENTENDDATE IS NOT NULL AND CONVERT(DATE, p.EMPLOYMENTENDDATE) <= CONVERT(DATE, GETDATE()) THEN 
                 'Terminated'
            ELSE ''
       END                           EmploymentState,
       p.FIRSTNAME,
       p.LASTNAME,
       (
           SELECT v.[NAME]
           FROM   PWORG v
           WHERE  v.NUMORGID = dbo.ad_scanorgtree(a.NUMORGID, 3)
       )                             Vessel,
       CONVERT(DATE, a.DATEFROM)     StartDate,
       CONVERT(DATE, ISNULL(a.DATETO, a.TODATEESTIMATED)) EndDate
FROM   PW001P01 p
       JOIN PW001P03 a
            ON  a.CODE IN (SELECT CODE
                           FROM   PW001C12
                           WHERE  OPTIONS LIKE '%S%')
            AND a.PIN = p.PIN
            AND CONVERT(DATE, a.DATEFROM) < CONVERT(DATE, GETDATE())
            AND ISNULL(a.DATETO, GETDATE()) >= GETDATE()
            AND a.PLANNED != 'Y'
            AND CONVERT(DATE, a.DATEFROM) BETWEEN DATEADD(MONTH,-1, CONVERT(DATE, LEFT(CONVERT(VARCHAR, GETDATE(), 112), 6) + '01'))
				AND DATEADD(DAY,-1,CONVERT(DATE, LEFT(CONVERT(VARCHAR, GETDATE(), 112), 6) + '01'))