GPGB_PYENT_RTI

(SQL Table)
Index Back

GP UK Pay Entity Details

RTI Specific RTI Pay entity page.

  • Parent record: GP_PYENT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    2 GPGB_TAX_BGN_YR Number(4,0) SMALLINT NOT NULL Tax Year Begins In This Calendar Year
    3 GPGB_NIC_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL NIC Percentage
    4 GPGB_SSPREC Signed Number(7,2) DECIMAL(5,2) NOT NULL Total SSP Recovered under PTS
    5 GPGB_RTI_SRVC Character(1) VARCHAR2(1) NOT NULL Service Company Indicator used in RTI

    Y/N Table Edit

    Default Value: N

    6 GPGB_ASPP_REC Signed Number(7,2) DECIMAL(5,2) NOT NULL Total SSP Recovered under PTS
    7 GPGB_OSPP_REC Signed Number(7,2) DECIMAL(5,2) NOT NULL Total SSP Recovered under PTS
    8 GPGB_SMP_REC Signed Number(7,2) DECIMAL(5,2) NOT NULL Total SSP Recovered under PTS
    9 GPGB_SAP_REC Signed Number(7,2) DECIMAL(5,2) NOT NULL Total SSP Recovered under PTS
    10 GPGB_TOT_NIC_HOLS Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Total NIC Holiday claimed in this permit number.
    11 GPGB_ADV_RCD_IR Signed Number(20,6) DECIMAL(18,6) NOT NULL P35 EDI - Advance received from IR to Refund Tax.
    12 GPGB_NICTAX_PAID Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI - NIC/TAX paid already.
    13 GPGB_INC_PAYMENT Signed Number(6,0) DECIMAL(5) NOT NULL EDI - Incentive Pay
    14 GPGB_DD_SB_CONTS Signed Number(20,6) DECIMAL(18,6) NOT NULL P35 EDI - Deductions made from subcontractors.
    15 GPGB_EDI_P35CL2 Character(1) VARCHAR2(1) NOT NULL P35 EDI - Checklist 2.

    Y/N Table Edit

    Default Value: N

    16 GPGB_EDI_P35CL3 Character(1) VARCHAR2(1) NOT NULL P35 EDI - Checklist 3.

    Y/N Table Edit

    Default Value: N

    17 GPGB_EDI_P35CL41 Character(1) VARCHAR2(1) NOT NULL P35 EDI - Checklist 4.1.

    Y/N Table Edit

    Default Value: N

    18 GPGB_EDI_P35CL51 Character(1) VARCHAR2(1) NOT NULL P35 EDI - Checklist 5.1.

    Y/N Table Edit

    Default Value: N

    19 GPGB_EDI_P35CL61 Character(1) VARCHAR2(1) NOT NULL P35 EDI - Checklist 6.1.

    Y/N Table Edit

    Default Value: N

    20 GPGB_RTI_P11D Character(1) VARCHAR2(1) NOT NULL RTI P11D Indicator

    Y/N Table Edit

    Default Value: N

    21 GPGB_ECON Character(9) VARCHAR2(9) NOT NULL Employers Contracted Out Number
    22 GPGB_EDI_CIS_IND Character(1) VARCHAR2(1) NOT NULL EDI P35 - CIS Limited Company Indicator.

    Y/N Table Edit

    Default Value: N

    23 GPGB_CESSATION_IND Character(1) VARCHAR2(1) NOT NULL EDI - Cessation Indicator

    Y/N Table Edit

    Default Value: N

    24 GPGB_RTI_LATE_PRC Character(1) VARCHAR2(1) NOT NULL Include Late Terminations

    Default Value: N