GPNL_WD_MSG_IDGPNL_EMPLR_TAX_IDPRD_BGN_DTPRD_END_DTGPNL_WD_EMPL_IDGPNL_SPCL_TAX_CDGPNL_TAX_TMP(SQL Table) |
Index Back |
|---|---|
Tax information TempWage Declaration: Employment Tax information Temp. |
| # | 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 | GPNL_SPCL_TAX_CD |
Character(2) | VARCHAR2(2) NOT NULL | Special Tax Code |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |