RO_BP_CALC_AET (SQL Table)	Index Back
State Table for Calculation State Table for the Calculations of Business Project Time Lines

RO_BP_CALC_AET

(SQL Table)

State Table for Calculation

State Table for the Calculations of Business Project Time Lines

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.

3 RC_TASK_ID Character(15) VARCHAR2(15) NOT NULL Task ID used for Business Process tracking.

4 RC_TSK_PROC_INST Number(18,0) DECIMAL(18) NOT NULL RC_TSK_PROC_INST

5 EFFDT Date(10) DATE Effective Date
Default Value: %date

6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

8 UUID_RAW Character(36) VARCHAR2(36) NOT NULL Universal Unique Identifier - can be used as an identifier when processing a batch of data.

9 START_DATE Date(10) DATE Start Date for Gen Standing PO

10 END_DATE Date(10) DATE End date field to store an end date.

11 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

12 RUN_SELECTION Character(1) VARCHAR2(1) NOT NULL Selection criteria for running the Application Engine process
1=Run Online
2=Run in Batch Mode

13 RC_BUS_PROCESS_ID2 Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.

14 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.

15 ACTIVITY_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Activity Instance

16 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.

17 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

18 AVG_TIME_TASK_SEC Number(10,0) DECIMAL(10) NOT NULL Average Time for Performing the Task under a Business Project in Minutes

19 MAN_OVERRIDE_SEC Number(10,0) DECIMAL(10) NOT NULL Manual Override Time in Minutes used in Order Capture Dashboard

20 USE_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Selection Flag used for Order Capture Dashboard

21 AVG_TIME_F_BP_SEC Number(10,0) DECIMAL(10) NOT NULL Field to Capture the Average Time for Finishing the Business Project

22 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

23 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
3	RC_TASK_ID	Character(15)	VARCHAR2(15) NOT NULL	Task ID used for Business Process tracking.
4	RC_TSK_PROC_INST	Number(18,0)	DECIMAL(18) NOT NULL	RC_TSK_PROC_INST
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	UUID_RAW	Character(36)	VARCHAR2(36) NOT NULL	Universal Unique Identifier - can be used as an identifier when processing a batch of data.
9	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
10	END_DATE	Date(10)	DATE	End date field to store an end date.
11	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
12	RUN_SELECTION	Character(1)	VARCHAR2(1) NOT NULL	Selection criteria for running the Application Engine process 1=Run Online 2=Run in Batch Mode
13	RC_BUS_PROCESS_ID2	Character(15)	VARCHAR2(15) NOT NULL	Business Process ID used in Business Process tracking.
14	RC_BUS_PROCESS_ID	Character(15)	VARCHAR2(15) NOT NULL	Business Process ID used in Business Process tracking.
15	ACTIVITY_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Activity Instance
16	RC_ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID used in Business Process tracking.
17	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
18	AVG_TIME_TASK_SEC	Number(10,0)	DECIMAL(10) NOT NULL	Average Time for Performing the Task under a Business Project in Minutes
19	MAN_OVERRIDE_SEC	Number(10,0)	DECIMAL(10) NOT NULL	Manual Override Time in Minutes used in Order Capture Dashboard
20	USE_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Selection Flag used for Order Capture Dashboard
21	AVG_TIME_F_BP_SEC	Number(10,0)	DECIMAL(10) NOT NULL	Field to Capture the Average Time for Finishing the Business Project
22	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
23	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section