DYN_INITSBP_AET

(SQL Table)
Index Back

DYN_INITSBP_AET

DYN_INITSBP_AET

# 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 ACTIVITY_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Activity Instance
4 RC_MAIN_BP_INSTNCE Number(18,0) DECIMAL(18) NOT NULL RC_MAIN_BP_INSTNCE
5 PARENT_BP_INSTNCE Number(18,0) DECIMAL(18) NOT NULL Parent BP Instance
6 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
7 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
8 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.
9 MAIN_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Main Activity Id
10 MAIN_ACTIVITY_INST Number(18,0) DECIMAL(18) NOT NULL Main Activity Instance
11 PARENT_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Parent Activity Id
12 PARENT_ACTVTY_INST Number(18,0) DECIMAL(18) NOT NULL Parent Activity Instance
13 RC_TASK_ID Character(15) VARCHAR2(15) NOT NULL Task ID used for Business Process tracking.
14 NESTED_BP_IND Character(1) VARCHAR2(1) NOT NULL Sub Business Project
N=No
Y=Yes
15 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
16 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
17 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
18 PROCESSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
19 PROCESSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
20 MARKET Character(3) VARCHAR2(3) NOT NULL Market