EMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDRSLT_SEG_NUMSEG_END_DTGPIT_INQ_WA_VW(SQL View) |
Index Back |
|---|---|
Retrieve Correct SegmentUsed to Retrieve Correct Segment from the Payroll Results. |
| 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 ,A.SEG_END_DT ,A.SEG_BGN_DT ,%subrec(GPIT_INQTAX_SBR,A) ,GPIT_INQ_IVS_INC ,GPIT_INQ_OTH_INC ,GPIT_INQ_IVS_AGG ,%subrec(GPIT_INQFPC_SBR,A) ,%subrec(GPIT_INQTFR_SBR,A) FROM PS_GPIT_INQUIRY_WA A , PS_GP_PYE_SEG_STAT B 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 A.EMPLID = B1.EMPLID AND A.CAL_RUN_ID = B1.CAL_RUN_ID AND A.EMPL_RCD = B1.EMPL_RCD AND A.GP_PAYGROUP = B1.GP_PAYGROUP AND A.CAL_ID = B1.CAL_ID AND A.ORIG_CAL_RUN_ID = B1.ORIG_CAL_RUN_ID AND A.RSLT_SEG_NUM = B1.RSLT_SEG_NUM AND B1.RSLT_REV_NUM = 1) |
| # | 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 | SEG_BGN_DT | Date(10) | DATE | Payee Process Segment's Begin Date |
| 10 | GPIT_INQ_TAX_DETR | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Expence Reduction |
| 11 | GPIT_INQ_GG_DETR | Number(3,0) | SMALLINT NOT NULL | Dependant Work Days |
| 12 | GPIT_INQ_SPO_DETR | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Spouse detraction |
| 13 | GPIT_INQ_FAM_DETR | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Dependant detractions |
| 14 | GPIT_INQ_ONE_DETR | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Detractable oneri |
| 15 | GPIT_INQ_DETR_ONE | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Oneri detractions |
| 16 | GPIT_INQ_TOT_DETR | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Total applied detractions |
| 17 | GPIT_INQ_IRP_INC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Irpef income |
| 18 | GPIT_INQ_IRP_GROSS | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Gross 1001 tax |
| 19 | GPIT_INQ_IRP_NET | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net 1001 tax |
| 20 | GPIT_INQ_SEP_TAX | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Separate tax income |
| 21 | GPIT_INQ_IRP_SEP | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Gross 1002 tax |
| 22 | GPIT_INQ_DETR_TSEP | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Detraction 1002 |
| 23 | GPIT_INQ_NET_TSEP | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net 1002 tax |
| 24 | GPIT_INQ_INC_Y_1 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Income Y-1 |
| 25 | GPIT_INQ_INC_Y_2 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Income Y-2 |
| 26 | GPIT_INQ_CITY_AC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | City Tax Current Year |
| 27 | GPIT_INQ_CITY_AP | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | City Tax Y-1 Theoretical |
| 28 | GPIT_INQ_CITY_P | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | City Tax Y-1 Paid |
| 29 | GPIT_INQ_CNTY_AC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | County tax current year |
| 30 | GPIT_INQ_CNTY_AP | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | County tax Y-1 Theoretical |
| 31 | GPIT_INQ_CNTY_P | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | County tax Y-1 (paid) |
| 32 | GPIT_INQ_IVS_INC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | IVS income |
| 33 | GPIT_INQ_OTH_INC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Other contributions income |
| 34 | GPIT_INQ_IVS_AGG | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Add. IVS contribution |
| 35 | GPIT_INQ_FPC_ER_Y | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Employer ctr YTD |
| 36 | GPIT_INQ_FPC_EE_Y | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Employee ctr YTD |
| 37 | GPIT_INQ_FPC_EE_E | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Employee ctr employment |
| 38 | GPIT_INQ_FPC_TFR_Y | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | TFR ctr YTD |
| 39 | GPIT_INQ_FPC_TFR_E | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | TFR ctr employment |
| 40 | GPIT_INQ_FPC_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Assessed YTD amt. |
| 41 | GPIT_INQ_FPC_ER_E | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Employer ctr employment |
| 42 | GPIT_INQ_TFR_3112 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Fund 31/12 Y-1 |
| 43 | GPIT_INQ_TFR_REV | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Reevaluation 31/12 Y-1 |
| 44 | GPIT_INQ_TFR_INC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | TFR useful income curr year |
| 45 | GPIT_INQ_TFR_FPC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | TFR to pension fund |
| 46 | GPIT_INQ_TFR_CTR | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Ctr 0.5% current year |
| 47 | GPIT_INQ_TFR_ANT_Y | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Anticipations YTD |
| 48 | GPIT_INQ_TFR_AN_Y1 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Anticipations on Y-1 |
| 49 | GPIT_INQ_TFR_AN_AC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Anticipations on curr year |
| 50 | GPIT_INQ_TFR_AN_RV | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Reevaluation on anticipations |
| 51 | GPIT_INQ_TFR_RIVAN | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Reevaluation on anticipations |
| 52 | GPIT_INQ_TFR_ANTRV | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Anticipation granted as reev. |
| 53 | GPIT_INQ_TFR_RIVAL | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Accrued reevaluation |
| 54 | GPIT_INQ_TFR_TXRIV | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Tax on reevalution YTD |
| 55 | GPIT_INQ_TFR_FUND | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | TFR Fund |
| 56 | GPIT_INQ_TFR_MM_RR | Number(3,0) | SMALLINT NOT NULL | Months useful ref. Income |
| 57 | GPIT_INQ_TFR_PAID | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | TFR paid employment |
| 58 | GPIT_INQ_TFR_FPC_E | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | TFR pension fund empl |
| 59 | GPIT_INQ_TFR_RATE | Number(5,2) | DECIMAL(4,2) NOT NULL | TFR Tax rate |
| 60 | GPIT_INQ_TFR_ACC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Balance TFR accrued |
| 61 | GPIT_INQ_TFR_FPCAC | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Balance TFR pension fund |
| 62 | GPIT_INQ_TFR_MMRRA | Number(3,0) | SMALLINT NOT NULL | Balance months ref. Income |
| 63 | GPIT_INQ_TFR_MMDTR | Number(3,0) | SMALLINT NOT NULL | Months for detractions |
| 64 | GPIT_INQ_TFR_MDTR1 | Number(3,0) | SMALLINT NOT NULL | Months for detr. Temp employee |
| 65 | GPIT_INQ_TFR_DTR | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Detractions employment |
| 66 | GPIT_INQ_TFR_DTRY | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Detractions YTD |
| 67 | GPIT_INQ_TFR_DTR00 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Deductions 31/12/2000 |
| 68 | GPIT_INQ_TFR_ACC00 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | TFR accrued 31/12/2000 |
| 69 | GPIT_INQ_TFR_IMP | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Gross income Pre-2000 empl |
| 70 | GPIT_INQ_TFR_IMP_N | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net income pre-2000 empl |
| 71 | GPIT_INQ_TFR_TXP00 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Tax pre 2000 employment |
| 72 | GPIT_INQ_TFR_ILP00 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Gross income Pre-2000 YTD |
| 73 | GPIT_INQ_TFR_INP00 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net income pre-2000 YTD |
| 74 | GPIT_INQ_TFR_TP00Y | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Tax Pre 2000 YTD |
| 75 | GPIT_INQ_TFR_IND00 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net income post-2000 employment |
| 76 | GPIT_INQ_TFR_TXD00 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Tax post 2000 employment |
| 77 | GPIT_INQ_TFR_IMPD0 | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net income post-2000 YTD |
| 78 | GPIT_INQ_TFR_TD00Y | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Tax post 2000 YTD |
| 79 | GPIT_INQ_TFR_INCAI | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Other indemnities income empl. |
| 80 | GPIT_INQ_TFR_TXAI | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Other indemnities tax empl |
| 81 | GPIT_INQ_TFR_INCIY | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Other indemnities inc. YTD |
| 82 | GPIT_INQ_TFR_TAXIY | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Other indemnities tax YTD |
| 83 | GPIT_INQ_TFR_ESIMP | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Incent. esodo inc. empl |
| 84 | GPIT_INQ_TFR_ESTX | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Incent. esodo tax empl |
| 85 | GPIT_INQ_TFR_ESINY | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Incent. esodo income YTD |
| 86 | GPIT_INQ_TFR_ESTXY | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Incent. esodo tax YTD |
| 87 | GPIT_INQ_TFR_PRE | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Notification income YTD |
| 88 | GPIT_INQ_TFR_CTPRE | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Ctr on notification YTD |
| 89 | GPIT_INQ_TFR_RVPAG | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Paid reevaluation year |
| 90 | GPIT_INQ_TFR_RIV_E | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Tax on reevalution employment |