INTFC_BI_N2_VW

(SQL View)
 Index Back

Billing Interface - Not Loaded

Lists distinct INTFC_ID's in a Not Loaded status.

SELECT DISTINCT A.INTFC_ID FROM PS_INTFC_BI A WHERE A.LOAD_STATUS_BI <> 'DON' AND NOT EXISTS ( SELECT 'X' FROM PS_INTFC_BI_PROC B WHERE A.INTFC_ID = B.INTFC_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID