BPW_PRC_RUN_SEC(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BPW_PROC_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined Prompt Table: BPW_PRCTYPE_VW |
| 3 | BPW_PROC_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Process Weaver ID
Prompt Table: BPW_PRCOWNR_VW |
| 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 Default Value: U |
| 6 | BPW_ROLEUSER_VALUE |
Character(30) | VARCHAR2(30) NOT NULL |
Value
Prompt Table: %EDITTABLE40 |
| 7 | ALLSTEPS | Character(1) | VARCHAR2(1) NOT NULL |
All Steps
Y/N Table Edit Default Value: N |
| 8 | BPW_ACTIVE_FLAG | Number(1,0) | SMALLINT NOT NULL |
Active
1/0 Table Edit (1=True, 0=False) Default Value: 1 |