RBB_INST_HDR (SQL Table)	Index Back
BPEL Instances table Table to store the BPEL Instance Details.

RBB_INST_HDR

(SQL Table)

BPEL Instances table

Table to store the BPEL Instance Details.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RBB_BPEL_INST_ID Character(100) VARCHAR2(100) NOT NULL Business Process Instance ID

2 RBB_SERV_OPR_ID Character(100) VARCHAR2(100) NOT NULL Service Operation ID

3 RBB_TRNSTYPE_ID Character(25) VARCHAR2(25) NOT NULL Field to store Transaction Type ID

4 MARKET Character(3) VARCHAR2(3) NOT NULL Market

5 RBB_SUBMIT_DTTM DateTime(26) TIMESTAMP Business Process Submit Date and Time

6 RBB_START_DTTM DateTime(26) TIMESTAMP Business Process Start Date and Time

7 RBB_END_DTTM DateTime(26) TIMESTAMP Business Process End Date and Time

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

9 RBB_INIT_SRC Character(10) VARCHAR2(10) NOT NULL Source from where Business Process is initiated
EXT=External
INT=Internal

10 RBB_PURPOSE Character(254) VARCHAR2(254) NOT NULL Purpose (Use) of the BPEL Process initiated by a transaction

11 RBB_STATUS Character(1) VARCHAR2(1) NOT NULL Current Status of the BPEL Instance in Peoplesoft System
C=Completed
F=Failed
P=In Progress
Q=Queued
X=Cancelled

12 RBB_RESUBMT_ATMPTS Number(2,0) SMALLINT NOT NULL Number of times a BPEL Process has been resubmitted by the user manually, when BPEL fails to get initiated on BPEL Server.

13 RBB_CANCELLED_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate that a BPEL Process has been cancelled by Administrator to avoid resubmissions

14 RBB_NODE_NAME Character(40) VARCHAR2(40) NOT NULL This field stores BPEL Node name as defined in tools domian.

15 EOCF_ACTION_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework Action ID field

16 RBB_INST_URL Long Character CLOB URL of BPEL Instance

17 RBB_ROWADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

18 RBB_ROWADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

19 RBB_ROWUPD_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

20 RBB_ROWUPD_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RBB_BPEL_INST_ID	Character(100)	VARCHAR2(100) NOT NULL	Business Process Instance ID
2	RBB_SERV_OPR_ID	Character(100)	VARCHAR2(100) NOT NULL	Service Operation ID
3	RBB_TRNSTYPE_ID	Character(25)	VARCHAR2(25) NOT NULL	Field to store Transaction Type ID
4	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
5	RBB_SUBMIT_DTTM	DateTime(26)	TIMESTAMP	Business Process Submit Date and Time
6	RBB_START_DTTM	DateTime(26)	TIMESTAMP	Business Process Start Date and Time
7	RBB_END_DTTM	DateTime(26)	TIMESTAMP	Business Process End Date and Time
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	RBB_INIT_SRC	Character(10)	VARCHAR2(10) NOT NULL	Source from where Business Process is initiated EXT=External INT=Internal
10	RBB_PURPOSE	Character(254)	VARCHAR2(254) NOT NULL	Purpose (Use) of the BPEL Process initiated by a transaction
11	RBB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Current Status of the BPEL Instance in Peoplesoft System C=Completed F=Failed P=In Progress Q=Queued X=Cancelled
12	RBB_RESUBMT_ATMPTS	Number(2,0)	SMALLINT NOT NULL	Number of times a BPEL Process has been resubmitted by the user manually, when BPEL fails to get initiated on BPEL Server.
13	RBB_CANCELLED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate that a BPEL Process has been cancelled by Administrator to avoid resubmissions
14	RBB_NODE_NAME	Character(40)	VARCHAR2(40) NOT NULL	This field stores BPEL Node name as defined in tools domian.
15	EOCF_ACTION_ID	Number(31,0)	DECIMAL(31) NOT NULL	Active Analytics Framework Action ID field
16	RBB_INST_URL	Long Character	CLOB	URL of BPEL Instance
17	RBB_ROWADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
18	RBB_ROWADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
19	RBB_ROWUPD_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
20	RBB_ROWUPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
21	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
22	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time