PSDMT_AE_VW

(SQL View)
Index Back

MTM Section Names


SELECT DISTINCT A.AE_APPLID , A.AE_SECTION , B.DESCR FROM PSAESECTDEFN A , PSAESECTDTLDEFN B WHERE A.AE_APPLID = B.AE_APPLID AND A.AE_SECTION = B.AE_SECTION AND %EffdtCheck(PSAESECTDTLDEFN B2, B, %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.AE_PUBLIC_SW = 'Y' AND A.AE_SECTION NOT IN ('50000000', 'RUNCNTL')

# 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