EMPLIDEMPL_RCDINSTANCEGPDE_LN_TAX_VW(SQL View) |
Index Back |
|---|---|
GPDE - loans tax viewLoans tax view |
| SELECT A.EMPLID , A.EMPL_RCD , A.INSTANCE , SUM(A.GPDE_LN_DED_AMTINT) FROM PS_GPDE_LN_SCHED A , PS_GPDE_LN_SETUP B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.INSTANCE = B.INSTANCE AND NOT EXISTS ( SELECT 1 FROM PS_GPDE_LN_RSLT SUB WHERE SUB.EMPLID = A.EMPLID AND SUB.EMPL_RCD = A.EMPL_RCD AND SUB.INSTANCE = A.INSTANCE AND SUB.GPDE_LN_YEAR = A.GPDE_LN_YEAR AND SUB.GPDE_LN_MONTH = A.GPDE_LN_MONTH) GROUP BY A.EMPLID, A.EMPL_RCD, A.INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 4 | GPDE_LN_DED_AMTINT | Number(9,2) | DECIMAL(8,2) NOT NULL | Loan interest deduction amount |