RPT_DLVRY_VW

(SQL View)
 Index Back

Report Delivery View


SELECT A.REPORT_INSTANCE ,A.RPT_DELIVERY_STAT FROM PS_RPT_RQST A ,PSPRCSRQST B WHERE A.PROCESS_INSTANCE = b.PRCSINSTANCE AND B.RUNSTATUS = '9'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_INSTANCE Character(8) VARCHAR2(8) NOT NULL Report Instance
2 RPT_DELIVERY_STAT Character(1) VARCHAR2(1) NOT NULL Report Delivery Status
D=Delivered
P=Pending Delivery