HRS_JOBPOST_VW

(SQL View)
 Index Back

Job Posting View

Job Posting View

SELECT DISTINCT A.HRS_JOB_OPENING_ID ,COALESCE(A.HRS_JO_PST_OPN_DT ,%DateIn('1900-01-01')) ,COALESCE(A.HRS_JO_PST_CLS_DT ,%DateIn('9999-12-31')) ,CASE WHEN (A.HRS_JO_PST_OPN_DT IS NOT NULL AND %CurrentDateIn > A.HRS_JO_PST_OPN_DT) THEN %DateDiff(A.HRS_JO_PST_OPN_DT,%CurrentDateIn) ELSE 0 END ,CASE WHEN (A.HRS_JO_PST_CLS_DT IS NOT NULL AND %CurrentDateIn < A.HRS_JO_PST_CLS_DT) THEN %DateDiff(%CurrentDateIn,A.HRS_JO_PST_CLS_DT) ELSE 0 END ,CASE WHEN (A.HRS_JO_PST_CLS_DT IS NOT NULL AND %CurrentDateIn < A.HRS_JO_PST_CLS_DT) THEN %Cast(%DateDiff(%CurrentDateIn,A.HRS_JO_PST_CLS_DT),number,character) WHEN (A.HRS_JO_PST_CLS_DT IS NOT NULL AND %CurrentDateIn >= A.HRS_JO_PST_CLS_DT) THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 18175 AND MESSAGE_NBR = 5139) ELSE ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 18175 AND MESSAGE_NBR = 5138) END FROM PS_HRS_JO_PST_DST A , PS_HRS_JO_POSTING JP WHERE A.HRS_JOB_OPENING_ID = JP.HRS_JOB_OPENING_ID AND A.HRS_JO_PST_SEQ = JP.HRS_JO_PST_SEQ AND JP.HRS_JO_PRM_PST_FLG = 'Y' AND A.HRS_JO_PST_OPN_DT = ( SELECT MIN(B.HRS_JO_PST_OPN_DT) FROM PS_HRS_JO_PST_DST B WHERE B.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND B.HRS_JO_PST_SEQ = A.HRS_JO_PST_SEQ AND B.HRS_JO_PST_OPN_DT IS NOT NULL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
2 HRS_JO_PST_OPN_DT Date(10) DATE Job opening posting open date
3 HRS_JO_PST_CLS_DT Date(10) DATE Job opening post close date
4 HRS_DAYS_OPEN Number(5,0) INTEGER NOT NULL Days Open
5 HRS_DAYS_TO_FILL Number(5,0) INTEGER NOT NULL Days to Fill
6 HRS_DAYS_CLOSE Character(30) VARCHAR2(30) NOT NULL Days Left To Close