Changed Travel
- Daria Chebotaieva
- Sigrid Kviteberg
Summary | Shows how many changes were made in the Employee Portal to the Travel docs within today based on the https://adonishr.atlassian.net/wiki/spaces/REP/pages/4509368970 . |
|---|---|
Keywords | documents, scans |
Description
The tile shows 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.
In our example we use:
Tile Color: Salmon
Font Size: 11
Font Name: Arial
Align: MiddleCenter