EOTP_RECRUIT

(SQL Table)
Index Back

TPM Recruitment Event

Recruitment Event

  • Related Language Record: EOTP_RECRT_LANG
  • Audit Record: AUDIT_EOTP_RECR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: EOTP_RECT_BU

    2 EOTP_RECRUITID Number(15,0) DECIMAL(15) NOT NULL Recruit ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description
    5 EOTP_PUBLIC Character(1) VARCHAR2(1) NOT NULL Public Flag

    Y/N Table Edit

    Default Value: N

    6 EOTP_RECT_STATUS Character(1) VARCHAR2(1) NOT NULL TPM recruitment Status
    F=Notifications Failed
    O=Open
    R=Notifications Resent
    S=Notifications Sent

    Default Value: O