BPW_STPLCK_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_LOCK_GUID | Character(36) | VARCHAR2(36) NOT NULL | Lock GUID |
11 | BPW_CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date/Time |