BPW_RUNCNTL_OWNERBPW_PROC_TYPERTBL=Real Time Bottom Line
SYS=System
USER=User Defined
BPW_PROC_IDBPW_PROC_RUN_CNTLR=ROLE
U=USER
BPW_PRCRN_SCVW1(SQL View) |
Index Back |
|---|
| SELECT A.OPRID AS BPW_RUNCNTL_OWNER ,A.BPW_PROC_TYPE , A.BPW_PROC_ID , A.BPW_PROC_RUN_CNTL , B.Security_Type2 , B.BPW_ROLEUSER_VALUE , B.BPW_STEP_ID , B.BPW_ACTIVE_FLAG FROM Ps_Bpw_Proc_RUN A LEFT JOIN PS_BPW_PRUN_STPSEC B ON A.BPW_PROC_TYPE = B.BPW_PROC_TYPE AND A.BPW_PROC_ID = B.BPW_PROC_ID AND A.BPW_PROC_RUN_CNTL = B.BPW_PROC_RUN_CNTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BPW_RUNCNTL_OWNER |
Character(30) | VARCHAR2(30) NOT NULL | Process Run Control Owner |
| 2 | BPW_PROC_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined |
| 3 | BPW_PROC_ID |
Character(30) | VARCHAR2(30) NOT NULL | Process Weaver ID |
| 4 | BPW_PROC_RUN_CNTL |
Character(30) | VARCHAR2(30) NOT NULL | Process Run Control ID |
| 5 | SECURITY_TYPE2 | Character(1) | VARCHAR2(1) NOT NULL |
Type of Security
R=ROLE U=USER |
| 6 | BPW_ROLEUSER_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Value |
| 7 | BPW_STEP_ID | Character(30) | VARCHAR2(30) NOT NULL | Step ID |
| 8 | BPW_ACTIVE_FLAG | Number(1,0) | SMALLINT NOT NULL | Active |