HRMH_DEF_MEM_L

(SQL View)
 Index Back

Matrix Defn Rel Lang

Defines a Matrix Hierarchy

SELECT A.HRMH_MATRIX_ID ,E.LANGUAGE_CD , A.EFFDT , A.DESCR FROM PS_HRMH_MATRX_DEFN A , PS_HRMH_MATRX_MEMB B , PS_PERSON_NAME C , PS_PERSON_NAME D ,PS_HRMH_MTRX_DEF_L E , PSXLATITEM X WHERE A.hrmh_matrix_id = B.hrmh_matrix_id AND A.hrmh_matrix_id = E.hrmh_matrix_id AND A.HRMH_OWNER_EMPLID = C.EMPLID AND b.emplid=D.emplid AND %EffdtCheck(HRMH_MATRX_defn D,B,%CurrentDatein) AND A.effdt = b.effdt AND B.HRMH_MEMBER_ACTION=X.FIELDVALUE AND X.FIELDNAME='HRMH_MEMBER_ACTION' AND %EffdtCheck(PSXLATITEM X1,X,%CurrentDatein)

  • Related Language Record for HRMH_DEF_MEM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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