PROCESS_INSTANCEDP_IPMAST_AET(SQL Table) |
Index Back |
|---|---|
External IP Master Updates |
| # | 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 | DP_POLICYSET | Character(10) | VARCHAR2(10) NOT NULL | DP_POLICYSET |
| 5 | DP_ITEMCODE | Character(18) | VARCHAR2(18) NOT NULL | DP_ITEMCODE |
| 6 | DP_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | DP_LOCATION |
| 7 | DP_UPDATESTATUS | Signed Number(2,0) | DECIMAL(1) NOT NULL | 0 = Not processed 1 = Processed 2 = Partially Processed -1 = Errored |
| 8 | DP_ERRORMESSAGE | Character(254) | VARCHAR2(254) NOT NULL | DP_ERRORMESSAGE |