ACA_DATEX_ID_VW

(SQL View)
 Index Back

ALE Member -Aggregated ALE Grp

ALE Member linked to Aggregated Group ID

SELECT A.ACA_DAT_EXTRACT_ID , A.DESCR FROM PS_ACA_DATEXTR_DEF A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ACA_DATEXTR_DEF A1 WHERE A1.ACA_DAT_EXTRACT_ID = A.ACA_DAT_EXTRACT_ID AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_ACA_DATEXTR_DEF A2 WHERE A2.ACA_DAT_EXTRACT_ID = A.ACA_DAT_EXTRACT_ID AND A2.EFFDT = A.EFFDT)

  • Related Language Record: ACA_DATEX_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACA_DAT_EXTRACT_ID Character(10) VARCHAR2(10) NOT NULL Extract ID for the ACA data
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description