IPR_REQUEST_IDDefault Value: NEW
IB_SERVICENAMEIB_OPERATIONNAMEIPR_SEQIPR_STEPIB_INTGROUPNAME001=New
002=Processing
003=Cancelled
004=Done
IPR_REQUEST_DTL(SQL Table) |
Index Back |
|---|---|
IPR Request Detail TableIntegration Process Request - Request Detail Table - This is a child table to the Request Service table (IPR_REQUEST_SRV) that stores detail step information for each service operation in the request. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IPR_REQUEST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Integration Process Request - Request ID
Default Value: NEW |
| 2 | IB_SERVICENAME |
Character(30) | VARCHAR2(30) NOT NULL | Service (see PSSERVICE). |
| 3 | IB_OPERATIONNAME |
Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see 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 | IB_INTGROUPNAME |
Character(30) | VARCHAR2(30) NOT NULL | Integration Group Name (see PSIBGROUPDEFN). |
| 7 | IPR_REMOTE_NODE | Character(30) | VARCHAR2(30) NOT NULL | Integration Process Request Remote Node |
| 8 | IPR_TRANS_ID | Character(36) | VARCHAR2(36) NOT NULL | Integraton Process Request Transaction ID |
| 9 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 10 | IPR_STEP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Integration Process Request Step Status
001=New 002=Processing 003=Cancelled 004=Done |
| 11 | STARTDATETIME | DateTime(26) | TIMESTAMP | Start Datetime |
| 12 | ENDDATETIME | DateTime(26) | TIMESTAMP | End Datetime |
| 13 | IPR_MSG_LOG_DTL | Long Character | CLOB | Integration Process Request Message Log Push Button |