EQTXIDEXESECLN

(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.LANGUAGE_CD ,B.DESCR FROM PS_EQTN_ID_NAMAUTH A , PS_EQTNNAMEVWLNG 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description