17 Purging Travel and Expense Data

You can run the Purge Closed PCard Statement Records (P01P801) and Purge Closed Expense Report Records (P01P802) programs to purge records from the Statement File Header (F01P12) and Statement File Detail (F01P121) files on your system.

This chapter includes the following tasks:

17.1 Purging Expense Reports

You can run the Purge Closed Expense Report Records (P01P802) program to purge records from the Travel and Expense Expense Report Header (F01P17) and Travel and Expense Expense Report Detail (F01P171) files on your system.

Navigation

From Travel and Expense Processing (G01P2), choose Purge Expense Reports

17.1.1 Processing Options (P01P802)

See Section 19.12, "Purge Closed Expense Report Records (P01P802)"

17.2 Purging Statements

You can run the Purge Closed Statement Records program (P01P801) to purge transactions from the Statement File Header (F01P12) and Statement File Detail (F01P121) files when the value is 0 in the Number of Items to be Reconciled field in the F01P12.

Enter a date in the Submittal Date Comparison processing option to choose statements prior to this date for purging. If you leave this processing option blank, the program purges all statements.

You can set the Purge Files processing option to save the purged data to purge files for future retrieval or reference. You can save only the header information or both header and detail information.

Navigation

From Travel and Expense Processing (G01P2), choose Purge Statements

17.2.1 Processing Options (P01P801)

See Section 19.11, "Purge Closed PCard Statement Records (P01P801)"

17.3 Purging Transactions

If you do not set the Automatic Purge processing option for the Process Daily Transaction program (P01P560) to purge transactions from the Purchase Card – Bank Transmissions file (F01PBKZ) after they successfully process, you can run version XJDE0049 of the Generic Purge Program (P00PURGE). Each version of P00PURGE has a different based on file and it is imperative you choose the version that contains F01PBKZ in the Based On File field in the Additional Parameters.

The P00PURGE program purges all records from F01PBKZ that have Y in the Processed (Y/N) field.

Navigation

From Travel and Expense Processing (G01P2), choose Transmission Processing

From Transmission Processing (G01P13), choose Purge Transactions

17.3.1 Processing Options (P00PURGE)

See Section 19.13, "Batch File Purge (P00PURGE)"