WHEREUSEDPARTYPEOBJECTVALUE1OBJECTVALUE2OBJECTVALUE3OBJECTVALUE4WHEREUSEDCHILDTYPEWHEREUSEDCHILDSCC_INTFCHR_VW2(SQL View) |
Index Back |
|---|---|
Interface Report HR Data ViewInterface Report HR Data View |
| SELECT A.WHEREUSEDPARTYPE ,A.OBJECTVALUE1 ,A.OBJECTVALUE2 ,A.OBJECTVALUE3 ,A.OBJECTVALUE4 ,A.WHEREUSEDCHILDTYPE ,A.WHEREUSEDCHILD ,B.DESCR ,C.DESCR FROM %Table(SCC_INTFCRPT_HR) A , %Table(WHEREUSEDOBJTBL) B , %Table(WHEREUSEDOBJTBL) C WHERE B.WHEREUSEDOBJTYPE = A.WHEREUSEDPARTYPE AND C.WHEREUSEDOBJTYPE = A.WHEREUSEDCHILDTYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WHEREUSEDPARTYPE |
Signed Number(6,0) | DECIMAL(5) NOT NULL | Parent Type |
| 2 | OBJECTVALUE1 |
Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |
| 3 | OBJECTVALUE2 |
Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 |
| 4 | OBJECTVALUE3 |
Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 |
| 5 | OBJECTVALUE4 |
Character(30) | VARCHAR2(30) NOT NULL | Object Value 4 |
| 6 | WHEREUSEDCHILDTYPE |
Signed Number(6,0) | DECIMAL(5) NOT NULL | Child Type |
| 7 | WHEREUSEDCHILD |
Character(100) | VARCHAR2(100) NOT NULL | Child |
| 8 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 9 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |