FO_CTE_ACMP_LNG

(SQL View)
 Index Back

SELECT 'X' , 'X' , 'X' , %Coalesce(B.ACCOMPLISHMENT , C.ACCOMPLISHMENT) , %Coalesce(B.SPEAK_PROFICIENCY , C.SPEAK_PROFICIENCY) , %Coalesce(B.READ_PROFICIENCY , C.READ_PROFICIENCY) , %Coalesce(B.WRITE_PROFICIENCY , C.WRITE_PROFICIENCY) , 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 = 'LNG')

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

    5 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High
    6 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High
    7 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High
    8 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points
    9 CANDIDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Candidate Type
    A=Applicant
    E=Employee
    10 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.