Open Sick Activities

Owned by
Anna Zelenskaya
, created
Last updated: Dec 22, 2023
2 min read
1 Description | 2 View Sample | 3 Main Data Selection | 4 SQL statement | 5 Columns Specification | 6 Start Page

Summary

Overview of planned and current sick type activities for crew

Keywords

Sick Activities

Category

Crew List View

Description

Overview of planned and current sick type activities for crew.

View Sample

image-20231222-130339.png

Main Data Selection

Crew members employed under the current organization and units below.

Select only activities with activity type ‘Sick’ (General Codes > Activity Codes > Options > Activity Type = Sick).

Select all ongoing/active sick activities i.e. where Estimated End Date is greater than today's date . Ordered by latest activity on top.
Scenario: Possibility to view all sick activities registered for any person (any company).

This view is important for Sick Administrator/Nurse to be able to spot all ongoing sick activities.

SQL statement

Please remember to update the View ID in the view from dbo.PW001SRVXX to the correct one.

CREATE VIEW dbo.PW001SRV46 AS Select p01.PIN, p01.NAME, p03.CODE as CODE_TEXT, c12.TEXT, p03.DATEFROM as DATE_FROM, p03.DATETO as DATE_TO, p03.TODATEESTIMATED as ESTIMATED_END_DATE, p03.DAYS as NO_OF_DAYS, p03.VESSELNAME, c02.NAME as RANK, p01.Client AS NUMORGID, p01.EMPLOYMENTSTARTDATE, p01.EMPLOYMENTENDDATE From pw001p01 p01 JOIN pw001p03 p03 on p01.PIN = p03.PIN and p03.CODE LIKE '%SICK%' --and (P03.DATETO IS NOT NULL AND PLANNED <> 'Y') and (P03.DATETO IS NULL OR P03.DATETO >= GETDATE()) and P03.DATEFROM <= GETDATE() and P03.TODATEESTIMATED >= GETDATE() LEFT JOIN pw001c12 c12 on p03.CODE = c12.CODE LEFT JOIN pw001c02 c02 on p01.RANK = c02.CODE

Columns Specification

Column

Description/ Location in APM

Column

Description/ Location in APM

PIN

Select from Personal Details > Personal > Pin

NAME

 

LastName FirstName (no comma, only space)

Select from Personal Details > Personal > Name

CODE TEXT

Select from activity of sick type > Details > Code

TEXT

Select from activity of sick type > Details > Code Text

DATE FROM

Select from activity of sick type > Details > Date From

DATE TO

Select from activity of sick type > Details > Date To

ESTIMATED END DATE

Select from activity of sick type > Details > EED

NO OF DAYS

Number of days from activity in question

VESSEL NAME

Select from activity of sick type > Details > Vessel

name of the vessel activity is linked

RANK

Select from Personal Details > Employment, Rank, Current Rank; name of current rank

EMPLOYMENT START DATE

Select from Personal Details > Employment > Employment State > Start

Format dd/mm/yyyy

EMPLOYMENT END DATE

Select from Personal Details > Employment > Employment State > End

Format dd/mm/yyyy

Start Page

N/A