IPR_PRC_AET

(SQL Table)
Index Back

IPR Process Request State Rcd

Integration Process Request - Process Request State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 IPR_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL Integration Process Request - Request ID
5 IPR_RQST_STATUS Character(3) VARCHAR2(3) NOT NULL Integration Process Request - Request Status
001=New
002=Processing
003=Cancelled
004=Done
6 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
7 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
8 IPR_SEQ Number(4,0) SMALLINT NOT NULL Integration Process Request Sequence number
9 IPR_SERVICE_STATUS Character(3) VARCHAR2(3) NOT NULL Integration Process Request Service Status
001=New
002=Processing
003=Cancelled
004=Done
10 IPR_STEP Number(2,0) SMALLINT NOT NULL Integration Process Request Step number
11 IPR_STEP_STATUS Character(3) VARCHAR2(3) NOT NULL Integration Process Request Step Status
001=New
002=Processing
003=Cancelled
004=Done
12 IPR_STEP_TYPE Character(1) VARCHAR2(1) NOT NULL Integration Process Request Step Type
L=Local
R=Remote
13 IPR_REMOTE_SYSTEM Character(10) VARCHAR2(10) NOT NULL Integration Process Request Remote System
14 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
15 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
16 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
17 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
18 IPR_REMOTE_NODE Character(30) VARCHAR2(30) NOT NULL Integration Process Request Remote Node
19 IPR_TRANS_ID Character(36) VARCHAR2(36) NOT NULL Integraton Process Request Transaction ID
20 IPR_PRCS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Integration Process Request Process Instance number