EFFDTDefault Value: %date
C=CSRS (SF2806/SF2807)
F=FERS (SF3100/SF3103)
N=Not Applicable
GVT_IRR_RET_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , C.GVT_IRR_RET_FORM FROM PS_GVT_JOB A , PS_RTRMNT_PLAN_TBL C WHERE (A.GVT_STATUS_TYPE = 'COM' OR A.GVT_STATUS_TYPE = 'COR') AND C.PLAN_TYPE='70' AND C.BENEFIT_PLAN=A.GVT_RETIRE_PLAN AND C.EFFDT=( SELECT MAX(C1.EFFDT) FROM PS_RTRMNT_PLAN_TBL C1 WHERE C1.BENEFIT_PLAN = A.GVT_RETIRE_PLAN AND C1.PLAN_TYPE = '70' AND C1.EFFDT <= A.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
Default Value: %date |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | 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 |