GVT_IRR_FIN_VW1(SQL View) |
Index Back |
|---|---|
IRR Fiscal-Prev Yr DeductsPrevious year deductions reported for IRR Fiscal Data |
| SELECT Z.EMPLID, Z.EMPL_RCD, Z.GVT_IRR_TYPE, Z.EFFDT, Z.EFFSEQ, A.GVT_YEAR, A.GVT_IRR_RET_FORM, SUM(A.AMOUNT), MAX(A.EMPL_PCT) FROM PS_GVT_IRR_FIN_DTA A, PS_GVT_IRR_CONTROL Z WHERE A.GVT_IRR_FIN_CD_TP='D' AND A.EMPLID=Z.EMPLID AND A.EMPL_RCD=Z.EMPL_RCD GROUP BY Z.EMPLID, Z.EMPL_RCD, Z.GVT_IRR_TYPE, Z.EFFDT, Z.EFFSEQ, A.GVT_YEAR, A.GVT_IRR_RET_FORM |
| # | 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 Rcd Nbr |
| 3 | GVT_IRR_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
IRR Type based on above NOAC
A=Final Disability C=Correction D=Death M=Military Deposit N=Not Applicable P=Preliminary Disability R=Retirement S=Supplemental T=Transfer/Resignation |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | GVT_PAY_YEAR |
Number(4,0) | SMALLINT NOT NULL | Pay Year |
| 7 | GVT_IRR_RET_FORM | Character(1) | VARCHAR2(1) NOT NULL |
IRR Retirement Form Number
C=CSRS (SF2806/SF2807) F=FERS (SF3100/SF3103) N=Not Applicable |
| 8 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 9 | EMPL_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Employee Contribution Percent |