HR_MTRX_MEMB_V1

(SQL View)
 Index Back

Matrix Member View2

Matrix Member View2

SELECT A.HRMH_MATRIX_ID , A.EFFDT , A.EMPLID , A.EMPL_RCD , A.HRMH_TITLE , A.HRMH_MEMBER_ROLE , A.SUPERVISOR_ID , A.SUPERVIS_EMPL_RCD , A.START_DT , A.END_DT , A.HRMH_MEMBER_STATUS , A.WF_STATUS FROM PS_HRMH_MATRX_MEMB A WHERE %EffdtCheck(HRMH_MATRX_MEMB B,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_TITLE Character(30) VARCHAR2(30) NOT NULL Hierarchy Member Employee Id
    6 HRMH_MEMBER_ROLE Character(30) VARCHAR2(30) NOT NULL Member Role
    7 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Default Value: HRMH_MATRX_DEFN.HRMH_OWNER_EMPLID

    Prompt Table: HRMH_REPTO_DVW

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

    Default Value: %date

    10 END_DT Date(10) DATE end date
    11 HRMH_MEMBER_STATUS Character(1) VARCHAR2(1) NOT NULL Matrix Member Status
    A=Active
    D=Denied
    F=Draft
    I=Inactive
    P=Pending
    12 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