PROCESS_INSTANCEBAT_PROCESS_TYPEA=Application Engine
C=COBOL
BAT_PROGRAM_NAMEBAT_DTL_TYPEDETAIL_IDY/N Table Edit
Y/N Table Edit
Y/N Table Edit
BAT_TIMINGS_DTL |
index back |
|---|
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| BAT_PROCESS_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Process type (cobol, AE, etc)
A=Application Engine C=COBOL |
| BAT_PROGRAM_NAME |
Character(12) | VARCHAR2(12) NOT NULL | Program or module name |
| BAT_DTL_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Detail type (SQL, Peoplecode) |
| DETAIL_ID |
Character(100) | VARCHAR2(100) NOT NULL | Detail line identifer |
| COMPILE_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Count |
| COMPILE_TIME | Number(15,0) | DECIMAL(15) NOT NULL | Time (in millseconds) |
| EXECUTE_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Count |
| EXECUTE_TIME | Number(15,0) | DECIMAL(15) NOT NULL | Time (in millseconds) |
| FETCH_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | SQL Fetch Count |
| FETCH_TIME | Number(15,0) | DECIMAL(15) NOT NULL | SQL Fetch Time |
| RETRIEVE_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Count |
| RETRIEVE_TIME | Number(15,0) | DECIMAL(15) NOT NULL | Time (in millseconds) |
| BULK_INSERT | Character(1) | VARCHAR2(1) NOT NULL |
Bulk Insert Flag
Y/N Table Edit |
| PEOPLECODECOUNT | Number(10,0) | DECIMAL(10) NOT NULL | PeopleCodeCount |
| PEOPLECODESQLTIME | Number(15,0) | DECIMAL(15) NOT NULL | PeopleCodeSQLTime |
| PEOPLECODETIME | Number(15,0) | DECIMAL(15) NOT NULL | PeopleCodeTime |
| CURRENCY_ROUND | Character(1) | VARCHAR2(1) NOT NULL |
Currency rounding flag
Y/N Table Edit |
| EXECUTE_EDITS | Character(1) | VARCHAR2(1) NOT NULL |
Execute edits flag
Y/N Table Edit |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |