|
SELECT A.EMPLID ,A.CAL_RUN_ID ,A.EMPL_RCD ,A.GP_PAYGROUP ,A.CAL_ID ,A.ORIG_CAL_RUN_ID ,A.RSLT_SEG_NUM ,B.SEG_END_DT ,A.SLICE_END_DT ,A.COMPANY ,A.ESTABID ,A.NAME , A.PAY_ENTITY ,%subrec(GPIT_TFR_SBR, TF) ,%subrec(GPIT_INQTFR_SBR,WA) ,%subrec(GPIT_INQFPC_SBR,WA) FROM PS_GPIT_RP_0001 A , PS_GP_PYE_SEG_STAT B , PS_GPIT_INQUIRY_WA WA , PS_GPIT_TFR_WA TF WHERE A.EMPLID = B.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND A.RSLT_SEG_NUM = B.RSLT_SEG_NUM AND B.RSLT_REV_NUM = 1 AND B.RSLT_VER_NUM = ( SELECT MAX(B1.RSLT_VER_NUM) FROM PS_GP_PYE_SEG_STAT B1 WHERE B.EMPLID = B1.EMPLID AND B.CAL_RUN_ID = B1.CAL_RUN_ID AND B.EMPL_RCD = B1.EMPL_RCD AND B.GP_PAYGROUP = B1.GP_PAYGROUP AND B.CAL_ID = B1.CAL_ID AND B.ORIG_CAL_RUN_ID = B1.ORIG_CAL_RUN_ID AND B.RSLT_SEG_NUM = B1.RSLT_SEG_NUM AND B1.RSLT_REV_NUM = 1 ) AND WA.EMPLID = B.EMPLID AND WA.CAL_RUN_ID = B.CAL_RUN_ID AND WA.EMPL_RCD = B.EMPL_RCD AND WA.GP_PAYGROUP = B.GP_PAYGROUP AND WA.CAL_ID = B.CAL_ID AND WA.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND WA.RSLT_SEG_NUM = B.RSLT_SEG_NUM AND WA.SEG_END_DT = A.SLICE_END_DT AND WA.EMPLID = TF.EMPLID AND WA.CAL_RUN_ID = TF.CAL_RUN_ID AND WA.EMPL_RCD = TF.EMPL_RCD AND WA.GP_PAYGROUP = TF.GP_PAYGROUP AND WA.CAL_ID = TF.CAL_ID AND WA.ORIG_CAL_RUN_ID = TF.ORIG_CAL_RUN_ID AND WA.RSLT_SEG_NUM = TF.RSLT_SEG_NUM AND WA.SEG_END_DT = TF.SEG_END_DT
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 4 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 5 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 6 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 7 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 8 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 9 |
SLICE_END_DT |
Date(10) |
DATE |
Element Slice End Date
|
| 10 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 11 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 12 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 13 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 14 |
GPIT_TFR_NETYR |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Net TFR Year
|
| 15 |
GPIT_TFR_PAYTFR |
Number(1,0) |
SMALLINT NOT NULL |
Falg TFR paid in month
|
| 16 |
GPIT_TFR_ANTICIP |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR Anticipation paid in month
|
| 17 |
GPIT_TFR_IRP_M1 |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR Tax post-2000 M-1
|
| 18 |
GPIT_TFR_IRP_MTH |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR Tax post-2000 in month
|
| 19 |
GPIT_TFR_IRP00_M1 |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR Tax pre-2000 M-1
|
| 20 |
GPIT_TFR_RVIRPEFAC |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Tax on Accrual Reevaluation
|
| 21 |
GPIT_TFR_IRP00_MTH |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR Tax pre-2000 in month
|
| 22 |
GPIT_TFR_PAID |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR Paid in Year
|
| 23 |
GPIT_TFR_PAID_M1 |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR Paid to M-1
|
| 24 |
GPIT_TFR_PAID_MTH |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR paid in Month
|
| 25 |
GPIT_TFR_PCTANTPYM |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Pct. of Anticipation Payment
|
| 26 |
GPIT_TFR_RVACCR |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Reevaluation on Accrual
|
| 27 |
GPIT_TFR_RVGROSS |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Gross Reevaluation
|
| 28 |
GPIT_TFR_RVIND |
Signed Number(10,6) |
DECIMAL(8,6) NOT NULL |
Reevaluation Index
|
| 29 |
GPIT_TFR_RVNETYR |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Net Year Reevaluation
|
| 30 |
GPIT_TFR_RVPAID_M1 |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
TFR Reevaluation paid to M1
|
| 31 |
GPIT_TFR_RVPAIDMTH |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
TFR Reevaluation paind in mont
|
| 32 |
GPIT_TFR_RVPOST00 |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Reevaluation post 2000
|
| 33 |
GPIT_TFR_RVYR |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Year Reevaluation
|
| 34 |
GPIT_TFR_TAXREFINC |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
TFR Reference Income for Tax
|
| 35 |
GPIT_TFR_TAXRV |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Taxation on TFR Reevaluation
|
| 36 |
GPIT_TFR_DETR_M1 |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
TFR Tax Detracitons M-1
|
| 37 |
GPIT_TFR_DETR_MTH |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
TFR Tax Detractions in month
|
| 38 |
GPIT_INQ_TFR_3112 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Fund 31/12 Y-1
|
| 39 |
GPIT_INQ_TFR_REV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Reevaluation 31/12 Y-1
|
| 40 |
GPIT_INQ_TFR_INC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR useful income curr year
|
| 41 |
GPIT_INQ_TFR_FPC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR to pension fund
|
| 42 |
GPIT_INQ_TFR_CTR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Ctr 0.5% current year
|
| 43 |
GPIT_INQ_TFR_ANT_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipations YTD
|
| 44 |
GPIT_INQ_TFR_AN_Y1 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipations on Y-1
|
| 45 |
GPIT_INQ_TFR_AN_AC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipations on curr year
|
| 46 |
GPIT_INQ_TFR_AN_RV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Reevaluation on anticipations
|
| 47 |
GPIT_INQ_TFR_RIVAN |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Reevaluation on anticipations
|
| 48 |
GPIT_INQ_TFR_ANTRV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipation granted as reev.
|
| 49 |
GPIT_INQ_TFR_RIVAL |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Accrued reevaluation
|
| 50 |
GPIT_INQ_TFR_TXRIV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax on reevalution YTD
|
| 51 |
GPIT_INQ_TFR_FUND |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR Fund
|
| 52 |
GPIT_INQ_TFR_MM_RR |
Number(3,0) |
SMALLINT NOT NULL |
Months useful ref. Income
|
| 53 |
GPIT_INQ_TFR_PAID |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR paid employment
|
| 54 |
GPIT_INQ_TFR_FPC_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR pension fund empl
|
| 55 |
GPIT_INQ_TFR_RATE |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
TFR Tax rate
|
| 56 |
GPIT_INQ_TFR_ACC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Balance TFR accrued
|
| 57 |
GPIT_INQ_TFR_FPCAC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Balance TFR pension fund
|
| 58 |
GPIT_INQ_TFR_MMRRA |
Number(3,0) |
SMALLINT NOT NULL |
Balance months ref. Income
|
| 59 |
GPIT_INQ_TFR_MMDTR |
Number(3,0) |
SMALLINT NOT NULL |
Months for detractions
|
| 60 |
GPIT_INQ_TFR_MDTR1 |
Number(3,0) |
SMALLINT NOT NULL |
Months for detr. Temp employee
|
| 61 |
GPIT_INQ_TFR_DTR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Detractions employment
|
| 62 |
GPIT_INQ_TFR_DTRY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Detractions YTD
|
| 63 |
GPIT_INQ_TFR_DTR00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Deductions 31/12/2000
|
| 64 |
GPIT_INQ_TFR_ACC00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR accrued 31/12/2000
|
| 65 |
GPIT_INQ_TFR_IMP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Gross income Pre-2000 empl
|
| 66 |
GPIT_INQ_TFR_IMP_N |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income pre-2000 empl
|
| 67 |
GPIT_INQ_TFR_TXP00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax pre 2000 employment
|
| 68 |
GPIT_INQ_TFR_ILP00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Gross income Pre-2000 YTD
|
| 69 |
GPIT_INQ_TFR_INP00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income pre-2000 YTD
|
| 70 |
GPIT_INQ_TFR_TP00Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax Pre 2000 YTD
|
| 71 |
GPIT_INQ_TFR_IND00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income post-2000 employment
|
| 72 |
GPIT_INQ_TFR_TXD00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax post 2000 employment
|
| 73 |
GPIT_INQ_TFR_IMPD0 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income post-2000 YTD
|
| 74 |
GPIT_INQ_TFR_TD00Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax post 2000 YTD
|
| 75 |
GPIT_INQ_TFR_INCAI |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other indemnities income empl.
|
| 76 |
GPIT_INQ_TFR_TXAI |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other indemnities tax empl
|
| 77 |
GPIT_INQ_TFR_INCIY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other indemnities inc. YTD
|
| 78 |
GPIT_INQ_TFR_TAXIY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other indemnities tax YTD
|
| 79 |
GPIT_INQ_TFR_ESIMP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Incent. esodo inc. empl
|
| 80 |
GPIT_INQ_TFR_ESTX |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Incent. esodo tax empl
|
| 81 |
GPIT_INQ_TFR_ESINY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Incent. esodo income YTD
|
| 82 |
GPIT_INQ_TFR_ESTXY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Incent. esodo tax YTD
|
| 83 |
GPIT_INQ_TFR_PRE |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Notification income YTD
|
| 84 |
GPIT_INQ_TFR_CTPRE |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Ctr on notification YTD
|
| 85 |
GPIT_INQ_TFR_RVPAG |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Paid reevaluation year
|
| 86 |
GPIT_INQ_TFR_RIV_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax on reevalution employment
|
| 87 |
GPIT_INQ_FPC_ER_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Employer ctr YTD
|
| 88 |
GPIT_INQ_FPC_EE_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Employee ctr YTD
|
| 89 |
GPIT_INQ_FPC_EE_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Employee ctr employment
|
| 90 |
GPIT_INQ_FPC_TFR_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR ctr YTD
|
| 91 |
GPIT_INQ_FPC_TFR_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR ctr employment
|
| 92 |
GPIT_INQ_FPC_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Assessed YTD amt.
|
| 93 |
GPIT_INQ_FPC_ER_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Employer ctr employment
|