SCRTY_MXREG_VW

(SQL View)
 Index Back

Matrix - SCRTY Regristry Table

Allows to register matrix groups as being used by secruity

SELECT A.HRMH_MATRIX_ID ,A.EFFDT ,A.EFF_STATUS ,A.HRMH_OWNER_EMPLID ,A.EMPL_RCD ,A.DESCR ,A.HRMH_SOURCE ,A.ACCESS_TYPE FROM PS_HRMH_MATRX_DEFN A WHERE A.EFFDT = ( SELECT MAX(sub.effdt) FROM PS_HRMH_MATRX_DEFN sub WHERE sub.HRMH_MATRIX_ID = A.HRMH_MATRIX_ID AND sub.effdt <= %CurrentDateIn )

  • 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

    Prompt Table: HRMH_MATRX_DEFN

    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
    8 ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
    1=By Dept Security Tree
    2=By Supervisor ID
    3=By Department Manager ID
    4=By Reports To Position
    5=By Part Posn Mgmt Supervisor
    6=By Part Posn Mgmt Dept Mgr ID
    7=By Group ID