EB_ST_PUSH_VW

(SQL View)
 Index Back

Statement Push Notification


SELECT A.CRSPD_SETID , A.CRSPD_CUST_ID , A.ST_ID_NUM ,A.ST_DT , B.NAME1 , B.OPRID FROM PS_EB_STMT_CUST A , PS_EB_CNT_CUST_VW B ,PS_EB_INV_DISP_OPT C WHERE( A.CRSPD_SETID = B.SETID AND A.CRSPD_CUST_ID = B.CUST_ID AND C.OPRID = B.OPRID AND C.NEW_STATEMENT_FLG = 'Y' AND C.EB_NOTIFY_METHOD = 'P' ) UNION SELECT DISTINCT A.CRSPD_SETID , A.CRSPD_CUST_ID , A.ST_ID_NUM ,A.ST_DT , B.NAME1 , B.OPRID FROM PS_EB_STMT_CUST A , PS_EB_CNT_CUST_VW B WHERE( A.CRSPD_SETID = B.SETID AND A.CRSPD_CUST_ID = B.CUST_ID AND B.OPRID NOT IN ( SELECT C.OPRID FROM PS_EB_INV_DISP_OPT C WHERE C.EB_NOTIFY_METHOD IN ('E','P')) AND EXISTS ( SELECT 'X' FROM PS_INSTALLATION_EB D WHERE D.DFLT_DLVRY_FLG = 'P' ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer
3 ST_ID_NUM Number(8,0) INTEGER NOT NULL Statement Number
4 ST_DT Date(10) DATE Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.
5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).