HRS_CAND_LST_VW

(SQL View)
 Index Back

Evaluation of Candidates Print

This view is used to build the query "Evaluation of Candidates" using PSQuery. The query, in turn, has been used to generate the Crystal Report "Evaluation of Candidates". This report can be printed from the Report Menu for Recruit WorkForce.

SELECT D.HRS_JOB_OPENING_ID , D.STATUS_CODE , X.DESCR , D.HRS_G_JO_TYPE , D.STATUS_REASON , A.JOBCODE , C.GVT_PAY_PLAN , C.GVT_OCC_SERIES , C.GRADE , C.GVT_ORG_TTL_DESCR , A.GVT_APPL_COMP_STS , A.HRS_PERSON_ID , B.HRS_SUBMITTED_DTTM , B.NAME_DISPLAY , F.NATIONAL_ID , B.APP_PER_STATUS , A.GVT_QUALS_DETERM , A.GVT_QUALS_DET_DATE , A.GVT_PRIO_PLCMNT_CD , A.GVT_VET_RECR_CODE , A.STATUS_CODE , A.HRS_STATUS_DT , A.STATUS_REASON , A.HRS_SCR_TTL_SCORE FROM PS_HRS_RCMNT_JOB A , PS_HRS_APPL_RPT_VW B , PS_JOBCODE_TBL C , PS_HRS_JOB_OPENING D , PS_HRS_APP_NID F , PS_HRS_RCMNT J , PS_HRS_STS_TBL X WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = F.HRS_PERSON_ID AND A.JOBCODE = C.JOBCODE AND C.SETID = ( SELECT G.SETID FROM PS_SET_CNTRL_GROUP G WHERE G.SETCNTRLVALUE = D.BUSINESS_UNIT AND G.REC_GROUP_ID = ( SELECT H.REC_GROUP_ID FROM PS_REC_GROUP_REC H WHERE H.RECNAME = 'HRS_JOBCODE_I')) AND C.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_HRS_JOBCODE_I I WHERE I.SETID = C.SETID AND I.JOBCODE = C.JOBCODE AND I.EFFDT <= %CurrentDateIn AND I.EFF_STATUS = 'A') AND J.HRS_PERSON_ID = A.HRS_PERSON_ID AND J.HRS_RCMNT_ID = A.HRS_RCMNT_ID AND J.HRS_JOB_OPENING_ID = D.HRS_JOB_OPENING_ID AND X.STATUS_AREA = '1' AND X.STATUS_CODE =D.STATUS_CODE AND B.HRS_PROFILE_SEQ = J.HRS_PROFILE_SEQ

  • Related Language Record: HRS_CANDLS_LNVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    2 JOB_REQ_STATUS Character(3) VARCHAR2(3) NOT NULL Job Requisition Status
    C=Closed
    F=Filled
    H=Hold
    N=Cancelled
    O=Open
    R=Re-Opened
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 HRS_G_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Federal job requisition type
    I=Internal
    M=Merit Promotion
    O=Open Competition
    5 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_REC_I

    6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    7 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    8 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    9 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    10 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    11 GVT_APPL_COMP_STS Character(1) VARCHAR2(1) NOT NULL Applicant Competitive Status
    0=Mark...
    C=Competitive
    N=Non-Competitive VRA
    O=Non-Competitive Other
    12 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    13 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    14 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    15 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    16 APP_PER_STATUS Character(1) VARCHAR2(1) NOT NULL Identifies the type of applicant - External Applicant, Employee or Non-Employee
    A=External Applicant
    E=Employee
    N=Non-Employee
    17 GVT_QUALS_DETERM Character(1) VARCHAR2(1) NOT NULL Qualifications Determination Flag
    B=Best Qualified
    D=Does Not Meet Min Quals
    N=Eligible/Not Rated
    Q=Qualified
    W=Well Qualified
    18 GVT_QUALS_DET_DATE Date(10) DATE Qualifications Determ Date
    19 GVT_PRIO_PLCMNT_CD Character(3) VARCHAR2(3) NOT NULL Priority Placement Code
    20 GVT_VET_RECR_CODE Character(3) VARCHAR2(3) NOT NULL Recruitment Code
    1=CPS
    2=CP
    3=XP
    4=TP
    5=NV
    21 APP_FOR_STATUS Character(3) VARCHAR2(3) NOT NULL Applied for Status
    A=Posted
    B=Screened - Preliminary
    C=Screened - Final
    D=Routing
    E=Interview
    F=Offer
    G=Offer Accepted
    H=Other Offer Accepted
    J=Offer Rejected
    K=Withdrawn
    L=Hired
    M=Rejected
    N=Requisition Closed
    P=On Hold
    Q=Preliminary Offer Decided
    R=Preliminary Offer Notified
    S=Preliminary Offer Accepted
    T=Preliminary Offer Rejected
    U=Hire Decided
    22 DISPOSITION_DT Date(10) DATE The date of the disposition.
    23 DISPOSITION_REASON Character(3) VARCHAR2(3) NOT NULL Rejected Reason
    24 HRS_SCR_TTL_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Screening score. Includes all points awarded to an applicant for a screening level, INCLUDING veterans preference points, augmenting factor points, and selective factor points.