IPR_SRV_OPS_TBL(SQL Table) |
Index Back |
|---|---|
IPR Service Op Setup TableIntegration Process Request Service Operation Setup Table - This table stores process details for service operations that can be included in an Integration Process Request. For example, the sequence in which service operations need to be processed, the steps needed to process the service operation and the app class/method to initate and monitor the processing of the service operation. FP1:Added IB Group Name as a high level key and made this record as child record for IPR_RUN_SELCTIV which is used to enable selective run option for Integration Groups |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  IB_INTGROUPNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Integration Group Name (see PSIBGROUPDEFN).
Prompt Table: PSIBGROUPDEFN |
| 2 | IB_SERVICENAME |
Character(30) | VARCHAR2(30) NOT NULL |
Service (see PSSERVICE).
Prompt Table: PSSERVICE |
| 3 | IB_OPERATIONNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Service Operation (see PSOPERATION).
Prompt Table: PSOPERATION |
| 4 | IPR_SEQ |
Number(4,0) | SMALLINT NOT NULL | Integration Process Request Sequence number |
| 5 | IPR_STEP |
Number(2,0) | SMALLINT NOT NULL | Integration Process Request Step number |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | IPR_STEP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Integration Process Request Step Type
L=Local R=Remote |
| 8 | IPR_REMOTE_SYSTEM | Character(10) | VARCHAR2(10) NOT NULL |
Integration Process Request Remote System
Prompt Table: IPR_REM_SYS_TBL |
| 9 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
| 10 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 11 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
| 12 | METHODNAME | Character(32) | VARCHAR2(32) NOT NULL | Method Name |
| 13 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data |