PAY_ENTITYGPNZ_PDR_YEARPYMT_DTGPNZ_PDR_RNTYPAMD=Amendment
NRM=Original
OVR=Override
Default Value: NRM
GPNZ_PDR_VERSION3=PDR File Generated
4=PDR Ready
EMPLIDGPNZ_PDR_AR_VW(SQL View) |
Index Back |
|---|---|
PDR DataEmployee Data Level for PDR |
| SELECT DISTINCT PAY_ENTITY , GPNZ_PDR_YEAR , PYMT_DT , GPNZ_PDR_RNTYP , GPNZ_PDR_VERSION , GPNZ_PDR_STATUS , EMPLID FROM PS_GPNZ_PDR_EE_DTL |
| # | 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 Default Value: NRM |
| 5 | GPNZ_PDR_VERSION |
Number(10,0) | DECIMAL(10) NOT NULL | New Field - Version added for PDR |
| 6 | GPNZ_PDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Issue status describes the level of the report.PDR Issued status
3=PDR File Generated 4=PDR Ready |
| 7 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |