HRS_APPIDX_DT_V

(SQL View)
 Index Back

HRS_APPIDX_DT_V

record to fetch the index last 'n' datetime value for application

SELECT P.PTPG_FACET_NUMSRT2 , (CASE WHEN P.PTPG_FACET_NUMSRT2 <> 0 THEN ((%DateAdd(%CurrentDateIn , -1*(P.PTPG_FACET_NUMSRT2)))) WHEN P.PTPG_FACET_NUMSRT2 = 0 THEN (CASE WHEN ( SELECT (HRS_FROM_DATE) FROM PS_HRS_SRCHIDX_CTL WHERE HRS_SRCH_INDEX_CD = 'A') IS NOT NULL THEN ( SELECT ((HRS_FROM_DATE)) FROM PS_HRS_SRCHIDX_CTL WHERE HRS_SRCH_INDEX_CD = 'A') ELSE %DateIn('1900-01-01') END) END ) FROM PS_HRS_ADD_PRM_STG P WHERE P.PTSF_PARAM_NAME = 'INDEX_ONLY_LAST_DAYS' AND P.PTSF_SBO_NAME = 'HC_HRS_APP_INDEX'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTPG_FACET_NUMSRT2 Signed Number(11,0) DECIMAL(10) NOT NULL Number Value
2 HRS_FROM_DATE Date(10) DATE From Application Date