ACA_ALE_VW_LNG

(SQL View)
 Index Back

Related Lang for ACA_ALE_VW


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

  • Related Language Record for ACA_ALE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ACA_DESCR Character(75) VARCHAR2(75) NOT NULL Name