GPNL_WD_MSG_IDGPNL_EMPLR_TAX_IDPRD_BGN_DTPRD_END_DTGPNL_WD_EMPL_IDC=Correction
D=Withdrawal
I=Initial
GPNL_EMPL_XML(SQL Table) |
Index Back |
|---|---|
Employment informationWage Declaration: Employment information |
| # | 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_WD_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Employment Number to be used in Wage Declaration. This will be EMPL_RCD + 1 as Tax Authority will not accept zero as the Employment Number. |
| 7 | GPNL_WD_RSN_END | Character(2) | VARCHAR2(2) NOT NULL | The reason for ending the contract with a temp from an agency, used within the wage declaration file structure |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 10 | GPNL_WD_EMPL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indication for the type of the Employment Record within the Wage Declaration, e.g. Initial, Correction or Withdrawal.
C=Correction D=Withdrawal I=Initial |
| 11 | HIRE_DT | Date(10) | DATE | First Start Date |
| 12 | TERMINATION_DT | Date(10) | DATE | Termination Date |