Allotments (this month)

Owned by Daria Chebotaieva
Nov 06, 2023
1 min read
1 Description | 2 View Sample | 3 Main Data Selection | 4 SQL statement | 5 Columns Specification | 6 Start Page

Summary

The view shows all the crew that have Allotment entries calculated this month.

Keywords

Payroll, Allotment

Category

Crew List View

Description

The view shows all the crew that have Allotment entries calculated this month.

View Sample

Main Data Selection

The crew members with Alltoments entries 500, 501, 502, and 503 calculated this month (PW001PAY).

SQL statement

CREATE VIEW dbo.PW001SRV104 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', ec.TEXT 'Entry Code', PAY.CALCULATEDAMOUNT1 as 'Net Amount', P01.EmploymentStartDate, P01.EmploymentEndDate, P01.CLIENT as NUMORGID from PW001PAY PAY LEFT JOIN PW001P01 P01 on P01.PIN=PAY.PIN LEFT JOIN PYETY001 EC on PAY.ENTRYCODE=EC.ENTRYCODE where PAY.ENTRYCODE in (500, 501, 502, 503)

Columns Specification

Column

Description/ Location in APM

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

Entry Code

Entry Code in use selected from 500, 501, 502, 503

Net Amount

L61 value on EC 994 in PW001PAY

EmploymentStartDate

Personal Details > Employment > Employment Start Date

EmploymentEndDate

Personal Details > Employment > Employment End Date

Start Page

N/A