PSIBRTNGDEFN_VW(SQL View) |
Index Back |
---|---|
IB Routings |
SELECT IB_OPERATIONNAME , VERSIONNAME , SENDERNODENAME , RECEIVERNODENAME , RTNGTYPE , ROUTINGDEFNNAME , EFFDT , EFF_STATUS FROM PSIBRTNGDEFN |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | IB_OPERATIONNAME | Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see PSOPERATION). |
2 | VERSIONNAME | Character(30) | VARCHAR2(30) NOT NULL | Service Operation Version |
3 | SENDERNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Sender Node Name |
4 | RECEIVERNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Receiver Node Name |
5 | RTNGTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Routing Type
A=Asynchronous - One Way N=Synchronous Non-Blocking R=Asynch Request/Response S=Synchronous X=Asynch to Synch |
6 | ROUTINGDEFNNAME | Character(30) | VARCHAR2(30) NOT NULL | Routing Name |
7 | EFFDT | Date(10) | DATE | Effective Date |
8 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |