BAT_TIMINGS_DTL

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
BAT_PROCESS_TYPECharacter(1)VARCHAR2(1) NOT NULLProcess type (cobol, AE, etc)
A=Application Engine
C=COBOL
BAT_PROGRAM_NAMECharacter(12)VARCHAR2(12) NOT NULLProgram or module name
BAT_DTL_TYPECharacter(1)VARCHAR2(1) NOT NULLDetail type (SQL, Peoplecode)
DETAIL_IDCharacter(100)VARCHAR2(100) NOT NULLDetail line identifer
COMPILE_COUNTNumber(10,0)DECIMAL(10) NOT NULLCount
COMPILE_TIMENumber(15,0)DECIMAL(15) NOT NULLTime (in millseconds)
EXECUTE_COUNTNumber(10,0)DECIMAL(10) NOT NULLCount
EXECUTE_TIMENumber(15,0)DECIMAL(15) NOT NULLTime (in millseconds)
FETCH_COUNTNumber(10,0)DECIMAL(10) NOT NULLSQL Fetch Count
FETCH_TIMENumber(15,0)DECIMAL(15) NOT NULLSQL Fetch Time
RETRIEVE_COUNTNumber(10,0)DECIMAL(10) NOT NULLCount
RETRIEVE_TIMENumber(15,0)DECIMAL(15) NOT NULLTime (in millseconds)
BULK_INSERTCharacter(1)VARCHAR2(1) NOT NULLBulk Insert Flag

Y/N Table Edit

PEOPLECODECOUNTNumber(10,0)DECIMAL(10) NOT NULLPeopleCodeCount
PEOPLECODESQLTIMENumber(15,0)DECIMAL(15) NOT NULLPeopleCodeSQLTime
PEOPLECODETIMENumber(15,0)DECIMAL(15) NOT NULLPeopleCodeTime
CURRENCY_ROUNDCharacter(1)VARCHAR2(1) NOT NULLCurrency rounding flag

Y/N Table Edit

EXECUTE_EDITSCharacter(1)VARCHAR2(1) NOT NULLExecute edits flag

Y/N Table Edit

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19