HRS_APP_CMP_I

(SQL View)
 Index Back

Applicant Competencies Interfa

APP_COMPS contains the competency ratings for each applicant evaluation.

SELECT HRS_PERSON_ID ,HRS_PROFILE_SEQ ,EVALUATION_ID ,COMPETENCY ,HRS_APP_CMP_ID ,DT_ISSUED ,YR_ACQUIRED ,YR_LAST_USED ,HOW_VERIFIED ,PROFICIENCY ,INTEREST_LEVEL ,YEARS_OF_EXP ,COMPETENCY_TXT FROM PS_HRS_APP_CMP WHERE 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 HRS_APP_CMP_ID Number(15,0) DECIMAL(15) NOT NULL Competency ID
    6 DT_ISSUED Date(10) DATE Issue Date
    7 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
    8 YR_LAST_USED Number(4,0) SMALLINT NOT NULL Year Last Used
    9 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
    10 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

    Prompt Table: REVW_RATING_TBL

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

    Prompt Table: INT_RATING_VW
    Set Control Field: REVIEW_RATING

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