HRS_HJ_HIST_VW

(SQL View)
 Index Back

SELECT DISTINCT A.HRS_JOB_OPENING_ID , A.RULE_ID_ER , B.DESCR FROM PS_HRS_JO_HJ_HIST A , PS_HRS_RULE_DEF B WHERE A.RULE_TYPE_ER = B.RULE_TYPE_ER AND A.RULE_ID_ER = B.RULE_ID_ER

  • Related Language Record: HRS_HJ_HIST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JOB_OPENING

    2 RULE_ID_ER Character(12) VARCHAR2(12) NOT NULL Hot Job ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description