HR_TPOOL_SRCHVW

(SQL View)
Index Back

Talent Pool Search Record

Search Record for Talent Pool feature

SELECT TP.HR_TP_ID ,TP.EFFDT ,TP.HR_TP_CAT_ID ,TP.STATUS ,TP.DESCR20 ,TP.DESCR50 ,TP.BUSINESS_UNIT ,TP.POSITION_NBR ,TP.JOBCODE ,TP.JOB_FAMILY ,TP.DEPTID ,TP.COMPANY FROM PS_HR_TPOOL TP WHERE (TP.EFFDT = ( SELECT MAX(TP1.EFFDT) FROM PS_HR_TPOOL TP1 WHERE TP.HR_TP_ID = TP1.HR_TP_ID AND TP1.EFFDT <= %CurrentDateIn) OR TP.EFFDT = ( SELECT MAX(TP2.EFFDT) FROM PS_HR_TPOOL TP2 WHERE TP.HR_TP_ID = TP2.HR_TP_ID AND TP2.EFFDT > %CurrentDateIn))

  • Related Language Record: HR_TPOOL_SRCHLG
  • # 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 Effective Date

    Default Value: %date

    3 HR_TP_CAT_ID Character(30) VARCHAR2(30) NOT NULL Talent Pool Category
    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    5 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    8 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    9 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    10 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    12 COMPANY Character(3) VARCHAR2(3) NOT NULL Company