HR_VT_TPOOL_VW

(SQL View)
 Index Back

SP360 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 b.HR_TP_ID = a.HR_TP_ID AND b.EFFDT = a.EFFDT 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, a.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