HR_MTRX_MEMB_VW

(SQL View)
 Index Back

Matrix Member View

Matrix Member View

SELECT A.HRMH_MATRIX_ID , A.EFFDT , A.EMPLID , A.EMPL_RCD , A.HRMH_MATRIX_TYPE , A.HRMH_TITLE , P.NAME_DISPLAY , A.HRMH_MEMBER_ROLE , A.SUPERVISOR_ID , A.SUPERVIS_EMPL_RCD , A.START_DT , A.END_DT , A.HRMH_NEW_START_DT , A.HRMH_NEW_END_DT , A.HRMH_MEMBER_ACTION , A.HRMH_MEMBER_STATUS , A.WF_STATUS FROM PS_HRMH_MATRX_MEMB A , PS_HRMH_MATRX_DEFN B , PS_PERSON_NAME P WHERE A.EMPLID=P.EMPLID AND A.HRMH_MATRIX_ID = B.HRMH_MATRIX_ID AND %EffdtCheck(HRMH_MATRX_defn D,B,%CurrentDatein) AND A.EFFDT = B.EFFDT UNION SELECT A.HRMH_MATRIX_ID , A.EFFDT , A.HRMH_OWNER_EMPLID , A.EMPL_RCD , A.HRMH_MATRIX_TYPE , A.HRMH_TITLE , P.NAME_DISPLAY , ' ' , ' ' , 0 , A.START_DT , A.END_DT , %DateNull , %DateNull , ' ' , A.EFF_STATUS , A.EFF_STATUS FROM PS_HRMH_MATRX_DEFN A , PS_PERSON_NAME P WHERE A.HRMH_OWNER_EMPLID = P.EMPLID AND %EffdtCheck(HRMH_MATRX_DEFN E,A,%CurrentDatein)

  • Related Language Record: HRMH_MTRX_MEM_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_MATRIX_TYPE Character(3) VARCHAR2(3) NOT NULL Matrix Type
    6 HRMH_TITLE Character(30) VARCHAR2(30) NOT NULL Hierarchy Member Employee Id
    7 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    8 HRMH_MEMBER_ROLE Character(30) VARCHAR2(30) NOT NULL Member Role
    9 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Default Value: HRMH_MATRX_DEFN.HRMH_OWNER_EMPLID

    Prompt Table: HRMH_REPTO_DVW

    10 SUPERVIS_EMPL_RCD Number(3,0) SMALLINT NOT NULL Supervisor employee record.
    11 START_DT Date(10) DATE Start Date

    Default Value: %date

    12 END_DT Date(10) DATE end date
    13 HRMH_NEW_START_DT Date(10) DATE New Start Date
    14 HRMH_NEW_END_DT Date(10) DATE New End Date
    15 HRMH_MEMBER_ACTION Character(3) VARCHAR2(3) NOT NULL To capture Member Action like Add Member/Change Duration/Inactivate Member
    A=Add Member
    AM=Add Member
    C=Change Duration
    CD=Change Duration
    I=Inactive Member
    IM=Inactive Member
    16 HRMH_MEMBER_STATUS Character(1) VARCHAR2(1) NOT NULL Matrix Member Status
    A=Active
    D=Denied
    F=Draft
    I=Inactive
    P=Pending
    17 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved