DP_IPPDPERYR_VW

(SQL View)
Index Back

DP_IPPDPERYR_VW

DP_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

  • Parent record: DP_USERDATACDS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_PDSPERYEAR Number(2,0) SMALLINT NOT NULL DP_PDSPERYEAR