PSWSSERVICE(SQL Table) |
Index Back |
|---|---|
WSDL Service |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(40) | VARCHAR2(40) NOT NULL | WSDL Name | |
| 2 | Character(40) | VARCHAR2(40) NOT NULL | Operation Id | |
| 3 | SERVICENAMEW | Character(60) | VARCHAR2(60) NOT NULL | Service Name |
| 4 | PORTNAME | Character(60) | VARCHAR2(60) NOT NULL | Port Name |
| 5 | PORTTYPENAME | Character(60) | VARCHAR2(60) NOT NULL | PortType Name |
| 6 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 7 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 8 | TRXTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Integration Broker Transaction Type
IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
| 9 | RQSTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| 10 | RQSTMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Request Message Version |
| 11 | RESPMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Response Message Name |
| 12 | CHNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Channel Name (see PSCHNLDEFN). |