GVT_IRR_FIN_VW8(SQL View) |
Index Back |
|---|---|
Prior Yr LWOP |
| SELECT Z.EMPLID, Z.EMPL_RCD, Z.GVT_IRR_TYPE, Z.EFFDT, Z.EFFSEQ, A.GVT_YEAR, A.GVT_IRR_RET_FORM, SUM(A.HOURS_PER_YEAR) FROM PS_GVT_IRR_FIN_DTA A, PS_GVT_IRR_CONTROL Z WHERE A.GVT_IRR_FIN_CD_TP='L' 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_YEAR |
Number(4,0) | SMALLINT NOT NULL | 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 | HOURS_PER_YEAR | Number(7,2) | DECIMAL(6,2) NOT NULL | Hours per Year |