...
This article describes how to set up Customized Topics data together with a Crew List View to help users to follow up with persons on Sick Leave.
...
Description
In many countries, the government tasks the Employer to follow-up employees that are on Sick Leave. In this article, we describe how to set up a Data group in Customized Topics, and how to get the information out into a Crew List View.
...
Under the Editor Form Layout we have used the Customize tool to group fields and to give the groups a name
...
Crew List View
A Crew List View with the following fields and information is included. This Crew List View will pick up information for any person where a record of Sick Leave has been added.
...
High-lighting expiry dates
In the Crew List View, it is possible to set up color coding for fields that indicates a deadline. In this sample, the fields "Follow-up Plan", "Dialogue Meeting I", "Dialogue Meeting II NAV" and "Follow-up II" is set to have the cell display color as follows:
The cell will display in yellow when it is 7 days until the date in the field.
The cell will display in red when it is 1 day until the date in the field and until the Grey color field kicks in.
The cell will display in grey when it is 365 days after the date in the field.
These days are customizable and can be set in General Codes | Crew List | Crew List View and by going into the specific Crew List View.
...
SQL Statement
CREATE VIEW dbo.PW001SRV12
as
select p01.Pin,
p01.Name,
u02.UField1 AS "Sick Leave From",
u02.UField2 AS "Sick Leave To",
Case when u02.UField3 is null then Dateadd (Day,3,u02.UField1) else null end AS "First Response",
u02.UField3 AS "First Response Performed",
u02.UField4 AS "Notes from First Response",
Case when u02.UField5 is null then Dateadd (Day,28,u02.UField1) else null end AS "Follow-up Plan",
u02.UField5 AS "Follow-up Plan Created",
u02.UField6 AS "Notes from Follow-up Plan",
u02.UField7 AS "URL to Follow Up Plan",
Dateadd (Day,49,u02.UField1) AS "Dialogue Meeting I NAV",
u02.UField8 AS "Notes from Dialogue Meeting I",
Dateadd (Day,63,u02.UField1) "Info to NAV",
u02.UField9 AS "URL to NAV info",
Dateadd (Day,182,u02.UField1) AS "Dialogue Meeting II NAV",
Dateadd (Day,365,u02.UField1) AS "Follow-up II",
u02.UField10 AS "Additional Notes",
u02.UField11 AS "Other Enclosures I",
u02.UField12 AS "Other Enclosures II",
u02.UField13 AS "Other Enclosures III",
u02.UField14 AS "Fit for Duty From",
P01.CLIENT NUMORGID,
P01.EMPLOYMENTSTARTDATE,
P01.EMPLOYMENTENDDATE
from pw001p01 p01
join pw001u23 u02 on u02.pin = p01.pin