SCRTY_MXRUN_VW

(SQL View)
 Index Back

Prompt by Registered Matrix

used to prompt for a registered matrix (security registration) on runcontrol which refreshes security related matrix team table

SELECT a.HRMH_MATRIX_ID ,b.effdt ,b.EFF_STATUS ,b.HRMH_OWNER_EMPLID ,b.EMPL_RCD ,b.DESCR ,b.HRMH_SOURCE FROM PS_SCRTY_MXREG_TBL a , PS_HRMH_MATRX_DEFN b WHERE a.HRMH_MATRIX_ID = b.HRMH_MATRIX_ID AND b.effdt = ( SELECT MAX(sub.effdt) FROM PS_HRMH_MATRX_DEFN sub WHERE b.hrmh_matrix_id = sub.hrmh_matrix_id AND sub.effdt <= %CurrentDateIn)

  • Related Language Record: SCRTY_MXRUN_LN

    • # 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 Effective Date

    Default Value: %date

    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    4 HRMH_OWNER_EMPLID Character(11) VARCHAR2(11) NOT NULL Matrix Owner Employee ID

    Prompt Table: HRMH_OWNER_VW

    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 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