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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19