BPW_PRCDEFN_SEC(SQL Table) |
Index Back |
|---|---|
process definition security |
| # | 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 | SECURITY_TYPE2 |
Character(1) | VARCHAR2(1) NOT NULL |
Type of Security
R=ROLE U=USER Default Value: U |
| 4 | BPW_ROLEUSER_VALUE |
Character(30) | VARCHAR2(30) NOT NULL |
Value
Prompt Table: %EDITTABLE40 |
| 5 | ALLSTEPS | Character(1) | VARCHAR2(1) NOT NULL |
All Steps
Y/N Table Edit Default Value: N |
| 6 | BPW_ACTIVE_FLAG | Number(1,0) | SMALLINT NOT NULL |
Active
1/0 Table Edit (1=True, 0=False) Default Value: 1 |