Description

The tile shows how many expired documents - Competence, Travel, Medical and Passports - exist in the system as of today based on the Standard Expiry crew list view.

Tile Preview

Data-source

Should be added in Setup > General Codes Table > Start Page > Datasource:

VALID - Expiry date

DOC - document type: Competence, Medical, Travel or Passport.

It is possible to define the number of days after today when the document is considered expired/ should be checked by the tile.

E.g., if starting from the next 2 months, then use VALID< (Getdate()+60), next 3 months - VALID<(Getdate()+90) etc. If it should only consider the documents that have already expired (expiry date=yesterday or before) then use VALID< Getdate().

select 
count (PIN) 
from PW001SRV7
where DOC='Competence' and VALID< (Getdate()+30)

select 
count (PIN) 
from PW001SRV7
where DOC='Medical' and VALID< Getdate()

select 
count (PIN) 
from PW001SRV7
where DOC='Travel' and VALID< (Getdate()+60)

select 
count (PIN) 
from PW001SRV7
where DOC='Passport' and VALID< (Getdate()+90)

Tile Setup

See example of the setup for Expired Competences. Other document types can be set up in a similar way.

Frame Setup

Select the corresponding Datasource code in Text Area > Data Source.

Type the text that should be shown on the tile in Display Text field.