DP_IPPDPERYR_VW(SQL View) |
Index Back |
---|---|
DP_IPPDPERYR_VWDP_IPPDPERYR_VW |
SELECT B.DP_PDSPERYEAR FROM PS_DP_POLICYSETS A , PS_DP_CALTIMECODES B WHERE B.DP_CALENDARID = A.DP_CALENDARID AND B.DP_TIMEPERIODCODE = A.DP_TIMEPERIODCODE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DP_PDSPERYEAR | Number(2,0) | SMALLINT NOT NULL | DP_PDSPERYEAR |