Start Page - Expired documents

Owned by Helen Ustych, created
Last updated: Apr 04, 2024 by Daria Chebotaieva
2 min read
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

image-20240312-120421.png

Data-source

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

image-20240312-120535.png

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.