EMPLIDEMPL_RCDGVT_IRR_TYPEA=Final Disability
C=Correction
D=Death
M=Military Deposit
N=Not Applicable
P=Preliminary Disability
R=Retirement
S=Supplemental
T=Transfer/Resignation
EFFDTEFFSEQGVT_PAY_YEARGVT_IRR_FIN_VW3(SQL View) |
Index Back |
|---|---|
IRR Basic Pay-Prior Yrs |
| SELECT Z.EMPLID, Z.EMPL_RCD, Z.GVT_IRR_TYPE, Z.EFFDT, Z.EFFSEQ, A.GVT_YEAR, SUM(A.AMOUNT) FROM PS_GVT_IRR_FIN_DTA A, PS_GVT_IRR_CONTROL Z WHERE A.GVT_IRR_FIN_CD_TP='B' AND Z.EMPLID=A.EMPLID AND Z.EMPL_RCD=A.EMPL_RCD GROUP BY Z.EMPLID,Z.EMPL_RCD, Z.GVT_IRR_TYPE, Z.EFFDT, Z.EFFSEQ, A.GVT_YEAR |
| # | 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 | GVT_IRR_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
IRR Type based on 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 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |