HRS_VNDR_TRANS(SQL Table) |
Index Back |
|---|---|
Vendor-Transaction TableVendor - Transaction Association Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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_VERSION | Number(15,0) | DECIMAL(15) NOT NULL | used as version for numerous integration objects |
| 4 | HRS_TRANSACTION_ID | Character(30) | VARCHAR2(30) NOT NULL | Transaction ID |
| 5 | 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 |
| 6 | 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 |
| 7 | HRS_XSLT_ASYNC_ID | Number(15,0) | DECIMAL(15) NOT NULL | XSLT ID |
| 8 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 9 | 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 |