EFFDTC=Savings Suspension
C=Contribution Holiday
I=Opting In
N=New Enrollment
O=Opting out
GPNZ_EE_KIW_VW(SQL View) |
Index Back |
|---|---|
KiwiSaver Employee Details VIEThis Record fetches the KiwiSaver details of an Employee along with paygroup |
| SELECT KIW.EMPLID ,KIW.EMPL_RCD ,KIW.EFFDT ,KIW.GPNZ_KIW_OPTN ,JB.GP_PAYGROUP FROM PS_GPNZ_EE_KIW_DTL KIW , PS_JOB JB WHERE KIW.EMPLID = JB.EMPLID AND KIW.EMPL_RCD = JB.EMPL_RCD AND JB.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES WHERE JB.EMPLID = A_ES.EMPLID AND JB.EMPL_RCD = A_ES.EMPL_RCD AND JB.EFFDT = A_ES.EFFDT) AND JB.EFFDT =( SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE JB.EMPLID = A_ED.EMPLID AND JB.EMPL_RCD = A_ED.EMPL_RCD AND A_ED.EFFDT <=KIW.EFFDT) |
| # | 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 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | GPNZ_KIW_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
This Field records the option chosen by the user regarding the Kiwisaver.
C=Savings Suspension C=Contribution Holiday I=Opting In N=New Enrollment O=Opting out |
| 5 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |