PP_AE_ALGR_VW

(SQL View)
 Index Back

PP User Algorithms


SELECT A.AE_SECTION ,A.EFFDT ,A.EFF_STATUS , A.DESCR , A.MARKET , A.DBTYPE FROM PSAESECTDTLDEFN A WHERE AE_APPLID = 'AR_PREDICT2' AND AE_SECTION LIKE '#%' AND A.AE_SECTION NOT IN ( '#OLDEST3' , '#OLDEST2') AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSAESECTDTLDEFN B WHERE A.AE_APPLID = B.AE_APPLID AND A.AE_SECTION = B.AE_SECTION AND A.MARKET = B.MARKET AND A.DBTYPE = B.DBTYPE AND B.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ALGORITHM_GROUP Character(15) VARCHAR2(15) NOT NULL Algorithm Group for Payment Predictor
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 MARKET Character(3) VARCHAR2(3) NOT NULL Market
6 DBTYPE Character(1) VARCHAR2(1) NOT NULL Database Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400