HRS_JO_PRMPSN_I

(SQL View)
 Index Back

JO Primary Positions Intfc

Job opening primary position interface view

SELECT A.HRS_JOB_OPENING_ID , A.POSITION_NBR , B.DESCR FROM PS_HRS_JO_POSN A , PS_HRS_POS_DTA_C_I B WHERE A.HRS_JO_PRM_PSN_FLG = 'Y' AND A.POSITION_NBR = B.POSITION_NBR AND %EffdtCheck(HRS_POS_DTA_C_I C, B, %CURRENTDATEIN)

  • Related Language Record: HRS_JO_PSN_LN_I

    • # 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_JO_I

    2 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: HRS_POS_DTA_C_I

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description