Differences between the TR and EH files

The Transaction Data and Employment History Extract files each contain historical PPT transaction data from 1976 forward for your faculty and staff.  The files differ, however, on the type of records and the data elements they contain.  Refer to the chart below for a summary of the file differences.


 Item​Transacti​on Data (TR)Employment History Extract (EH)
TimeframeTransactions effective from January 1, 1976  forwardSame as TR. Transactions can optionally be selected based on key entry date
RecordsExcludes Deleted, Voided, Fixed, Eliminated, A54 and Student transactions  Deleted, Voided, Fixed, Eliminated and A54 transactions can optionally be included  

Data Elements


Selected fields on PPTMost fields on PPT
Common UseThis file could be used to obtain transaction counts and for historical reportingThis file could be used to generate Employment History Summaries, to verify keying and to create a 'point in time' file
Update ScheduleDailyThe source file for the EH extract function is updated immediately upon entry of a PPT
Additional InfoFields not found in the TR file may be available in the EH fileThe EH file must be created with specified parameters before using

Last Updated: February 20, 2024