EQTN_APPLID_VW

(SQL View)
 Index Back

Equation App Engine View

Equation App Engine View

SELECT A.EQTN_OPERAND_APPL ,A.DESCR ,A.AE_PRODUCT ,A.AE_APPL_ID FROM PS_EQTN_APPLID_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_EQTN_APPLID_TBL B WHERE B.EQTN_OPERAND_APPL = A.EQTN_OPERAND_APPL AND B.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS = 'A'

  • Related Language Record: EQTNAPPLIDVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQTN_OPERAND_APPL Character(8) VARCHAR2(8) NOT NULL Equation App Engine Applid
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 AE_PRODUCT Character(2) VARCHAR2(2) NOT NULL Product
    AE=PS/AE
    AM=PS/AM
    AP=PS/AP
    AR=PS/AR
    BI=PS/BI
    EO=PS/EO
    EX=PS/EX
    FS=PS/FS
    GL=PS/GL
    HR=PS/HR
    IN=PS/IN
    OM=PS/OM
    PC=PS/PC
    PO=PS/PO
    TR=PS/TR
    4 AE_APPL_ID Character(8) VARCHAR2(8) NOT NULL Application