EQTX_ID_REA_SEC

(SQL View)
 Index Back

Equation Id (name) Read Vw

Equation Id (name) Read 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 ('R', 'W' ) AND A.EQUATION_NAME = B.EQUATION_NAME

  • Related Language Record: EQTXIDREASECLNG

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