HRS_CURR_CMP_VW

(SQL View)
 Index Back

Current Applicant Comp

Returns the most recent evaluation for each applicant competency.

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.EVALUATION_ID ,A.COMPETENCY ,A.DT_ISSUED ,A.YR_ACQUIRED ,A.YR_LAST_USED ,A.HOW_VERIFIED ,A.PROFICIENCY ,A.INTEREST_LEVEL ,A.YEARS_OF_EXP ,A.COMPETENCY_TXT FROM PS_HRS_APP_CMP_I A WHERE EVALUATION_ID = ( SELECT MAX(B.EVALUATION_ID) FROM PS_HRS_APP_CMP_I B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = B.HRS_PROFILE_SEQ AND A.COMPETENCY = B.COMPETENCY)

  • Parent record: HRS_APP_CM_EVAL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID
    4 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    5 DT_ISSUED Date(10) DATE Issue Date
    6 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
    7 YR_LAST_USED Number(4,0) SMALLINT NOT NULL Year Last Used
    8 HOW_VERIFIED Character(1) VARCHAR2(1) NOT NULL Verified By
    E=Employee Claim
    J=On the Job Training
    N=Not Verified
    O=Employer Observation
    T=By Test
    V=NVQ Authority
    9 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

    Prompt Table: REVW_RATING_TBL

    10 INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level

    Prompt Table: INT_RATING_VW
    Set Control Field: REVIEW_RATING

    11 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
    12 COMPETENCY_TXT Character(30) VARCHAR2(30) NOT NULL Competency Text