EQTX_TB_REA_SEC

(SQL View)
 Index Back

Equation Table Read Vw

Equation Data Table (Recname) Read Authority Security Search Vw

SELECT A.EQTN_TB_AUTH_CLASS ,A.EQTN_DATA_RECNAME ,B.DESCR FROM PS_EQTN_TB_RECAUTH A , PS_EQTN_DATA_VW B WHERE A.EQTN_AUTH_LEVEL IN ('R', 'W' ) AND A.EQTN_DATA_RECNAME = B.EQTN_DATA_RECNAME

  • Related Language Record: EQTXTBREASECLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQTN_TB_AUTH_CLASS Character(30) VARCHAR2(30) NOT NULL Equation Table Authorization Class
    2 EQTN_DATA_RECNAME Character(15) VARCHAR2(15) NOT NULL Equation Processor Data Record Name.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description