...

This view shows the crew that have unpaid Office Check payment entry codes in the current Payroll period: .

Selection

The view shows the crew that have EC 502 Garnishment, EC 504 Allotment Office Check, EC 793 Advance Office check, EC 798 Sign Off Office check

...

in the current Payroll period and that have not been processed and locked.

Field Specification

CREATE VIEW
dbo.PW001SRV411 as
SELECT
P.PIN,
P.NAME,
p03.RANK,
P.CLIENT NUMORGID,
P.EMPLOYMENTSTARTDATE,
P.EMPLOYMENTENDDATE ,
'xxx-xx-' + RIGHT(p0y.SSN, 4) AS SSN,
ves.name [Vessel],
PYH.CALCULATEDAMOUNT1 AS AMOUNT,
case when pyh.entrycode in (502, 499, 504) THEN 'Allotment'
--case when pyh.entrycode in (502, 504) THEN 'Allotment'
when pyh.entrycode in (793) then 'Advance'
when pyh.entrycode in (798) then 'Sign Off'
End
as Type,
PYH.entryfield5 AS 'PAYMENT DATE',
pai.PAYNAME [Recipient Name],
per.periodname as [Voyage]

...