RY_PROC_CONTROL(SQL Table) |
Index Back |
|---|---|
Process Run ControlThe Record used to define the Process Run Control. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now |
| 4 | RY_INSTANCE_ID | Number(4,0) | SMALLINT NOT NULL | Runtime Mail Engine Instance ID |
| 5 | RY_INSTANCE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
DES=Dialog Execution Server ERP=E-mail Response Processor MAIL=Mail Service MCR=Broadcaster E-mail Server SMR=Single E-mailer Server WDG=Watch Dog |
| 6 | RY_COMMAND | Character(4) | VARCHAR2(4) NOT NULL |
Process Run Control Command for Online Marketing Service installation.
DEL=Remove an existing service INST=Install a new server RUN=Run an esixting service STOP=Stop a running service |
| 7 | RY_INSTALL_OPTIONS | Character(4) | VARCHAR2(4) NOT NULL |
Process Run Control Install Options.
B=Bulk Mailer BNCE=Bounce Processor REPL=Reply Processor S=Single Mailer |