PAY_ENTITYGPNZ_PDR_YEARPYMT_DTGPNZ_PDR_RNTYPAMD=Amendment
NRM=Original
OVR=Override
GPNZ_REC_TYPEGPNZ_DET_IDGPNZ_TAX_SCALEEMPLIDFIELDNAMEGPNZ_PDR_ERFLOG(SQL Table) |
Index Back |
|---|---|
Error Log Record for PDRError Log Record for PDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | GPNZ_PDR_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Year code |
| 3 | PYMT_DT |
Date(10) | DATE | Payment Date |
| 4 | GPNZ_PDR_RNTYP |
Character(3) | VARCHAR2(3) NOT NULL |
PDR Run Type
AMD=Amendment NRM=Original OVR=Override |
| 5 | GPNZ_REC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Record type whether Header or Employee |
| 6 | GPNZ_DET_ID |
Character(3) | VARCHAR2(3) NOT NULL | Literal field 'DTR' |
| 7 | GPNZ_TAX_SCALE |
Character(4) | VARCHAR2(4) NOT NULL | New Zealand Tax Scale |
| 8 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 10 | GPNZ_FIELDVALUE | Character(30) | VARCHAR2(30) NOT NULL | Field Value used in the Error Logging to identify the comparison |