Skip to end of banner
Go to start of banner

Changed Travel

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Description

Shows how many changes were made in the Employee Portal to the Travel docs within today based on the Changes to Competence Documents from APP .

Keywords

documents, scans

Category

Personnel Portal Views

Description

The tile how many changes were made in the Employee Portal to the Travel docs within today. The view is based on the crew list Changes to Travel Documents from APP and works only if you have it in your system.

Tile Preview

Data-source

The data-source should be added under the General Codes before setting up the tile. It defines the selection for the tile.

select 
  count (PIN) 
from VIEWID
 where convert (date, changed) = convert (date, GETDATE())

Note: VIEWID should be substituted with the crew list view ID: e.g PW001SRV53 . The crew list view ID can be checked in the General Codes.

Tile and Frame Setup

The tile should be setup in the following way, with the link to the Changes to Travel Documents from APP crew list view. The rest of the settings are up to your preferences.

The frame should be setup with the link to the proper data-source. The rest of the settings are up to your preferences.

  • No labels