HRS_APP_CMEVL_I

(SQL View)
Index Back

Applicant Evaluation

APP_CM_EVALS identifies each competency evaluation of your applicants. The evaluation is identified by an assigned EVALUATION_ID. Also, each evaluation has an EVALUATION_TYPE, an optional REVIEWER_ID, and a flag to identify whether or not the evaluation is active.

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.EVALUATION_ID , A.EVALUATION_TYPE , A.REVIEWER_ID , A.DESCR50 , A.REVIEWER_APPRVD , A.REVIEW_DT , A.REVIEW_STATUS , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_APP_CM_EVAL A

  • Related Language Record: HRS_APP_CEV_LNG
  • Parent record: HRS_APP_PROFILE
  • # 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

    Default Value: 01

    4 EVALUATION_TYPE Character(1) VARCHAR2(1) NOT NULL Evaluation Type
    A=Approved/Official
    B=Subordinate
    C=Customer
    E=Executive Committee
    L=Learning
    M=Mentor
    P=Peer
    R=Supervisor/Manager
    S=Self
    5 REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID

    Prompt Table: PERSON_NAME

    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 REVIEWER_APPRVD Character(1) VARCHAR2(1) NOT NULL Reviewer is Approved

    Y/N Table Edit

    Default Value: N

    8 REVIEW_DT Date(10) DATE Review Date
    9 REVIEW_STATUS Character(1) VARCHAR2(1) NOT NULL Review Status

    Y/N Table Edit

    Default Value: Y

    10 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    11 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    12 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    13 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id