HR_EEO1_EHRS_VW

(SQL View)
Index Back

Hours View

Hours View

SELECT A.COMPANY , A.BALANCE_YEAR , A.EMPLID , SUM(A.HRS_YTD) FROM PS_EARNINGS_BAL A WHERE A.BALANCE_ID='CY' AND A.ERNCD IN ( SELECT DISTINCT B.ERNCD FROM PS_HR_EEO1_EXERNCD B WHERE B.CALENDAR_YEAR=A.BALANCE_YEAR ) AND A.BALANCE_PERIOD =( SELECT MAX(B.BALANCE_PERIOD) FROM PS_EARNINGS_BAL B WHERE B.COMPANY=A.COMPANY AND B.BALANCE_YEAR = A.BALANCE_YEAR AND B.ERNCD = A.ERNCD AND B.EMPLID = A.EMPLID AND B.BALANCE_ID='CY' ) GROUP BY A.COMPANY , A.BALANCE_YEAR , A.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 HR_EEO1_HRS_YTD Signed Number(10,2) DECIMAL(8,2) NOT NULL Hours Worked for EEO1 Reporting