SCC_INTFCHRSRCH

(SQL View)
 Index Back

Interface Report HR Data

Interface Report HR Data Table

SELECT DISTINCT A.WHEREUSEDPARTYPE ,B.DESCR FROM %Table(SCC_INTFCRPT_HR) A , %Table(WHEREUSEDOBJTBL) B WHERE B.WHEREUSEDOBJTYPE = A.WHEREUSEDPARTYPE UNION SELECT DISTINCT C.WHEREUSEDPARTYPE ,' ' FROM %Table(SCC_INTFCRPT_HR) C WHERE NOT EXISTS ( SELECT 'X' FROM %Table(WHEREUSEDOBJTBL) D WHERE D.WHEREUSEDOBJTYPE = C.WHEREUSEDPARTYPE ) UNION SELECT DISTINCT E.WHEREUSEDPARTYPE , F.DESCR FROM %Table(SCC_INTFCHRASGN) E , %Table(WHEREUSEDOBJTBL) F WHERE F.WHEREUSEDOBJTYPE = E.WHEREUSEDPARTYPE AND NOT EXISTS ( SELECT 'X' FROM %Table(SCC_INTFCRPT_HR) G WHERE G.WHEREUSEDPARTYPE = E.WHEREUSEDPARTYPE ) UNION SELECT DISTINCT H.WHEREUSEDPARTYPE , ' ' FROM %Table(SCC_INTFCHRASGN) H WHERE NOT EXISTS ( SELECT 'X' FROM %Table(WHEREUSEDOBJTBL) I WHERE I.WHEREUSEDOBJTYPE = H.WHEREUSEDPARTYPE ) AND NOT EXISTS ( SELECT 'X' FROM %Table(SCC_INTFCRPT_HR) J WHERE J.WHEREUSEDPARTYPE = H.WHEREUSEDPARTYPE )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WHEREUSEDPARTYPE Signed Number(6,0) DECIMAL(5) NOT NULL Parent Type

Prompt Table: WHEREUSEDOBJTBL

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description