AE_TIMINGS_DT

(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 DETAIL_ID2 Character(50) VARCHAR2(50) NOT NULL Detail line identifier 2
7 DETAIL_ID3 Character(50) VARCHAR2(50) NOT NULL Detail line identifier 3
8 DETAIL_ID4 Character(100) VARCHAR2(100) NOT NULL Detail line identifier 4
9 DETAIL_ID5 Character(100) VARCHAR2(100) NOT NULL Detail line identifer 5
10 PTPC_SQLLINE Number(10,0) DECIMAL(10) NOT NULL PeopleCodeSQLLine
11 PTPC_EXECLINE Number(10,0) DECIMAL(10) NOT NULL PeopleCodeExecLine
12 COMPILE_COUNT Number(10,0) DECIMAL(10) NOT NULL Count
13 COMPILE_TIME Number(15,0) DECIMAL(15) NOT NULL Time (in millseconds)
14 EXECUTE_COUNT Number(10,0) DECIMAL(10) NOT NULL Count
15 EXECUTE_TIME Number(15,0) DECIMAL(15) NOT NULL Time (in millseconds)
16 FETCH_COUNT Number(10,0) DECIMAL(10) NOT NULL SQL Fetch Count
17 FETCH_TIME Number(15,0) DECIMAL(15) NOT NULL SQL Fetch Time
18 RETRIEVE_COUNT Number(10,0) DECIMAL(10) NOT NULL Count
19 RETRIEVE_TIME Number(15,0) DECIMAL(15) NOT NULL Time (in millseconds)
20 BULK_INSERT Character(1) VARCHAR2(1) NOT NULL Bulk Insert Flag

Y/N Table Edit

21 PEOPLECODECOUNT Number(10,0) DECIMAL(10) NOT NULL PeopleCodeCount
22 PEOPLECODESQLTIME Number(15,0) DECIMAL(15) NOT NULL PeopleCodeSQLTime
23 PEOPLECODETIME Number(15,0) DECIMAL(15) NOT NULL PeopleCodeTime
24 CURRENCY_ROUND Character(1) VARCHAR2(1) NOT NULL Currency rounding flag

Y/N Table Edit

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

Y/N Table Edit