EQTX_ID_EXE_SEC

(SQL View)
 Index Back

Equation Id (name) Execute Vw

Equation Id (name) Execute Authority Security Search Vw

SELECT A.EQTN_ID_AUTH_CLASS ,A.EQUATION_NAME ,B.DESCR FROM PS_EQTN_ID_NAMAUTH A , PS_EQTN_NAME_VW B WHERE A.EQTN_AUTH_LEVEL IN ('E', 'R', 'W') AND A.EQUATION_NAME = B.EQUATION_NAME

  • Related Language Record: EQTXIDEXESECLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQTN_ID_AUTH_CLASS Character(30) VARCHAR2(30) NOT NULL Equation Id Auth Class
    2 EQUATION_NAME Character(12) VARCHAR2(12) NOT NULL Equation Name
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description