HR_EEO1_EHRS_VW(SQL View) |
Index Back |
---|---|
Hours ViewHours 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 |