EQTN_NAME_VW

(SQL View)
 Index Back

Equation Name View

Equation Name View

SELECT A.EQUATION_NAME ,A.EFFDT ,A.DESCR FROM PS_EQUATION_TBL A WHERE A.EFFDT= ( SELECT MAX(B.EFFDT) FROM PS_EQUATION_TBL B WHERE B.EQUATION_NAME = A.EQUATION_NAME AND B.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS='A'

  • Related Language Record: EQTNNAMEVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQUATION_NAME Character(12) VARCHAR2(12) NOT NULL Equation Name
    2 EFFDT Date(10) DATE Effective Date
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description