GPIT_RP_0002

(SQL Table)
 Index Back

WA Monthly amount from GP

WA Record. It stores monthly amount calculated during the payroll run.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    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 SLICE_END_DT Date(10) DATE Element Slice End Date
    9 GPIT_BASE_SALARY Number(19,6) DECIMAL(18,6) NOT NULL Base Salary for reports
    10 GPIT_CONTINGENCY Number(19,6) DECIMAL(18,6) NOT NULL Contingency for reports
    11 GPIT_SENIORITY Number(19,6) DECIMAL(18,6) NOT NULL Seniority for reports
    12 GPIT_SUPERMINIMO Number(19,6) DECIMAL(18,6) NOT NULL Superminimo for reports
    13 GPIT_TOT_FIX_ELEM Number(19,6) DECIMAL(18,6) NOT NULL Total of fixed elements for reports
    14 GPIT_DAILY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Daily rate for reports
    15 GPIT_HOURLY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Hourly rate for reports
    16 GPIT_WORKED_DAYS Number(5,2) DECIMAL(4,2) NOT NULL Worked days for reports
    17 GPIT_WORKED_HRS Number(3,0) SMALLINT NOT NULL Worked hours for reports
    18 GPIT_PREV_ROUND Number(19,6) DECIMAL(18,6) NOT NULL Previous rounding for reports
    19 GPIT_CURR_ROUND Number(19,6) DECIMAL(18,6) NOT NULL Current rounding for reports
    20 GPIT_NET_TO_PAY Number(19,6) DECIMAL(18,6) NOT NULL Net to pay for reports
    21 GPIT_INAIL_INCOME Signed Number(20,6) DECIMAL(18,6) NOT NULL INAIL Income for reports
    22 GPIT_CTR_INCOME Number(19,6) DECIMAL(18,6) NOT NULL CTR income for reports
    23 GPIT_IVS Number(19,6) DECIMAL(18,6) NOT NULL Compulsary Pension deduction for reports
    24 GPIT_IVS_AGG Number(19,6) DECIMAL(18,6) NOT NULL Additional IVS for reports
    25 GPIT_CIG Number(19,6) DECIMAL(18,6) NOT NULL CIG deducion for reports
    26 GPIT_FPC_INCOME Number(19,6) DECIMAL(18,6) NOT NULL Facultative Pension deduction for reports
    27 GPIT_FPC_EMPLOYER Number(19,6) DECIMAL(18,6) NOT NULL Facultative Pension employer's deduction for reports
    28 GPIT_FPC_EMPLOYEE Number(16,3) DECIMAL(15,3) NOT NULL Facultative Pension employee's deduction for reports
    29 GPIT_CTR_FPC_TFR Number(19,6) DECIMAL(18,6) NOT NULL Facultative Pension deduction for TFR for reports
    30 GPIT_TOT_CTR Number(19,6) DECIMAL(18,6) NOT NULL Total of contribution for reports
    31 GPIT_TAX_INCOME Number(19,6) DECIMAL(18,6) NOT NULL Tax income for reports
    32 GPIT_GROSS_IRPEF Number(19,6) DECIMAL(18,6) NOT NULL Gross IRPEF for reports
    33 GPIT_NET_IRPEF Number(19,6) DECIMAL(18,6) NOT NULL Net IRPEF for reports
    34 GPIT_INC_FOR_TFR Number(19,6) DECIMAL(18,6) NOT NULL Income for TFR for reports
    35 GPIT_TAX_RED_DAYS Number(19,6) DECIMAL(18,6) NOT NULL Tax reduction days for reports
    36 GPIT_TAX_RED_WORK Number(19,6) DECIMAL(18,6) NOT NULL Dependent work detraction for reports
    37 GPIT_SPOUSE_DETR Number(19,6) DECIMAL(18,6) NOT NULL Spouse detraction for reports
    38 GPIT_DEP_DET Number(19,6) DECIMAL(18,6) NOT NULL Dependent detractions for reports
    39 GPIT_DEDUCT_COST Number(16,3) DECIMAL(15,3) NOT NULL Deductible costs for reports
    40 GPIT_TOT_DETR Number(19,6) DECIMAL(18,6) NOT NULL Total of detractions for reports
    41 GPIT_ALTRCOMP_INC Number(19,6) DECIMAL(18,6) NOT NULL INPS other payments income
    42 GPIT_COMPCORR_INC Number(19,6) DECIMAL(18,6) NOT NULL INPS current payments income
    43 GPIT_EVR_CCPOS Number(19,6) DECIMAL(18,6) NOT NULL INPS EVR current payments +
    44 GPIT_EVR_CCNEG Number(19,6) DECIMAL(18,6) NOT NULL INPS EVR current payment -
    45 GPIT_EVR_ACPOS Number(19,6) DECIMAL(18,6) NOT NULL INPS EVR other payments +
    46 GPIT_EVR_ACNEG Number(19,6) DECIMAL(18,6) NOT NULL INPS EVR other payments -
    47 GPIT_INPS_PTWEEKS Number(5,2) DECIMAL(4,2) NOT NULL INPS part time weeks
    48 GPIT_INPS_CONTRIB Number(19,6) DECIMAL(18,6) NOT NULL Total mandatory contributions
    49 GPIT_INPS_BONUS Number(19,6) DECIMAL(18,6) NOT NULL Late Retirement Total Bonus
    50 GPIT_INCOME_1002 Signed Number(20,6) DECIMAL(18,6) NOT NULL Income 1002
    51 GPIT_IRPEF_1002 Signed Number(20,6) DECIMAL(18,6) NOT NULL IRPEF 1002
    52 GPIT_AMT_NOIVSASS Number(19,6) DECIMAL(18,6) NOT NULL Field for the Previdential CUD Report which contains the amount of IVS not asseassable
    53 GPIT_INPD_CYINCOME Number(19,6) DECIMAL(18,6) NOT NULL Field which contains the INPDAI monthly income for current year
    54 GPIT_INPD_PYINCOME Number(19,6) DECIMAL(18,6) NOT NULL Field which contains the INPDAI monthly income for previous year
    55 GPIT_INPD_MONTDAYS Number(2,0) SMALLINT NOT NULL Field which contains the INPDAI monthly days
    56 GPIT_INPD_EMPLCTR Number(19,6) DECIMAL(18,6) NOT NULL Field which contains the INPDAI employee contributions
    57 GPIT_INPD_CONVINC Number(19,6) DECIMAL(18,6) NOT NULL Field which contains the INPDAI conventionate income
    58 GPIT_PYSL_AMTH3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy charcter
    59 GPIT_PYSL_AMTH4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    60 GPIT_PYSL_AMTH5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    61 GPIT_PYSL_AMTH6 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    62 GPIT_PYSL_AMTH7 Signed Number(20,6) DECIMAL(18,6) NOT NULL dummy number
    63 GPIT_PYSL_AMTH8 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    64 GPIT_PYSL_AMTH9 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    65 GPIT_PYSL_AMTF1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    66 GPIT_PYSL_AMTF2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    67 GPIT_PYSL_AMTF3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    68 GPIT_PYSL_AMTF4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    69 GPIT_PYSL_AMTF5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    70 GPIT_PYSL_AMTF6 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    71 GPIT_PYSL_AMTF7 Signed Number(20,6) DECIMAL(18,6) NOT NULL Workable days (from monday to saturday) in segment. Field of the record GPIT_RP_0002 and used in the Cud Social Security AE.
    72 GPIT_PYSL_AMTF8 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
    73 GPIT_SBONUS_AMT Number(9,0) DECIMAL(9) NOT NULL Amount
    74 GPIT_SBONUS_BGN_DT Date(10) DATE Begin Date.