GPNL_WD_MSG_IDGPNL_EMPLR_TAX_IDPRD_BGN_DTPRD_END_DTSEQ_NODefault Value: 0
ORIG_BEGIN_DTGPNL_CORR_XML(SQL Table) |
Index Back |
|---|---|
Balance corrections prev. prd.Wage Declaration: Balance corrections previous periods. |
| # | 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 | ORIG_BEGIN_DT |
Date(10) | DATE NOT NULL | original begin date |
| 7 | ORIG_END_DT | Date(10) | DATE | Unadjusted End Date |
| 8 | GPNL_WD_DELTA | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Field used in the XML structure for the Wage Declaration to store the Delta between the re-calculated and the original collective total amount to be paid for a previous period |