ACA_ALE_VW

(SQL View)
 Index Back

ACA ALE Search View


SELECT A.ACA_ALE_MEMBER , A.ACA_DESCR FROM PS_ACA_ALE_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ACA_ALE_TBL A1 WHERE A1.ACA_ALE_MEMBER = A.ACA_ALE_MEMBER AND A1.EFFDT <= %CurrentDateIn )

  • Related Language Record: ACA_ALE_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACA_ALE_MEMBER Character(3) VARCHAR2(3) NOT NULL Used to contain value of ALE Member name
    2 ACA_DESCR Character(75) VARCHAR2(75) NOT NULL Name