HRS_JO_PSN_LN_I

(SQL View)
 Index Back

Job Opening Positions Intfc RL

Job opening positions interface view for related language

SELECT A.HRS_JOB_OPENING_ID , A.POSITION_NBR , B.LANGUAGE_CD , B.DESCR FROM PS_HRS_JO_POSN A , PS_HCR_POSDTAC_LNI B WHERE A.POSITION_NBR = B.POSITION_NBR AND %EffdtCheck(HCR_POSDTAC_LNI C, B, %CurrentDateIn)

  • Related Language Record for HRS_JO_POSN_I HRS_JO_PRMPSN_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description