IPR_PRC_AET(SQL Table) |
Index Back |
---|---|
IPR Process Request State RcdIntegration 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 |