IPR_REQUEST_SRV (SQL Table)	Index Back
IPR Request Service Table Integration Process Request - Request Service Operation Table - This table is a child table of the Intetegration Request Table (IPR_REQUEST_TBL). It stores the multiple service operations that are being processed for the request.

IPR_REQUEST_SRV

(SQL Table)

IPR Request Service Table

Integration Process Request - Request Service Operation Table - This table is a child table of the Intetegration Request Table (IPR_REQUEST_TBL). It stores the multiple service operations that are being processed for 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_SERVICE_STATUS Character(3) VARCHAR2(3) NOT NULL Integration Process Request Service Status
001=New
002=Processing
003=Cancelled
004=Done

6 STARTDATETIME DateTime(26) TIMESTAMP Start Datetime

7 ENDDATETIME DateTime(26) TIMESTAMP End Datetime

#	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_SERVICE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Integration Process Request Service Status 001=New 002=Processing 003=Cancelled 004=Done
6	STARTDATETIME	DateTime(26)	TIMESTAMP	Start Datetime
7	ENDDATETIME	DateTime(26)	TIMESTAMP	End Datetime