GPGB_RTI_ADJ_NI

(SQL Table)
Index Back

RTI NI Adjustment Record

Record to hold NI adjustments in Amended Return

  • Parent record: GPGB_RTI_ADJ
  • # 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 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    4 GPGB_TAX_BGN_YR Number(4,0) SMALLINT NOT NULL Tax Year Begins In This Calendar Year
    5 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
    6 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    7 GPGB_NI_CATEGORY Character(2) VARCHAR2(2) NOT NULL NI Category Code
    8 GPGB_NIABLE_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL Niable YTD used for RTI
    9 GPGB_AT_LEL_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - GPGB_AT_LEL_EYU

    Default Value: 0

    10 GPGB_LEL_TO_PT_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - LEL-to-PT-EYU
    11 GPGB_PT_TO_UAP_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - PT-to-UAP-EYU
    12 GPGB_UAP_TO_UEL_EY Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - UAP-to-UEL-EYU
    13 GPGB_PT_TO_UEL_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions -PT-to-UEL-EYU
    14 GPGB_ER_NI_CNT_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - Total of Employer NI Contributions - EYU
    15 GPGB_EE_NI_CNT_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - Employees Contributions on all earnings - EYU
    16 GPGB_NIC_REFUND Character(1) VARCHAR2(1) NOT NULL RTI Adjustment Submissions - NIC Refund
    N=No
    Y=Yes