GPNL_NOM_XML

(SQL Table)
Index Back

Nominative declaration

Wage Declaration: Nominative declaration

  • Parent record: GPNL_EMPL_XML
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPNL_WD_MSG_ID Character(32) VARCHAR2(32) NOT NULL WALVIS
    2 GPNL_EMPLR_TAX_ID Character(12) VARCHAR2(12) NOT NULL Unique ID for the Employer assigned within the Wage Declaration, composed out of the Employer Tax Number + Suffix (e.g. "L01")
    3 PRD_BGN_DT Date(10) DATE NOT NULL Period Begin Date
    4 PRD_END_DT Date(10) DATE Pay Period End Date
    5 GPNL_WD_EMPL_ID Character(35) VARCHAR2(35) NOT NULL Wage Tax Declaration Employment ID.
    6 SEG_BGN_DT Date(10) DATE NOT NULL Payee Process Segment's Begin Date
    7 SEG_END_DT Date(10) DATE NOT NULL Payee Process Segment's End Date
    8 GPNL_BSREG Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Regular
    9 GPNL_SV_INCOME_1E Signed Number(16,2) DECIMAL(14,2) NOT NULL Income 1e
    10 GPNL_WAO_BS_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (disabillity) Base 1e
    11 GPNL_WAO_BS_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) Base 2e
    12 GPNL_WW_BS_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Base 1e
    13 GPNL_UFO_BS_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL Field used within the XML structure of the Wage Declaration

    Default Value: 0

    14 GPNL_BSNRG Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Non Regular
    15 GPNL_VAC_PAYM_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Wage Tax Declaration: Vacation Payment
    16 GPNL_VAC_PAYM_ENT Signed Number(16,2) DECIMAL(14,2) NOT NULL Wage Tax Decalartion: Vacation Entitlement
    17 GPNL_ADD_PAYM_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL An additional payment for the employee, like a 13th month payment
    18 GPNL_ADD_PAYM_ENT Signed Number(16,2) DECIMAL(14,2) NOT NULL Wag Tax Declaration: Additional Entitlement
    19 GPNL_COLUMN_3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Personal Report Column 3
    20 GPNL_COLUMN_4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Personal Report Column 4
    21 GPNL_OVERTIME_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Wage Tax Declaration.
    22 GPNL_COLUMN_15 Signed Number(20,6) DECIMAL(18,6) NOT NULL Personal Report Column 15
    23 GPNL_WAO_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) Total Contributn 1e
    24 GPNL_WAO_CT_TT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) Total Contributn 2e
    25 GPNL_WW_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Total Contributn 1e
    26 GPNL_WW_CT_TT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Total Contributn 2e
    27 GPNL_ZVW_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WALVIS
    28 GPNL_ZVW_CT_EE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WALVIS
    29 GPNL_UFO_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL UFO Total Contributn 1e
    30 GPNL_CAR_TAX_AMT Number(12,2) DECIMAL(11,2) NOT NULL Taxable amount for the private use of a company car
    31 GPNL_CAR_EE_DED Number(12,2) DECIMAL(11,2) NOT NULL Employee Contribution for private use of company car
    32 GPNL_CHILDCARE_AMT Number(12,2) DECIMAL(11,2) NOT NULL The taxable amount for the employee due to childcare provided by the employer
    33 GPNL_LIFECYCLE_AMT Number(12,2) DECIMAL(11,2) NOT NULL The amount that is saved for an employee under the Life Cycle Arrangement. This can be based on an employee- and an employer contribution
    34 GPNL_COM_ALLOW Signed Number(20,6) DECIMAL(18,6) NOT NULL Commute Allowance
    35 GPNL_TAXLAB_RED Signed Number(20,6) DECIMAL(18,6) NOT NULL Tax Labor Reduction
    36 GPNL_COLUMN_2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Personal Report Column 2
    37 GPNL_PAID_HOURS Number(7,0) INTEGER NOT NULL Paid Hours
    38 GPNL_COLUMN_19 Signed Number(20,6) DECIMAL(18,6) NOT NULL Personal Report Column 19 Life Cycle Tax Reduction "Levensloopverlofkorting"
    39 GPNL_SUPPL_AMT Number(19,6) DECIMAL(18,6) NOT NULL Amount of paid allowance on top of a paid disability allowance.
    40 GPNL_ZVW_CT_EE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WALVIS