RC_BP_RUN_CNTL

(SQL Table)
 Index Back

Business Process Run Control

This run control stores the information about a Business Process event. Then this information can be acted upon by a process. For example, if a buisiness process completes, but notifications should go out in 2 hours, the information about the business process is written to a run control record. Then in 2 hours, the information will be selected by a process and acted upon accordingly.

# 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 RULE_NAME Character(30) VARCHAR2(30) NOT NULL This field is a text field of 30 character long.
4 SCHED_PRCS_NBR Number(15,0) DECIMAL(15) NOT NULL Schedule Process Number..............................................

Default Value: 1999999999

5 BP_NOTIFY_TYPE Character(2) VARCHAR2(2) NOT NULL business projects notification type code
01=Phs - All Complete
02=Phs - All Complete/Any Fail
03=Phs - All Complete/All Success
04=Transition - Any
05=Transition - Non-Default
06=Phs - Exceeds Stan Time
07=Phs - Exceeds Max Time
08=Phs - Exceeds Stan Calc Time
09=Phs - Exceeds Max Calc Time
10=Task - Exceeds Max Time
11=Task - Exceeds Stan Time
12=BP - Exceeds Stan Time
13=BP - Exceeds Max Time
14=BP - Exceeds Stan Calc Time
15=BP - Exceeds Max Calc Time
16=Phs - Begins
17=Phs - Completes
18=BP - Begins
19=BP - Completes
6 TASK_NOTIFY_TYPE Character(2) VARCHAR2(2) NOT NULL type of task in business projects application
01=Beginning of Task
02=Completion of Task
03=Failure of Task
04=Maximum Time Exceeded
05=Standard Time Exceeded
06=Success of Task
07=Reassignment of Task
7 BP_STATUS_URL Long Character CLOB Business Project Status URL. This field is used to store the URL to get in to a specific Business Project Instance.
8 TSK_STATUS_URL Character(254) VARCHAR2(254) NOT NULL Task Status URL
9 DELAY_MINUTES Number(10,0) DECIMAL(10) NOT NULL Delay Minutes.....................................
10 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.
11 ACTIVITY_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Activity Instance
12 RC_MAIN_BP_INSTNCE Number(18,0) DECIMAL(18) NOT NULL RC_MAIN_BP_INSTNCE
13 PARENT_BP_INSTNCE Number(18,0) DECIMAL(18) NOT NULL Parent BP Instance
14 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
15 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
16 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.
17 MAIN_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Main Activity Id
18 MAIN_ACTIVITY_INST Number(18,0) DECIMAL(18) NOT NULL Main Activity Instance
19 PARENT_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Parent Activity Id
20 PARENT_ACTVTY_INST Number(18,0) DECIMAL(18) NOT NULL Parent Activity Instance
21 RC_TASK_ID Character(15) VARCHAR2(15) NOT NULL Task ID used for Business Process tracking.
22 NESTED_BP_IND Character(1) VARCHAR2(1) NOT NULL Sub Business Project
N=No
Y=Yes
23 RC_TASK_STATUS Character(1) VARCHAR2(1) NOT NULL Task Status used in Business Process tracking.
C=Complete
L=Cancelled
N=Not Started
P=In Process
24 RC_OUTCOME Character(1) VARCHAR2(1) NOT NULL Outcome of a Task for Business Process tracking. See translates for possible values.
F=Failure
S=Success
25 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
26 PROCESSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
27 PROCESSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
28 MARKET Character(3) VARCHAR2(3) NOT NULL Market