FO_CAN_OWNERS

(SQL View)
 Index Back

SELECT A.CANDIDATE_ID , %Coalesce(B.OPRID, C.OPRID) FROM %Table(FO_CANDIDATE_W) A ,%Table(FO_APP_OWNERS) B , %Table(FO_EMP_OWNERS) C WHERE A.CANDIDATE_ID = B.APPLID (+) AND A.CANDIDATE_ID = C.EMPLID (+) 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).