GPNL_WD_MSG_IDGPNL_EMPLR_TAX_IDPRD_BGN_DTPRD_END_DTSEQ_NODefault Value: 0
GPNL_SECTORGPNL_RISKGRPGPNL_SECT_XML(SQL Table) |
Index Back |
|---|---|
Specification "Wachtgeldfonds"Wage Declaration: Specification "Wachtgeldfonds" |
| # | 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 NOT NULL | Pay Period End Date |
| 5 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 0 |
| 6 | GPNL_SECTOR |
Number(3,0) | SMALLINT NOT NULL | WALVIS |
| 7 | GPNL_RISKGRP |
Number(2,0) | SMALLINT NOT NULL | WALVIS |
| 8 | GPNL_WW_BS_2E | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | WW Base 2e |
| 9 | GPNL_WW_CT_TT_2E | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | WW Total Contributn 2e |