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

Adonis HR Reports, Views and Similar

Allotments (this month)

Description

View Sample

Main Data Selection

SQL statement

Columns Specification

Start Page

Related content