BAT_TIMINGS_DTL

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BAT_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Process type (cobol, AE, etc)
A=Application Engine
C=COBOL
3 BAT_PROGRAM_NAME Character(12) VARCHAR2(12) NOT NULL Program or module name
4 BAT_DTL_TYPE Character(1) VARCHAR2(1) NOT NULL Detail type (SQL, Peoplecode)
5 DETAIL_ID Character(100) VARCHAR2(100) NOT NULL Detail line identifer
6 COMPILE_COUNT Number(10,0) DECIMAL(10) NOT NULL Count
7 COMPILE_TIME Number(15,0) DECIMAL(15) NOT NULL Time (in millseconds)
8 EXECUTE_COUNT Number(10,0) DECIMAL(10) NOT NULL Count
9 EXECUTE_TIME Number(15,0) DECIMAL(15) NOT NULL Time (in millseconds)
10 FETCH_COUNT Number(10,0) DECIMAL(10) NOT NULL SQL Fetch Count
11 FETCH_TIME Number(15,0) DECIMAL(15) NOT NULL SQL Fetch Time
12 RETRIEVE_COUNT Number(10,0) DECIMAL(10) NOT NULL Count
13 RETRIEVE_TIME Number(15,0) DECIMAL(15) NOT NULL Time (in millseconds)
14 BULK_INSERT Character(1) VARCHAR2(1) NOT NULL Bulk Insert Flag

Y/N Table Edit

15 PEOPLECODECOUNT Number(10,0) DECIMAL(10) NOT NULL PeopleCodeCount
16 PEOPLECODESQLTIME Number(15,0) DECIMAL(15) NOT NULL PeopleCodeSQLTime
17 PEOPLECODETIME Number(15,0) DECIMAL(15) NOT NULL PeopleCodeTime
18 CURRENCY_ROUND Character(1) VARCHAR2(1) NOT NULL Currency rounding flag

Y/N Table Edit

19 EXECUTE_EDITS Character(1) VARCHAR2(1) NOT NULL Execute edits flag

Y/N Table Edit