CREATE VIEW dbo.PW001SRV220
AS 
select
p01.PIN,
p01.NAME as Name,
c24.TEXT as Document,
p07.code as DocumentCode,
p07.createtime as Created,
case when p07.createdby = 'app' then p01.name end as CreatedBy,
p07.changetime as Changed,
case when p07.changedby = 'APP' then p01.name end as ChangesMadeBy,
case when scanneddocno is NULL then 'Scan is missing' when p07.scanvalidity = 0 and scanneddocno is not NULL then 'Scan has not been approved' else 'Scan is valid' End as Status,
p01.EMPLOYMENTENDDATE,
p01.EMPLOYMENTSTARTDATE,
p01.CLIENT NUMORGID
from pw001p07 p07
join pw001c24 c24 on c24.code = p07.code
join pw001p01 p01 on p01.PIN = p07.PIN
where 
((p07.CREATEDBY = 'APP' and p07.changedby IS NULL) or p07.CHANGEDBY = 'APP' or (p07.CREATEDBY = 'APP' and p07.CHANGEDBY IS NULL))
and
p07.SCANVALIDITY = 0