GPNL_NOM_XML(SQL Table) |
Index Back |
---|---|
Nominative declarationWage Declaration: Nominative declaration |
# | 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 |