FO_CAND_TEST

(SQL View)

SELECT A.CANDIDATE_ID , %Coalesce(B.ACCOMPLISHMENT, C.ACCOMPLISHMENT) , %Coalesce(B.SCORE, C.SCORE) , %Coalesce(B.PASSED, C.PASSED) FROM %Table(FO_CANDIDATE_W) A , %Table(FO_APP_ACCOMPS) B ,%Table(ACCOMPLISHMENTS) C , %Table(RS_CM_TEST_VW) D WHERE A.CANDIDATE_ID = B.APPLID (+) AND A.CANDIDATE_ID = C.EMPLID (+) AND A.EMPL_STATUS ='A' AND (B.ACCOMPLISHMENT = D.ACCOMPLISHMENT OR C.ACCOMPLISHMENT = D.ACCOMPLISHMENT)

# 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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
Prompt Table: RS_CM_TEST_VW

3 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score

4 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test

#	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	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment Prompt Table: RS_CM_TEST_VW
3	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score
4	PASSED	Character(1)	VARCHAR2(1) NOT NULL	Passed Test