PAY_EARNS_WC_VW

(SQL View)
 Index Back

Pay Earnings for WorkCenter

This view shows total hours on the pay earnings for a check. Regular earn hours, regular hours and OT hours will be added together as the total hours.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.ADDL_NBR , B.EMPLID , B.EMPL_RCD , B.NAME , B.DEPTID , B.BUSINESS_UNIT , ( A.REG_EARN_HRS + A.REG_HRS + A.OT_HRS ) AS TOTAL_EARNS_HRS FROM PS_PAY_EARNINGS A ,PS_PAY_CHECK B WHERE A.COMPANY=B.COMPANY AND A.PAYGROUP=B.PAYGROUP AND A.PAY_END_DT=B.PAY_END_DT AND A.OFF_CYCLE=B.OFF_CYCLE AND A.PAGE_NUM=B.PAGE_NUM AND A.LINE_NUM=B.LINE_NUM AND A.SEPCHK=B.SEPCHK AND A.PAY_LINE_STATUS IN ('C','V')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 PAY_END_DT Date(10) DATE Pay Period End Date
4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
8 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
11 NAME Character(50) VARCHAR2(50) NOT NULL Name
12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
14 TOTAL_ERN_HRS Signed Number(12,2) DECIMAL(10,2) NOT NULL Sum of earn hours, reg hours and OT hours on pay earnings.