HRS_JO_POST_I

(SQL View)
 Index Back

Ext and Int Job Openings

Job openings with postings that are available for external and internal applicants.

SELECT A.HRS_JOB_OPENING_ID ,C.HRS_JO_PST_TYPE ,C.HRS_JO_PST_OPN_DT ,C.HRS_JO_PST_CLS_DT FROM PS_HRS_JOB_OPENING A , PS_HRS_JO_POSTING B , PS_HRS_JO_PST_DST C , PS_HRS_SOURCE D WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND A.HRS_JOB_OPENING_ID = C.HRS_JOB_OPENING_ID AND B.HRS_JO_PST_SEQ = C.HRS_JO_PST_SEQ AND (C.HRS_JO_PST_TYPE = 'E' OR C.HRS_JO_PST_TYPE = 'I') AND (C.HRS_JO_PST_CLS_DT >= %CurrentDateIn OR C.HRS_JO_PST_CLS_DT IS NULL AND (C.HRS_JO_PST_OPN_DT <= %CurrentDateIn OR C.HRS_JO_PST_OPN_DT IS NULL)) AND C.HRS_SOURCE_ID = D.HRS_SOURCE_ID AND D.HRS_SOURCE_TYPE = '40'

# 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

Prompt Table: HRS_JO_I

2 HRS_JO_PST_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Posting Type
C=Contingent Workforce
E=External Posting
I=Internal Posting
L=Labor Office
R=Recruitment
3 OPEN_DT Date(10) DATE Created
4 CLOSE_DT Date(10) DATE Date Closed