BPW_PROC_RUN(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 | SERVERNAME | Character(8) | VARCHAR2(8) NOT NULL |
Server Name
Prompt Table: BPW_SERVER_VW |
6 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: I |
8 | BPW_EVNT_HDLR_ID | Character(30) | VARCHAR2(30) NOT NULL |
Event Handler ID
Prompt Table: BPW_AC_EVNT_VW |
9 | BPW_EVNT_HDLR_PARM | Character(254) | VARCHAR2(254) NOT NULL | Event Handler Parameter |
10 | BPW_CREATED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By User |
11 | BPW_CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date/Time |
12 | BPW_UPDATED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By User |
13 | BPW_UPDATED_DTTM | DateTime(26) | TIMESTAMP | Updated Date/Time |