IMP_PROGRAMS_VW

(SQL View)
 Index Back

CDH IMP_PROGRAMS_AE FULLSYNC

IMP_PROGRAMS_AE FULLSYNC - FULLSYNC PUBLISH CDM DATA TO CDH

SELECT AE_APPLID , DESCR FROM PSAEAPPLDEFN WHERE AE_APPLID IN ('RB_PUB_CONS','RB_PUB_CNTCT','RB_PUB_COMP', 'RB_PUB_EXT', 'RB_PUB_PRTNR', 'RB_PUB_PURGE', 'RB_PUB_SITE') AND AE_APPLLIBRARY <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description