PROCESS_INSTANCE1=Run All BPs
2=Run Selected BPs
1=Run Online
2=Run in Batch Mode
OCD_HOLD_AET(SQL Table) |
Index Back |
|---|---|
State Table for CalculationState Table for the Calculations of Hold Times |
| # | 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 | UUID_RAW | Character(36) | VARCHAR2(36) NOT NULL | Universal Unique Identifier - can be used as an identifier when processing a batch of data. |
| 5 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 6 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 7 | RUN_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Options for Running the Business Projects timing calculation program
1=Run All BPs 2=Run Selected BPs |
| 8 | RUN_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Selection criteria for running the Application Engine process
1=Run Online 2=Run in Batch Mode |