HRBP_MTRX_SRCHL

(SQL View)
 Index Back

Rel Lang for HRBP_MTRX_SRCH

Relate Language record for HRBP_MTRX_SRCH.

SELECT A.HRMH_MATRIX_ID , B.LANGUAGE_CD , B.DESCR FROM PS_HRMH_MATRX_DEFN A , PS_HRMH_MTRX_DEF_L B WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_HRMH_MATRX_DEFN A1 WHERE A1.HRMH_MATRIX_ID = A.HRMH_MATRIX_ID AND A1.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS = 'A' AND B.HRMH_MATRIX_ID = A.HRMH_MATRIX_ID AND B.EFFDT = A.EFFDT

  • Related Language Record for HRBP_MTRX_NONBP HRBP_MTRX_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier

    Default Value: NEW

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description