Co-Operative PeopleTools Table Reference - BAT_TIMINGS_DTL

Table: PS_BAT_TIMINGS_DTL	Return to Index
BAT_TIMINGS_DTL	Return to Index

This table contains a row for each step executed in an Application Engine program. Note: This table is not purged as a part of the process scheduler purge process.

Child of PS_BAT_TIMINGS_LOG

PeopleSoft Field Name Description
PROCESS_INSTANCE Process Instance
BAT_PROCESS_TYPE Process type (Cobol, AE, etc)
A=Application Engine
C=COBOL
BAT_PROGRAM_NAME Program or module name where the source code is located. If the code is from another Application Engine program that has been called, possibly an Application Library, this value may differ from BAT_TIMINGS_LOG.PROCESS_NAME.
Special Values: AE Internal, PeopleCode
BAT_DTL_TYPE Detail type (SQL, PeopleCode)
DETAIL_ID Detail line identifier. This is a reference to the code that is executed..
For Application Engine code, the detail is made up from the section name, step name, and action type.
For PeopleCode, the SQL operation (SELECT, INSERT, DELETE, UPDATE) and the table name involved.
For AE Internal operations: CHECKPOINT, COMMIT, LOGMSG
COMPILE_COUNT Number of Compilations
COMPILE_TIME Total Compilation Time (in milliseconds)
EXECUTE_COUNT Number of Executions
EXECUTE_TIME Total Execute Duration (in milliseconds)
FETCH_COUNT Number of SQL Fetches
FETCH_TIME Total SQL Fetch Time
RETRIEVE_COUNT Number of Retrieve Operations
RETRIEVE_TIME Retrieve Duration (in milliseconds)
BULK_INSERT Bulk Insert Flag
Y/N Table Edit
PEOPLECODECOUNT PeopleCode Execution Count
PEOPLECODESQLTIME Total PeopleCode SQL Time
PEOPLECODETIME Total PeopleCode Time
CURRENCY_ROUND Currency rounding flag
Y/N Table Edit
EXECUTE_EDITS Execute edits flag
Y/N Table Edit
Author: David Kurtz
Return to Index © Go-Faster Consultancy Ltd. Last updated 25 July 2010

PeopleSoft Field Name	Description
PROCESS_INSTANCE	Process Instance
BAT_PROCESS_TYPE	Process type (Cobol, AE, etc) A=Application Engine C=COBOL
BAT_PROGRAM_NAME	Program or module name where the source code is located. If the code is from another Application Engine program that has been called, possibly an Application Library, this value may differ from BAT_TIMINGS_LOG.PROCESS_NAME. Special Values: AE Internal, PeopleCode
BAT_DTL_TYPE	Detail type (SQL, PeopleCode)
DETAIL_ID	Detail line identifier. This is a reference to the code that is executed.. For Application Engine code, the detail is made up from the section name, step name, and action type. For PeopleCode, the SQL operation (SELECT, INSERT, DELETE, UPDATE) and the table name involved. For AE Internal operations: CHECKPOINT, COMMIT, LOGMSG
COMPILE_COUNT	Number of Compilations
COMPILE_TIME	Total Compilation Time (in milliseconds)
EXECUTE_COUNT	Number of Executions
EXECUTE_TIME	Total Execute Duration (in milliseconds)
FETCH_COUNT	Number of SQL Fetches
FETCH_TIME	Total SQL Fetch Time
RETRIEVE_COUNT	Number of Retrieve Operations
RETRIEVE_TIME	Retrieve Duration (in milliseconds)
BULK_INSERT	Bulk Insert Flag Y/N Table Edit
PEOPLECODECOUNT	PeopleCode Execution Count
PEOPLECODESQLTIME	Total PeopleCode SQL Time
PEOPLECODETIME	Total PeopleCode Time
CURRENCY_ROUND	Currency rounding flag Y/N Table Edit
EXECUTE_EDITS	Execute edits flag Y/N Table Edit

Author: David Kurtz
Return to Index	© Go-Faster Consultancy Ltd. Last updated 25 July 2010

BAT_TIMINGS_DTL

Table: PS_BAT_TIMINGS_DTL