BPW_LOG_INST(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BPW_PROC_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance Number |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | BPW_PROC_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined |
| 4 | BPW_PROC_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Process Weaver ID
Prompt Table: BPW_PROC_DEFN |
| 5 | BPW_PROC_RUN_CNTL |
Character(30) | VARCHAR2(30) NOT NULL | Process Run Control ID |
| 6 | BPW_THRD_RUN_CNTL |
Character(30) | VARCHAR2(30) NOT NULL | Thread Run Control ID |
| 7 | BPW_THRD_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Thread Instance Number |
| 8 | BPW_STEP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Step ID |
| 9 | BPW_STEP_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Step Instance Number |
| 10 | BPW_STRC_RUN_CNTL |
Character(30) | VARCHAR2(30) NOT NULL | Step Thread Run Control ID |
| 11 | BPW_STRC_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Step Thread Instance Number |
| 12 | MESSAGE_SEQ |
Number(9,0) | DECIMAL(9) NOT NULL | Message Sequence |
| 13 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 14 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 15 | MESSAGE_SEVERITY | Number(5,0) | INTEGER NOT NULL | Message Severity |
| 16 | BPW_LOG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Log Type
M=Message Log P=Process Log |
| 17 | BPW_DEFAULT_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Default Text |
| 18 | BPW_OBJECT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Object Type
0110=Process Instance 0120=Thread Instance 0130=Step Instance 0140=Step Thread Instance |
| 19 | BPW_UPDATED_DTTM | DateTime(26) | TIMESTAMP | Log Date/Time |
| 20 | BPW_APPSVRDT_STR | Character(15) | VARCHAR2(15) NOT NULL | App Server Date/Time |
| 21 | BPW_UPDATED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By User |
| 22 | BPW_OBJ_KEY_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Object Key |
| 23 | BPW_MSGPARM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Message Parm |