SCRTY_MXPRMT2LN

(SQL View)
 Index Back

SCRTY GB Prmpt for Grps REL LN

prompts for permissable groups (as per GB setup by Operator ID and driving component). The component must be defined in GB security setup for the user - related language table

SELECT a.HRMH_MATRIX_ID ,a.LANGUAGE_CD , a.DESCR FROM PS_HRMH_MTRX_DEF_L a WHERE a.EFFDT = ( SELECT MAX(SUB.EFFDT) FROM PS_HRMH_MTRX_DEF_L SUB WHERE a.HRMH_MATRIX_ID = SUB.HRMH_MATRIX_ID AND SUB.EFFDT <= %CurrentDateIn)

  • Related Language Record for SCRTY_MXPRMT2VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description