PROCESS_INSTANCERUN_CNTL_IDPAY_ENTITYGPNZ_PDR_YEARPYMT_DTCAL_RUN_IDCAL_IDGPNZ_PDR_RNTYPAMD=Amendment
NRM=Original
OVR=Override
GPNZ_REC_TYPEEMPLIDFIELDNAMEGPNZ_FIELDVALUEGPNZ_PDR_ERRLOG(SQL Table) |
Index Back |
|---|---|
PDR error logError Log record used for PDR data Prep process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 4 | GPNZ_PDR_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Year code |
| 5 | PYMT_DT |
Date(10) | DATE | Payment Date |
| 6 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 7 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 8 | GPNZ_PDR_RNTYP |
Character(3) | VARCHAR2(3) NOT NULL |
PDR Run Type
AMD=Amendment NRM=Original OVR=Override |
| 9 | GPNZ_REC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Record type whether Header or Employee |
| 10 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 11 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 12 | GPNZ_FIELDVALUE |
Character(30) | VARCHAR2(30) NOT NULL | Field Value used in the Error Logging to identify the comparison |