PAY_ENTITYGPNZ_PDR_YEARGPNZ_PDR_RNTYPAMD=Amendment
NRM=Original
OVR=Override
PYMT_DTGPNZ_PDRPD_VW1(SQL View) |
Index Back |
|---|---|
View for Open&Final CalandersRecord View to fetch Open & Finalysed Calanders for Run Control |
| SELECT DISTINCT DTL.PAY_ENTITY , DTL.GPNZ_PDR_YEAR , DTL.GPNZ_PDR_RNTYP , DTL.PYMT_DT FROM PS_GPNZ_PDR_ER_DTL DTL , PS_GP_CAL_RUN CAL WHERE DTL.CAL_RUN_ID = CAL.CAL_RUN_ID AND DTL.GPNZ_PDR_STATUS ='4' AND (CAL.RUN_OPEN_IND = 'Y' OR CAL.RUN_FINALIZED_IND = 'Y') |
| # | 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 | GPNZ_PDR_RNTYP |
Character(3) | VARCHAR2(3) NOT NULL |
PDR Run Type
AMD=Amendment NRM=Original OVR=Override |
| 4 | PYMT_DT |
Date(10) | DATE | Payment Date |