Data Types

Most PeopleSoft Receivables tables contain data keyed either by business unit or TableSet. The tables keyed by business unit accumulate large volumes of data over time. Eventually, you may not need to access some of the data routinely. PeopleSoft Receivables enables you to archive the inactive data on the transaction tables keyed by business unit to the history tables. If you need to access the data later, you can restore it.

The following table lists the tables keyed by business unit. PeopleSoft Receivables delivers archive objects to remove only the first six types of data listed in the table: pending item, payment, posted item, statement, action list, and direct debit data using the PeopleSoft Data Archive Manager.

Note:

To remove the other data types, you must directly remove the records from the database. You can remove the records either by using a SQL script that you write or by creating your own archive objects in PeopleTools and then using the Data Archive Manager.

Type of Data	Description	Tables
Pending item data	Group control, pending item, pending tax information, and pending accounting entries processed by the Receivable Update Application Engine process (ARUPDATE).	PS_GROUP_CONTROL PS_PENDING_ITEM PS_PENDING_VAT PS_PENDING_DST PS_PENDING_TAX PS_PENDING_TAX_DTL PS_PENDING_IT_MRL
Payment data	Deposit and payment information provided during online entry or during the Payment Interface Application Engine process (AR_PAYLOAD).	PS_DEPOSIT_CONTROL PS_PAYMENT PS_PAYMENT_ITEM PS_PAYMENT_ID_CUST PS_PAYMENT_ID_ITEM PS_PAY_MISC_DST PS_PAY_ITEM_MRL PS_EE_DJR_ACCTG_LN
Posted item data	Item information, such as item activity, item tax information, and item accounting entries maintained by the Receivable Update and Aging Application Engine processes (AR_AGING).	PS_ITEM PS_ITEM_ACTIVITY PS_ITEM_ACT_VAT PS_ITEM_DST PS_ITEM_ACTTAX PS_ITEM_ACTTAX_DTL PS_ITEM_AUDIT PS_AR_IPAC_HDR PS_AR_IPAC_SGL PS_AR_IPAC_DETAIL PS_AR_CC_TRAN_HDR PS_AR_CC_TRAN_TBL PS_EE_ITM_ACCTG_LN
Statement data	Customer and item summary data maintained by the Statement Application Engine process (AR_STMTS).	PS_STMT_CUST PS_STMT_CUST_DTL PS_STMT_CUST_BFWD PS_AR_STMT_CUST
Action list data	Actions added to actions lists by the Condition Monitor process (AR_CNDMON) or by entering them on the Item Action page.	PS_ACTION_LST
Direct debit data	Direct debit control and direct debit item data created when you create direct items, run the Receivables Update process, and run the Create Direct Debit process (AR_DIRDEBIT).	PS_DD_CONTROL PS_DD_ITEM PS_DD_ITEM_MRL
Posted customer data	Summary information at a customer level maintained by the Receivable Update and Aging processes.	PS_CUST_AGING PS_CUST_DATA PS_CUST_HISTORY PS_SUBCUST_AGING PS_SUBCUST_DATA PS_SUBCUST_HISTORY
Dunning data	Customer and item summary data maintained by the Dunning Application Engine process (AR_DUNNING).	PS_DUN_CUST PS_DUN_DTL
Overdue charge data	Customer and item summary data maintained by the Overdue Charge Application Engine process (AR_OVRDUE).	PS_OC_CUST PS_OC_CUST_DTL
Conversation data	Summary and detailed information about conversations with customers.	PS_CUST_CONVER PS_CUST_CONV_HDR PS_CUST_CONVER_DTL PS_CUST_CONVER_ATT
Customer Definition data	Required for processing customers.	PS_CUSTOMER PS_CUST_REGN_TYPE PS_CUST_VAT_REG PS_CUST_ADDR_SEQ PS_CUST_ADDRESS PS_CUST_CNTCT_SEQ PS_CUST_CONTACT PS_CUST_CNTCT_TYPE PS_CUST_CNTCT_DOC PS_CUST_CNTCT_CARD PS_CUST_CNTCT_PHN PS_CUST_CREDIT PS_CUST_OPTION PS_CUST_SHIPTO_OPT PS_CUST_SOLDTO_OPT PS_CUST_BILLTO PS_CUST_SHIPTO PS_CUST_CRSPD PS_CUST_CONVER PS_CONVR_DTL PS_KEYWORD_TBL_AR PS_FOLLOWUP_TBL
Message log data	Log messages generated by background processing.	PS_MESSAGE_LOG PS_MESSAGE_LOGPARM