EMPLIDEMPL_RCDGVT_YEARGVT_IRR_RET_FORMC=CSRS (SF2806/SF2807)
F=FERS (SF3100/SF3103)
N=Not Applicable
GVT_IRR_FIN_CODED=Deduction
E=Earning
E=Amount
H=Hours
N=None
GVT_PRIO_ADJ_VW(SQL View) |
Index Back |
|---|---|
Federal PRIO ADJ view |
| SELECT X.EMPLID , X.EMPL_RCD , X.GVT_YEAR , X.GVT_IRR_RET_FORM , X.GVT_IRR_FIN_CODE , X.GVT_IRR_FIN_CD_TP , X.AMT_OR_HOURS , X.AMOUNT , X.HOURS_PER_YEAR , X.EMPL_PCT , X.GVT_AMOUNT_CHG , X.GVT_HRS_PER_YR_CHG , X.GVT_EMPL_PCT_CHG , X.REASON FROM PS_GVT_IRR_FIN_DTA X WHERE X.GVT_IRR_FIN_CD_TP IN ('D','L') |
| # | 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_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year |
| 4 | 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 |
| 5 | GVT_IRR_FIN_CODE |
Character(6) | VARCHAR2(6) NOT NULL | IRR Financial Code |
| 6 | GVT_IRR_FIN_CD_TP | Character(1) | VARCHAR2(1) NOT NULL |
IRR Financial Code Type
D=Deduction E=Earning |
| 7 | AMT_OR_HOURS | Character(1) | VARCHAR2(1) NOT NULL |
Based On Amount or Hours
E=Amount H=Hours N=None |
| 8 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 9 | HOURS_PER_YEAR | Number(7,2) | DECIMAL(6,2) NOT NULL | Hours per Year |
| 10 | EMPL_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Employee Contribution Percent |
| 11 | GVT_AMOUNT_CHG | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | for Adjust Fiscal Year |
| 12 | GVT_HRS_PER_YR_CHG | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | for Adjust Fiscal Year |
| 13 | GVT_EMPL_PCT_CHG | Signed Number(8,3) | DECIMAL(6,3) NOT NULL | for Adjust Fiscal Year |
| 14 | REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason |