HRMH_MBR_NAME_V

(SQL View)
 Index Back

Manual Matrix Members and Name

View of manual matrix members joined to get members' names.

SELECT M.HRMH_MATRIX_ID , M.EFFDT , M.EMPLID , M.EMPL_RCD , M.HRMH_TITLE , M.SUPERVISOR_ID , M.SUPERVIS_EMPL_RCD , M.START_DT , M.HRMH_MEMBER_STATUS , N.NAME_DISPLAY FROM PS_HRMH_MATRX_MEMB M , PS_PERSON_NAME N WHERE M.EMPLID = N.EMPLID

  • Related Language Record: HRMH_MBR_NAME_L

  • Parent record: HRMH_MATRX_DEFN

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

    Default Value: %date

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HRMH_EMPLID_VW

    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 HRMH_TITLE Character(30) VARCHAR2(30) NOT NULL Hierarchy Member Employee Id
    6 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Default Value: HRMH_MATRX_DEFN.HRMH_OWNER_EMPLID

    Prompt Table: HRMH_REPTO_DVW

    7 SUPERVIS_EMPL_RCD Number(3,0) SMALLINT NOT NULL Supervisor employee record.
    8 START_DT Date(10) DATE Start Date
    9 HRMH_MEMBER_STATUS Character(1) VARCHAR2(1) NOT NULL Matrix Member Status
    A=Active
    D=Denied
    F=Draft
    I=Inactive
    P=Pending
    10 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country