HRS_BIP_JTSTXVW

(SQL View)
 Index Back

Used in XMLP report for Job O

XMLP Reprot Print Job Opening Tests and Examinations

SELECT A.HRS_JOB_OPENING_ID , B.JPM_CAT_ITEM_ID , B.JPM_DESCR90 FROM PS_HRS_JO_ITM01_VW A , PS_JPM_CAT_ITEMS_I B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND B.JPM_CAT_TYPE = 'TST' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_JPM_CAT_ITEMS_I C WHERE C.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND C.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND C.EFF_STATUS = B.EFF_STATUS AND C.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A'

# 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 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description