Notification Data Archiving

Notification data volume can increase significantly over time. To keep the amount of data manageable, the system delivers an archive object, two archive queries and an archive template that are used to archive notification data through Data Archive Manager.

Notification Publisher provides two ways in which records can be archived:

• Based on posting date.

  All notifications posted before a certain date will be archived.

• Based on expiration date.

  All notifications expired before a certain date will be archived.

Delivered Archive Object

An archive object is a collection of tables that you archive. The object definition determines how you archive data from a table. The HCSC_NOTIFICATION_ARCHIVE archive object is delivered for Notification Publisher.

This table lists the archiving records that are delivered for the HCSC_NOTIFICATION_ARCHIVE archive object:

Archiving Record	Description	History Record
HCSC_NOTIF	Notifications and Announcement	HCSC_NOTIF_HST
HCSC_ANNOUNCE	Announcement list	HCSC_ANNOUN_HST
HCSC_NOTIF_ATCH	Notification Attachment Table	HCSC_NOT_AT_HST
HCSC_NOTIF_LINK	Notification links	HCSC_N_LINK_HST
HCSC_NOTIF_RCPT	HR Notification Recipient List	HCSC_N_RCPT_HST

Delivered Archive Queries

PeopleSoft Data Archive Manager uses queries to define selection criteria from the base table of the base archive object.

Two queries are delivered to support data archiving based on posting date or expiration date:

• HCSC_NOTIF_ARCH_DATE_POSTED

• HCSC_NOTIF_ARCH_EXPIRE_DATE

Delivered Archive Template

Archive templates link archive objects and archive queries together. The Notification Publisher feature delivers the HCSC_NOT template for this purpose.

See PeopleTools: Data Management, Using PeopleSoft Data Archive Manager.