PY_T_EHRS_WC_VW

(SQL View)
 Index Back

Total Earns Hours on paycheck

This view shows the total hours on paycheck for Payroll WorkCenter.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.EMPLID , A.EMPL_RCD , A.NAME , A.DEPTID , A.BUSINESS_UNIT , SUM(A.TOTAL_ERN_HRS) FROM PS_PY_EHRS_WC_VW A GROUP BY A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.EMPLID , A.EMPL_RCD , A.NAME , A.DEPTID , A.BUSINESS_UNIT

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
13 TOTAL_ERN_HRS Signed Number(12,2) DECIMAL(10,2) NOT NULL Sum of earn hours, reg hours and OT hours on pay earnings.