EMPLIDCOMPANYGPNL_YEARCDGPNL_YEERSLT_VW(SQL View) |
Index Back |
|---|---|
GPNL_YEERSLT_VWThis view is related to year-end employee results and is referred for High Wage Levy Tax query (GPNL_HIGH_WAGES_DTL) |
| SELECT A.EMPLID , A.COMPANY , A.GPNL_YEARCD , SUM(A.GPNL_COLUMN_14) - (A.GPNL_AMT_OF_EARNS * A.GPNL_YN) , SUM(A.GPNL_COLUMN_14) - (A.GPNL_AMT_OF_EARNS * A.GPNL_YN) - 150000 , %DecMult((0.16), (SUM(A.GPNL_COLUMN_14) - (A.GPNL_AMT_OF_EARNS * A.GPNL_YN) - 150000)) , A.GPNL_AMT_OF_EARNS * A.GPNL_YN FROM PS_GPNL_YEE_RSLT A WHERE A.GPNL_TAX_TABLE = '1' AND A.JOBINSTANCE = ( SELECT MAX(A1.JOBINSTANCE) FROM PS_GPNL_YEE_RSLT A1 WHERE A1.GPNL_YEARCD = A.GPNL_YEARCD AND A1.COMPANY = A.COMPANY) GROUP BY A.EMPLID, A.COMPANY, A.GPNL_YEARCD, A.GPNL_AMT_OF_EARNS, A.GPNL_YN HAVING SUM(A.GPNL_COLUMN_14) - (A.GPNL_AMT_OF_EARNS * A.GPNL_YN) > 150000 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | GPNL_YEARCD |
Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 4 | GPNL_COLUMN_14 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Personal Report Column 14 |
| 5 | GPNL_SUM_THRESHOLD | Number(24,6) | DECIMAL(23,6) NOT NULL | Holds summation of amount exceeding threshold value. |
| 6 | GPNL_SUM_PERCENT | Number(26,8) | DECIMAL(25,8) NOT NULL | Holds summation of High Wage Percentage |
| 7 | GPNL_AMT_OF_EARNS | Number(10,2) | DECIMAL(9,2) NOT NULL | GPNLD - Life Cycle Savings |