FO_CAN_JOBTITLS

(SQL View)
 Index Back

SELECT A.CANDIDATE_ID , COALESCE(B.JOB_CAT , C.JOB_CAT) , COALESCE(B.FO_JOBTITLE , C.FO_JOBTITLE) , COALESCE(B1.DESCR100 , C1.DESCR100) FROM PS_FO_CANDIDATE_W A , PS_FO_APP_JOBTITLS B , PS_FO_JOBTITLE B1 ,PS_FO_EMP_JOBTITLS C , PS_FO_JOBTITLE C1 WHERE A.CANDIDATE_ID = B.APPLID (+) AND B.JOB_CAT = B1.JOB_CAT (+) AND B.FO_JOBTITLE = B1.FO_JOBTITLE (+) AND A.CANDIDATE_ID = C.EMPLID (+) AND C.JOB_CAT = C1.JOB_CAT (+) AND C.FO_JOBTITLE = C1.FO_JOBTITLE (+) AND A.EMPL_STATUS ='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CANDIDATE_ID Character(11) VARCHAR2(11) NOT NULL Used as a general ID for anything from Employee id to other types of ID like asset and material.
2 JOB_CAT Character(3) VARCHAR2(3) NOT NULL Job Category

Prompt Table: FO_JOBTITLE_HDR

3 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code

Prompt Table: FO_JOBTITLE_VW

4 JOB_DESCR Long Character CLOB Job Description