HR_TP_PRMPT_VW

(SQL View)
 Index Back

Talent Pool Prompt Table

Talent Pool prompt table for succession plan processing ad-hoc search

SELECT DISTINCT a.HR_TP_ID ,a.EFFDT ,a.DESCR20 ,a.DESCR50 ,a.BUSINESS_UNIT ,a.POSITION_NBR ,a.JOBCODE ,a.JOB_FAMILY ,a.DEPTID ,a.COMPANY FROM PS_HR_TPOOL a ,PS_HR_TP_RB_SELECT b ,PS_HR_RATINGS_BOX c WHERE a.STATUS = 'A' AND a.HR_SP_CAND_SRCH = 'Y' AND b.HR_TP_ID = a.HR_TP_ID AND b.EFFDT = a.EFFDT AND EXISTS ( SELECT rb.HR_RATINGS_BOX_ID FROM PS_HR_TP_RB_DATA rb WHERE rb.HR_TP_ID = b.HR_TP_ID AND rb.EFFDT = b.EFFDT AND rb.HR_RATINGS_BOX_ID = b.HR_RATINGS_BOX_ID) AND c.HR_RATINGS_BOX_ID = b.HR_RATINGS_BOX_ID AND c.EFF_STATUS = 'A' AND c.HR_RB_TPOOL_IND = 'Y' AND %EffdtCheck(HR_RATINGS_BOX c1, c, b.EFFDT)

  • Related Language Record: HR_TP_PRT_VWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_TP_ID Character(30) VARCHAR2(30) NOT NULL Talent Pool ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date
    3 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    8 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family

    Prompt Table: JOB_FAMILY_TBL

    9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL