GVT_IRR_PRT_VW(SQL View) |
Index Back |
|---|---|
IRR Print Runcntl - child rcdSelect all Pending IRRs to be printed |
| SELECT A.EMPLID , A.EMPL_RCD , A.GVT_IRR_TYPE , A.EFFDT , A.EFFSEQ , A.GVT_IRR_RET_FORM , A.GVT_IRR_STATUS , B.NAME , C.NATIONAL_ID FROM PS_GVT_IRR_CONTROL A , PS_GVT_NM_DT_VW B , PS_GVT_PERS_NID C WHERE A.EMPLID=B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD AND B.EFFDT=( SELECT MAX(B1.EFFDT) FROM PS_GVT_NM_DT_VW B1 WHERE B1.EMPLID=A.EMPLID AND B1.EMPL_RCD=A.EMPL_RCD AND B1.EFFDT <= A.EFFDT) AND B.EFFSEQ=( SELECT MAX(B2.EFFSEQ) FROM PS_GVT_NM_DT_VW B2 WHERE B2.EMPLID=A.EMPLID AND B2.EMPL_RCD=A.EMPL_RCD AND B2.EFFDT = B.EFFDT) AND B.EMPLID=C.EMPLID AND B.EMPL_RCD=C.EMPL_RCD AND B.EFFDT=C.EFFDT AND B.EFFSEQ=C.EFFSEQ |
| # | 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_IRR_RET_FORM | Character(1) | VARCHAR2(1) NOT NULL |
IRR Retirement Form Number
C=CSRS (SF2806/SF2807) F=FERS (SF3100/SF3103) N=Not Applicable |
| 7 | GVT_IRR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
IRR Status
F=Final P=Pending |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 9 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |