GPNL_NOM_XML(SQL Table) |
Index Back |
|---|---|
Nominative declarationWage Declaration: Nominative declaration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(32) | VARCHAR2(32) NOT NULL | WALVIS | |
| 2 | 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 | Date(10) | DATE NOT NULL | Period Begin Date | |
| 4 | Date(10) | DATE | Pay Period End Date | |
| 5 | Character(35) | VARCHAR2(35) NOT NULL | Wage Tax Declaration Employment ID. | |
| 6 | 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 |