| Table of Contents |
|---|
| minLevel | 1 |
|---|
| maxLevel | 1 |
|---|
| type | flat |
|---|
| separator | pipe |
|---|
|
| Page Properties |
|---|
Description Summary | Shows changes made in Employee Portal to Travel docs. | Keywords | Travel document changes, APP changes |
|---|
Category | Personnel Portal |
|---|
|
Description
“Changes to Travel Documents from APP” view is used to track all the changes applied to the Travel Documents from APP by the employees.
This view is essential for the admins to make sure that the uploaded data is accurate.
Selection
VIEWID should be substituted with the id of the crew list view that you are creating in your system e.g. PW001SRV20 etc.
| Code Block |
|---|
|
CREATE VIEW dbo.PW001SRV210VIEWID AS
select
p01.PIN,
p01.NAME as Name,
c23.VISATYPE as Document,
p08.code as DocumentCode,
p08.createtime as Created,
case when p08.createdby = 'app' then p01.name end as CreatedBy,
p08.changetime as Changed,
case when p08.changedby = 'APP' then p01.name end as ChangesMadeBy,
case when scanneddocno is NULL then 'Scan is missing' when p08.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 pw001p08 p08
join pw001c23 c23 on c23.code = p08.code
join pw001p01 p01 on p01.PIN = p08.PIN
where
((p08.CREATEDBY = 'APP' and p08.changedby IS NULL) or p08.CHANGEDBY = 'APP' or (p08.CREATEDBY = 'APP' and p08.CHANGEDBY IS NULL))
--and
--p08.SCANVALIDITY = 0 |
Field Specification
...
View Sample
...
Start Page Setup
Changed Travel