| # |
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 |
Payee Process Segment's End Date
|
| 8 |
GPNL_SECTOR |
Number(3,0) |
SMALLINT NOT NULL |
WALVIS
|
| 9 |
GPNL_RISKGRP |
Number(2,0) |
SMALLINT NOT NULL |
WALVIS
|
| 10 |
GPNL_WW_BS_2E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WW Base 2e
|
| 11 |
GPNL_WW_CT_TT_2E |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WW Total Contributn 2e
|