FO_CNDTE_COMP

(SQL View)
 Index Back

SELECT 'X' , 'X' , 'X' , %Coalesce(B.COMPETENCY , C.COMPETENCY) , %Coalesce(B.PROFICIENCY , C.PROFICIENCY) , 5 , %Coalesce(B.YEARS_OF_EXP , C.YEARS_OF_EXP) , A.CANDIDATE_TYPE , A.CANDIDATE_ID FROM %Table(FO_CANDIDATE_W) A , %Table(FO_APP_COMPS) B , %Table(COMPETENCIES) C WHERE A.CANDIDATE_ID = B.APPLID (+) AND A.CANDIDATE_ID = C.EMPLID (+)

  • Parent record: RS_SO_LINE

  • Audit Record: RS_SO_AUDIT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SRCH_TYPE_CD Character(5) VARCHAR2(5) NOT NULL Search Type
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 SAVED_NAME Character(15) VARCHAR2(15) NOT NULL Saved Search Name
    4 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    5 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

    Prompt Table: REVW_RATING_VW

    6 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points
    7 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
    8 CANDIDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Candidate Type
    A=Applicant
    E=Employee
    9 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.