SCRTY_MXPRMT_VW

(SQL View)
 Index Back

Prmpt for Sec by PList (matrx)

prompt table to get matrix team that can be associated with security by permission list definition (access code 046)

SELECT a.HRMH_MATRIX_ID ,a.EFF_STATUS ,a.HRMH_OWNER_EMPLID ,a.EMPL_RCD ,a.DESCR ,a.HRMH_SOURCE FROM PS_HRMH_MATRX_DEFN a WHERE a.effdt = ( SELECT MAX(sub.effdt) FROM ps_hrmh_matrx_defn sub WHERE a.hrmh_matrix_id = sub.hrmh_matrix_id AND sub.effdt <= %CurrentDateIn) AND a.eff_status = 'A' AND EXISTS( SELECT 1 FROM PS_SCRTY_MXRES_TBL RES WHERE a.HRMH_MATRIX_ID = RES.HRMH_MATRIX_ID)

  • Related Language Record: SCRTY_MXPRMT_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier
    2 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    3 HRMH_OWNER_EMPLID Character(11) VARCHAR2(11) NOT NULL Matrix Owner Employee ID

    Prompt Table: HRMH_OWNER_VW

    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 HRMH_SOURCE Character(1) VARCHAR2(1) NOT NULL Source for building an existing hierarchy.
    A=Use Access Type
    M=Manual
    T=Use Tree

    Default Value: M