SCC_INTFCHR_VW

(SQL View)
 Index Back

Interface Report HR Data

Interface Report HR Data Table

SELECT DISTINCT A.WHEREUSEDPARTYPE , X1.DESCR ,A.OBJECTVALUE1 ,A.OBJECTVALUE2 ,A.OBJECTVALUE3 ,A.OBJECTVALUE4 FROM %Table(SCC_INTFCRPT_HR) A , %Table(WHEREUSEDOBJTBL) X1 WHERE X1.WHEREUSEDOBJTYPE = A.WHEREUSEDPARTYPE UNION SELECT DISTINCT A2.WHEREUSEDPARTYPE , ' ' ,A2.OBJECTVALUE1 ,A2.OBJECTVALUE2 ,A2.OBJECTVALUE3 ,A2.OBJECTVALUE4 FROM %Table(SCC_INTFCRPT_HR) A2 WHERE NOT EXISTS ( SELECT 'X' FROM %Table(WHEREUSEDOBJTBL) X2 WHERE X2.WHEREUSEDOBJTYPE = A2.WHEREUSEDPARTYPE ) UNION SELECT B.WHEREUSEDPARTYPE ,X3.DESCR ,B.OBJECTVALUE1 ,B.OBJECTVALUE2 ,B.OBJECTVALUE3 ,B.OBJECTVALUE4 FROM %Table(SCC_INTFCHRASGN) B , %Table(WHEREUSEDOBJTBL) X3 WHERE X3.WHEREUSEDOBJTYPE = B.WHEREUSEDPARTYPE AND NOT EXISTS ( SELECT 'X' FROM %Table(SCC_INTFCRPT_HR) C WHERE C.WHEREUSEDPARTYPE = B.WHEREUSEDPARTYPE AND C.OBJECTVALUE1 = B.OBJECTVALUE1 AND C.OBJECTVALUE2 = B.OBJECTVALUE2 AND C.OBJECTVALUE3 = B.OBJECTVALUE3 AND C.OBJECTVALUE4 = B.OBJECTVALUE4 ) UNION SELECT B2.WHEREUSEDPARTYPE , ' ' ,B2.OBJECTVALUE1 ,B2.OBJECTVALUE2 ,B2.OBJECTVALUE3 ,B2.OBJECTVALUE4 FROM %Table(SCC_INTFCHRASGN) B2 WHERE NOT EXISTS ( SELECT 'X' FROM %Table(WHEREUSEDOBJTBL) X4 WHERE X4.WHEREUSEDOBJTYPE = B2.WHEREUSEDPARTYPE ) AND NOT EXISTS ( SELECT 'X' FROM %Table(SCC_INTFCRPT_HR) C2 WHERE C2.WHEREUSEDPARTYPE = B2.WHEREUSEDPARTYPE AND C2.OBJECTVALUE1 = B2.OBJECTVALUE1 AND C2.OBJECTVALUE2 = B2.OBJECTVALUE2 AND C2.OBJECTVALUE3 = B2.OBJECTVALUE3 AND C2.OBJECTVALUE4 = B2.OBJECTVALUE4 )

# 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 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
3 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
4 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
5 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
6 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4