FO_CTE_ACMP_DEG

(SQL View)
 Index Back

Degrees


SELECT 'X' , 'X' , 'X' , %Coalesce(B.ACCOMPLISHMENT , C.ACCOMPLISHMENT) , %Coalesce(B.MAJOR_CODE , C.MAJOR_CODE) , 5 , A.CANDIDATE_TYPE , A.CANDIDATE_ID FROM %Table(FO_CANDIDATE_W) A ,%Table(FO_APP_ACCOMPS) B , %Table(ACCOMPLISHMENTS) C WHERE A.CANDIDATE_ID = B.APPLID (+) AND A.CANDIDATE_ID = C.EMPLID (+) AND %Coalesce(B.ACCOMPLISHMENT , C.ACCOMPLISHMENT) IN ( SELECT Z.ACCOMPLISHMENT FROM PS_ACCOMP_TBL Z WHERE Z.ACCOMP_CATEGORY = 'DEG')

  • 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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: RS_ACMP_DEG_VW

    5 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

    Prompt Table: MAJOR_TBL

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