HR_TPOOL_MBR

(SQL Table)
 Index Back

Talent Pool Members

Members assigned to a Talent Pool

  • Related Language Record: HR_TPOOL_MBRLNG

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: %RECNAME_EDIT

    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 HR_TP_MBR_TYPE Character(1) VARCHAR2(1) NOT NULL Talent Pool Member Type
    A=Applicant
    P=Person

    Default Value: P

    6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    7 HR_TP_READINESS Character(1) VARCHAR2(1) NOT NULL Displays Readiness of a Talent Pool Member.
    0=Ready Now
    1=1 - 2 Years
    2=3 - 5 Years
    E=Emergency
    N=Undefined
    R=Retirement
    8 HR_TP_IMP_OF_LOSS Character(1) VARCHAR2(1) NOT NULL Impact of Loss: indicates the impact to an organization if an employee terminates. Used on Succession Planning and Talent Pool
    1=High
    2=Medium
    3=Low
    9 COMMENTS Long Character CLOB Comment