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 | 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 |