BAT_TIMINGS_DTL

Return to Index

PeopleSoft Field NameField TypeDescription
PROCESS_INSTANCEDECIMAL(10) NOT NULLProcess Instance
BAT_PROCESS_TYPEVARCHAR2(1) NOT NULLProcess type (cobol, AE, etc)
A=Application Engine
C=COBOL
BAT_PROGRAM_NAMEVARCHAR2(12) NOT NULLProgram or module name
BAT_DTL_TYPEVARCHAR2(1) NOT NULLDetail type (SQL, Peoplecode)
DETAIL_IDVARCHAR2(100) NOT NULLDetail line identifer
COMPILE_COUNTDECIMAL(10) NOT NULLCount
COMPILE_TIMEDECIMAL(15) NOT NULLTime (in millseconds)
EXECUTE_COUNTDECIMAL(10) NOT NULLCount
EXECUTE_TIMEDECIMAL(15) NOT NULLTime (in millseconds)
FETCH_COUNTDECIMAL(10) NOT NULLSQL Fetch Count
FETCH_TIMEDECIMAL(15) NOT NULLSQL Fetch Time
RETRIEVE_COUNTDECIMAL(10) NOT NULLCount
RETRIEVE_TIMEDECIMAL(15) NOT NULLTime (in millseconds)
BULK_INSERTVARCHAR2(1) NOT NULLBulk Insert Flag

Y/N Table Edit

PEOPLECODECOUNTDECIMAL(10) NOT NULLPeopleCodeCount
PEOPLECODESQLTIMEDECIMAL(15) NOT NULLPeopleCodeSQLTime
PEOPLECODETIMEDECIMAL(15) NOT NULLPeopleCodeTime
CURRENCY_ROUNDVARCHAR2(1) NOT NULLCurrency rounding flag

Y/N Table Edit

EXECUTE_EDITSVARCHAR2(1) NOT NULLExecute edits flag

Y/N Table Edit

Author: PeopleTools 8.52

Return to Index

© David Kurtz  Last updated 01 August 2015