BPW_STRCINST_VW

(SQL View)
 Index Back

SELECT %subrec(BPW_STRCINST_SB, I) FROM PS_BPW_STPRC_INST I , PS_BPW_STEPINST_VW S WHERE %Join(COMMON_KEYS, BPW_STPRC_INST I, BPW_STEPINST_VW S) AND I.BPW_CURR_PROC_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BPW_PROC_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance Number
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 BPW_PROC_TYPE Character(4) VARCHAR2(4) NOT NULL Business Process Type
RTBL=Real Time Bottom Line
SYS=System
USER=User Defined
4 BPW_PROC_ID Character(30) VARCHAR2(30) NOT NULL Process Weaver ID

Prompt Table: BPW_PROC_DEFN

5 BPW_PROC_RUN_CNTL Character(30) VARCHAR2(30) NOT NULL Process Run Control ID
6 BPW_THRD_RUN_CNTL Character(30) VARCHAR2(30) NOT NULL Thread Run Control ID
7 BPW_THRD_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Thread Instance Number
8 BPW_STEP_ID Character(30) VARCHAR2(30) NOT NULL Step ID
9 BPW_STEP_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Step Instance Number
10 BPW_STRC_RUN_CNTL Character(30) VARCHAR2(30) NOT NULL Step Thread Run Control ID
11 BPW_STRC_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Step Thread Instance Number
12 BPW_RUNSTATUS Character(4) VARCHAR2(4) NOT NULL Run status for the step thread X - XX values are mapped to RUNSTATUS
0=Unknown
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
13 RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
14 DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting
9=Pending for Approval
15 BPW_LAST_PROC_FLG Character(1) VARCHAR2(1) NOT NULL Last Process
N=No
Y=Yes

Default Value: Y

16 BPW_BATCH_FLG Character(1) VARCHAR2(1) NOT NULL Batch Process Flag
17 BPW_CURR_PROC_FLG Character(1) VARCHAR2(1) NOT NULL Current Process
N=No
Y=Yes

Default Value: Y

18 BPW_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status for Business Process Weaver. - Any change should be reflected in BUSINESS_PROCESS_WEAVER:ENUM:ProcessStatus - "Summarized" status is by xlate value so make so to choose the proper value for new status.
10=Skipped
15=Cancelled
20=Complete
22=Compl/Warning
25=Complete/Error
30=Paused After
40=Not Started
50=Paused Before
60=Started
70=On Hold
90=Error

Default Value: 40

19 BPW_STATUS_DTTM DateTime(26) TIMESTAMP Status Date/Time
20 BPW_STARTED_OPRID Character(30) VARCHAR2(30) NOT NULL Started By User
21 BPW_STARTED_DTTM DateTime(26) TIMESTAMP Started Date/Time