BI_EXTR_JOB_VW

(SQL View)
 Index Back

SELECT DISTINCT A.JOBINSTANCE , A.INVOICE FROM PS_BI_EXTRCT A , PSPRCSRQST B WHERE A.JOBINSTANCE = B.JOBINSTANCE AND A.JOBINSTANCE <> 0 AND B.RUNSTATUS IN ('2', '3', '8', '10')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice