PAY_ENTITYGPNZ_PDR_YEARPYMT_DTCAL_RUN_IDGPNZ_PDRCR_VW1(SQL View) |
Index Back |
|---|---|
View Finalysed CalendarRecord View to fetch Finalysed Calanders for Run Control |
| SELECT DISTINCT DTL.PAY_ENTITY , DTL.GPNZ_PDR_YEAR , DTL.PYMT_DT , DTL.CAL_RUN_ID , CAL.DESCR 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 | PYMT_DT |
Date(10) | DATE | Payment Date |
| 4 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |