PSRTNGDFNPARM(SQL Table) |
Index Back |
|---|---|
IB Routing Definitions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ROUTINGDEFNNAME |
Character(30) | VARCHAR2(30) NOT NULL | Routing Name |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | PARAMETERNAME |
Character(15) | VARCHAR2(15) NOT NULL | Parameter Name |
| 4 | SENDERNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Sender Node Name |
| 5 | RECEIVERNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Receiver Node Name |
| 6 | XFRMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Transform Program 1
Prompt Table: PSRELTRNSFRMVW |
| 7 | XFRMNAME_SECOND | Character(30) | VARCHAR2(30) NOT NULL |
Transform Program 2
Prompt Table: PSRELTRNSFRMVW |
| 8 | INMSGNAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition.
Prompt Table: PSMSGDEFN |
| 9 | INMSGVERSION | Character(30) | VARCHAR2(30) NOT NULL |
In Message Version
Prompt Table: PSMSGDEFN_VW4 |
| 10 | OUTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition.
Prompt Table: PSMSGDEFN |
| 11 | OUTMSGVERSION | Character(30) | VARCHAR2(30) NOT NULL |
Out Message Version
Prompt Table: PSMSGDEFN_VW5 |
| 12 | ALIASNAME | Character(254) | VARCHAR2(254) NOT NULL | External Alias |
| 13 | VERSIONNAME | Character(30) | VARCHAR2(30) NOT NULL |
Service Operation Version
Prompt Table: PSSRVVERDFN2_VW |
| 14 | IB_SECURITYOVRD | Number(1,0) | SMALLINT NOT NULL | Security Override |
| 15 | IBEXTERNALUSERID | Character(30) | VARCHAR2(30) NOT NULL | External User ID |
| 16 | IBEXTERNALPWD | Character(254) | VARCHAR2(254) NOT NULL | Integration Broker External Password |
| 17 | TOKENTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Authentication Token Type
NONE=None STSD=SAML Token USRT=Username Token UTNP=Username Token, no password Default Value: NONE |
| 18 | TOKEN_ENCRYPTED | Number(1,0) | SMALLINT NOT NULL | Encrypted |
| 19 | IB_ENCRYPTLEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Encrypt Level
A=All B=Body H=Header Default Value: H |
| 20 | TOKEN_SIGNED | Number(1,0) | SMALLINT NOT NULL | Digitally Signed |
| 21 | PTIBREQALIASNM | Character(30) | VARCHAR2(30) NOT NULL | Optional Request Alias |