FMEV_AES_VW

(SQL View)
 Index Back

Fusion Evaluator - AE section

Used in the Fusion Upgrade Evaluator to lookup upgrade AE section details. PSFTHCM Fusion Migration view.

SELECT A.AE_APPLID , A.AE_SECTION , A.DESCR , A.DESCRLONG FROM PSAESECTDTLDEFN A , PSAESECTDEFN B WHERE B.AE_APPLID = A.AE_APPLID AND B.AE_SECTION = A.AE_SECTION AND A.AE_APPLID LIKE 'FM%' AND A.AE_APPLID <> 'FMEVAL' AND A.AE_APPLID <> 'FMSAUTOPILOT' AND A.MARKET = 'GBL' AND A.DBTYPE=' ' AND B.AE_PUBLIC_SW = 'Y' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSAESECTDTLDEFN C WHERE C.AE_APPLID=A.AE_APPLID AND C.AE_SECTION = A.AE_SECTION AND C.MARKET = A.MARKET AND C.DBTYPE = A.DBTYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
2 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRLONG Long Character CLOB Long Description