FO_CTE_ACMP_LIC

(SQL View)
 Index Back

SELECT 'X' , 'X' , 'X' , %Coalesce(B.ACCOMPLISHMENT , C.ACCOMPLISHMENT) , %Coalesce(B.COUNTRY , C.COUNTRY) , %Coalesce(B.STATE , C.STATE) ,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 = 'LIC')

  • 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_LIC_VW

    5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    6 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    7 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points
    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.