BPW_PROC_TYPERTBL=Real Time Bottom Line
SYS=System
USER=User Defined
BPW_PROC_IDR=ROLE
U=USER
BPW_PRCOWNR_VW1(SQL View) |
Index Back |
|---|
| SELECT A.BPW_PROC_TYPE , A.BPW_PROC_ID , A.BPW_CREATED_OPRID , A.BPW_PUBLIC_FLG , B.Security_Type2 , B.BPW_ROLEUSER_VALUE , B.BPW_STEP_ID , B.BPW_ACTIVE_FLAG FROM Ps_Bpw_Proc_Defn A LEFT JOIN PS_BPW_PRCSTEP_SEC B ON A.BPW_PROC_TYPE = B.BPW_PROC_TYPE AND A.BPW_PROC_ID = B.BPW_PROC_ID WHERE A.Eff_Status = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BPW_PROC_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined |
| 2 | BPW_PROC_ID |
Character(30) | VARCHAR2(30) NOT NULL | Process Weaver ID |
| 3 | BPW_CREATED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By User |
| 4 | BPW_PUBLIC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Public |
| 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 |