Skip to end of banner
Go to start of banner

Net Wages (this month)

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Summary

The view shows all the crew that have Net Wages calculated this month.

Keywords

Payroll, New Wages

Category

Crew List View

Description

The view shows all the crew that have Net Wages calculated this month.

View Sample

Main Data Selection

The crew members with Net Wages calculated this month (PW001PAY).

SQL statement

 Click here to expand...
CREATE VIEW dbo.PW001SRV103 
AS

SELECT PAY.PIN,
       P01.ALTERNATIVEPIN     AS 'ALTERNATIVE PIN',
       P01.NAME               AS 'Full Name',
       P01.FIRSTNAME          AS 'First Name',
       P01.MIDDLENAME         AS 'Middle Name',
       P01.LASTNAME           AS 'Last Name',
       PAY.ENTRYFIELD1        AS 'Net Amount',
       P0Y.PAYROLLPERIODLOCK  AS 'Payroll Period Lock',
       pay.PAID                   AS 'Paid Status',
       PAY.[TEXT]             AS Comments,
       P01.EmploymentStartDate,
       P01.EmploymentEndDate,
       P01.CLIENT             AS NUMORGID
FROM   PW001PAY PAY
       LEFT JOIN PW001P01 P01
            ON  P01.PIN = PAY.PIN
       LEFT JOIN PW001P0Y p0y
            ON  p0y.PIN = p01.PIN
WHERE  ENTRYCODE = 994

Columns Specification

Column

Description/ Location in APM

PIN

Personal Details > Personal > PIN

Alternative PIN

Personal Details > Personal > Alternative PIN

Full Name

Personal Details > Personal > Full Name

First Name

Personal Details > Personal > First Name

Middle Name

Personal Details > Personal > Middle Name

Last Name

Personal Details > Personal > Last Name

Net Amount

L61 value on EC 994 in PW001PAY

Payroll Period Lock

Checks if the Period Lock on selected person is set or not.

Paid Status

Check if the EC 994 in PW001PAY was paid or not.

Comments

Comment on EC 994 in PW001PAY. Set if it is paid.

EmploymentStartDate

Personal Details > Employment > Employment Start Date

EmploymentEndDate

Personal Details > Employment > Employment End Date

Start Page

N/A

  • No labels