1 Description | 2 Tile Preview | 3 Data-source | 4 Tile Setup | 5 Frame Setup

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.
Keywords	Documents, expiry
Category	Start Page

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)

Tile Setup

See the 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 the Display Text field.

Adonis HR Reports, Views and Similar

Start Page - Expired documents

Description

Tile Preview

Data-source

Tile Setup

Frame Setup

Related content