HRS_VNDR_TRANS_ID10=Log Everything
20=Log XML on Error
30=Never Log XML
HRS_VTRANS_VW(SQL View) |
Index Back |
|---|---|
Vendor-Transaction TableVendor - Transaction Association Table |
| SELECT A.HRS_VNDR_TRANS_ID , A.HRS_VENDOR_ID , A.HRS_TRANSACTION_ID , A.HRS_XSLT_REQ_ID , A.HRS_XSLT_RES_ID , A.HRS_XSLT_ASYNC_ID , A.MSGNODENAME , A.HRS_LOG_STYLE FROM PS_HRS_VNDR_TRANS A , PS_HRS_TG_SERVICE B , PS_HRS_VENDOR C WHERE C.HRS_VERSION = ( SELECT MAX(HRS_VERSION) FROM PS_HRS_VENDOR Z WHERE C.HRS_VENDOR_ID = Z.HRS_VENDOR_ID) AND A.HRS_VENDOR_ID=C.HRS_VENDOR_ID AND A.HRS_VERSION=C.HRS_VERSION AND A.HRS_TRANSACTION_ID=B.HRS_TRANSACTION_ID AND B.HRS_TG_ID=C.HRS_TG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_VNDR_TRANS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Id specific to a Vendor and Transaction |
| 2 | HRS_VENDOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Integration Vendor ID |
| 3 | HRS_TRANSACTION_ID | Character(30) | VARCHAR2(30) NOT NULL | Transaction ID |
| 4 | HRS_XSLT_REQ_ID | Number(15,0) | DECIMAL(15) NOT NULL | A reference to an XSLT ID used to transform a request for a transaction |
| 5 | HRS_XSLT_RES_ID | Number(15,0) | DECIMAL(15) NOT NULL | A reference to an XSLT ID used to transform a response for a transaction |
| 6 | HRS_XSLT_ASYNC_ID | Number(15,0) | DECIMAL(15) NOT NULL | XSLT ID |
| 7 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 8 | HRS_LOG_STYLE | Character(3) | VARCHAR2(3) NOT NULL |
The logging style for integrations
10=Log Everything 20=Log XML on Error 30=Never Log XML |